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 … Continue reading
Category Archives: Uncategorized
I killed Reindexing Job and now it is in KILLED/ROLLBACK State for more than 9 hours Tweet
TweetOne 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 … Continue reading
Becareful while running Bulk Operations on a database which is in merge replication Tweet
TweetRecently 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 … Continue reading
Will NoLock Hint allow you to query a table which undergoing offline reindexing? Tweet
TweetRecently 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 … Continue reading
Did you know: A Full Database Backup for a database in Full Recovery model don’t truncate the T-Log and hence doesn’t break Log backup chain Tweet
TweetMy 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 … Continue reading
Did you know: Changing your database to Full Recovery Model will not effect until we take Full Database Backup Tweet
TweetHi All, In my today’s post I will be explaining a very basic stuff which we are expected to know but sometimes we may miss out on it and can lead to adverse consequences. My Field experience tells me … Continue reading
How to query Active Directory to fetch more than 1000 rows using Sql Server–Part I Tweet
TweetRecently there was a requirement from one of my customers to query Active Directory and load the data into a table in sql server. To be honest I am not developer so I started researching on the topics over … Continue reading
How to query Active Directory to Fetch more than 1000 rows using Sql Server–Part II Tweet
TweetContinuing from where I left in my previous post. The Stored Procedure mentioned in my previous post cannot be used to query pwdlastset from AD since it is stored in Integer8Date format which cannot be interpreted by sql server. … Continue reading
Fragmentation should not be the only factor which decides the Rebuild Index
TweetUntil now I was under the impression that fragmentation in the Index is the only factor which decides whether we should rebuild the index. As a rule of thumb we always recommend that when the avg_fragmentation_in_percent in the view … Continue reading
Fragmentation on Index in Sql Server
TweetHi All, It has being quite some time since I added a new post since off late I am not spending much of time on research. But I have started my research again and in this post I will … Continue reading