Recently, one of our customers came across an interesting issue which many of us face while working with Reporting Services which fetches the data from Analysis Services cube using MDX. So I thought I will share this in this blog post for the benefit of the community. We have a following MDX query with Calculated…
Recently, we had the above question raised from one of our customers and I answered his question with the following answer which I think should be a good candidate for a blog post since many customers might have the same question as well SCCM 2007 database doesn’t supports Unicode characters yet. Hence in ConfigMgr, Language…
It has been really long time since I posted my last blog and even though I do intend to blog more often, i couldn’t do it as much as I would like. Anyways I will try my best to blog as often as I can. In this post, I would like to mention small tips…
Recently for one of our customers we had to perform a DR drill activity. To give a background on the environment, they were using SQL 2000 Database as a backend of SAP Application and the SQL Database was log shipped to Remote DR server. We had also customized the Log Shipping to add compression/decompression logic…
It has been pretty long time since I blogged and also I regret a lot of not being able to spend sufficient time for my blogs.Hopefully I will be able to blog more frequently very soon. Recently one of my customer had a requirement to calculate the duration between a column Starttime and Endtime while…
Off Late, I am not able to update this blog as frequently as I would have liked to as I was some of personal work and lot of professional work. However most customers ask me this question on what performance counters do we need to monitor in order to troubleshoot performance issues with SQL Server…
One of our Customers ran into this issue where in he killed a Reindexing Job and following that it went into KILLED/ROLLBACK State and was in that State for more than 9 hours. First of all we would not recommend you to kill Job like Reindexing or DBCC CHECKDB which performs internal operations. However…
Recently one of our customers ran Bulk insert into one of their databases which was in merge replication and later on found that Merge replication has stopped working. 1. When data is loaded into tables using the bcp Utility or the BULK INSERT command, by default, the merge replication triggers that maintain tracking data…
Recently I was delivering a workshop and this question came from one of the participants Will NoLock Hint allow me to query a table which is undergoing offline reindexing? My instant answer to that was NO, we cannot query a table with or without NOLOCK hint while we are performing Offline reindexing but I…
My Field Job gave me this observation that many Customers have this misconception that whenever a Full Database backup is taken for a database in Full Recovery mode, it truncates the Tlog and hence breaks the Tlog backup chain which is so untrue. In this post I am going to clarify the same One…