“How many DMV and DVF are there in SQL Server 2008?” – this question was asked to me in one of the recent SQL Server Training.
SQL SERVER – Four Posts on Removing the Bookmark Lookup – Key Lookup
Recently, I have observed that not many people have proper understanding of what is bookmark lookup or key lookup. Increasing numbers of the questions tells me that this is something that developers encounter every single day, but have no idea how to deal with. I have previously written three posts…
Read MoreSQL SERVER – Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index
This blog is in response to the ongoing communication with the reader who had earlier asked the question of SQL SERVER – Disable Clustered Index and Data Insert. The same reader has asked me the difference between ALTER INDEX ALL REBUILD and ALTER INDEX REBUILD along with disabled clustered index.…
Read More
SQL SERVER – Spatial Database Queries – What About BLOB
Michael Coles is one of the most interesting book authors I have ever met. He has a flair of writing complex stuff in a simple language. There are a very few people like that. I really enjoyed reading his recent book, Expert SQL Server 2008 Encryption. I strongly suggest taking a look at it. Let us learn about Spatial Database Queries.
SQL SERVER – Size of Index Table for Each Index – Solution 2
Earlier I had ran puzzle where I asked question regarding size of index table for each index in database over here SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table. I had received good amount answers and I had blogged…
Read MoreSQLAuthority News – MSDN Flash Mentions – TechNet Flash Mention – Top Community Contributors (Annual) Winner
I was going over my email to reach the famous Inbox (0), and I happened to come across TechNet Flash and MSDN Flash emails. I had kept them because those email editions had my names mentioned in them. Immediately, I took the screenshot of these. I am posting them here…
Read MoreSQLAuthority News – SQL Server 2008 R2 Hosted Trial
This is a bit old news but for me but it will new for many of you know. SQLPASS, Dell, Microsoft and MaximumASP has come together and build hosted environment for free to all of us to use and experiment with. Register now to try out up to seven labs:…
Read More