Prepare one box Virtual lab to evaluate SQL Server Denali Always-ON Features
This series of Videos will walk through on how to prepare one box HyperV lab to understand, evaluate & validate SQL...
2011-02-02
709 reads
This series of Videos will walk through on how to prepare one box HyperV lab to understand, evaluate & validate SQL...
2011-02-02
709 reads
Summary
I get lot of queries from DBA’s asking what is the quickest way to figure out issue on SQL Server....
2011-01-05
1,428 reads
2011-01-05
5 reads
2011-01-05
4 reads
2011-01-05
11 reads
If select into clause is used into transactions till the transaction commits sysobjects table can not acceses directly.It can be accessed only with 'nolock' hint.
2002-06-07
1,086 reads
This procedure will return size of the data files & log files of the database and tempdb. This is returned in one resultset so you can use this procedure to store fluctuation in database sizes.
2002-05-01
1,764 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item Optimism Without Illusion or Why...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers