How to find who is using/eating up the Virtual Address space on your SQL Server
Well, this is often a tricky situation, where you are running into Virtual Address Fragmentation and getting OOM (out-of-memory) errors …
Monthly Archives: February 2010
How to remove unwanted Quotation Marks while importing a data file
I have had multiple questions on how users wanted to remove the quotation marks while importing the data into a …
How to identify the SQL Server version from a Profiler Trace
You use certain little tips and tricks with the SQL Server tools which are not documented anywhere. This is one …
CHECKDB with Repair Allow Data Loss: Should I shoot myself?
Over the past years, I have seen multiple DBAs execute DBCC CHECKDB with REPAIR ALLOW DATA LOSS to repair the …
