View connection and Locking Information
This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address
2010-05-17 (first published: 2009-06-23)
2,495 reads
This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address
2010-05-17 (first published: 2009-06-23)
2,495 reads
This is an effort to program the "Estimating the Table size" section given in BOL.
2009-07-06 (first published: 2009-06-19)
1,779 reads
2008-11-25 (first published: 2008-10-20)
1,313 reads
I need to migrate from a single server to a flex server. Instead of...
By Steve Jones
An interesting AI experiment here with Copilot from GitHub in handling some code I...
SQL is essential for modern businesses and applications that rely on data. It's a...
Comments posted to this topic are about the item The Vast Expansions of Hardware
Comments posted to this topic are about the item Code Blocks
Hi we built a gateway from sql server to netsuite using an oracle competitor's...
What happens with this code:
DECLARE @Iteration INT = 0; WHILE @Iteration < 10 SELECT CustomerName, CustomerStatus FROM dbo.Customer WHERE CustomerID > 3; SET @Iteration += 1;See possible answers