I have written stored procedure which simply read each row one by one and update the some column in same table.SP is running fine in SQL Server 2000 and completed within 5 minutes (around 5 million rows)But same SP in SQL Server 2005, its taking around more than one hour (for same number of rows)Note: […]
2007-07-16
511 reads
The other day I came across an interesting repo on github, KubeDiagrams. What this...
By Steve Jones
I wrote about getting the Redgate Test Data Manager set up in 10 minutes...
SQL Server migrations are a headache, ask anyone who’s been through the pain of...
Comments posted to this topic are about the item Counting Bits II
Comments posted to this topic are about the item Unreliable Narrators
Comments posted to this topic are about the item Understanding Data Type Conversion Functions...
What is the result of this query in SQL Server 2022+?
select bit_count('7') See possible answers