Using the OUTPUT clause to retrieve new identity values from SQL Server 2008
Microsoft has a new KB article outlining issues with using SCOPE_IDENTITY and @@IDENTITY to retrieve values inserted into an identity...
2010-03-03
2,731 reads
Microsoft has a new KB article outlining issues with using SCOPE_IDENTITY and @@IDENTITY to retrieve values inserted into an identity...
2010-03-03
2,731 reads
I attended and presented at the Rocky Mountain Tech Trifecta yesterday, where I had a very nice time. Julie Yack...
2010-02-28
1,479 reads
Since I like to measure and monitor things (maybe that is why I am a DBA), and I care about...
2010-02-28
1,565 reads
Here is the script that has the diagnostic queries that I will be using during my presentation at the Rocky...
2010-02-26
2,762 reads
I have a fairly busy schedule of upcoming speaking events (especially for someone with a full-time day job).
I will be...
2010-02-24
916 reads
Data compression is an Enterprise Edition only feature that was added in SQL Server 2008. It allows you to use...
2010-02-22
2,107 reads
After seeing an interesting blog post on AnandTech IT last week that showed slower query response time in x64 SQL...
2010-02-22
3,438 reads
The Windows Server Division blog has a post up trumpeting a very impressive iSCSI benchmarking result achieved with Intel hardware...
2010-02-21
931 reads
Microsoft has provided a free tool that allows you to easily create a SQL Azure database, and then synchronize the...
2010-02-19
1,562 reads
Microsoft’s David Robinson has announced on the SQL Azure Team Blog that they have released Service Update 1 for SQL...
2010-02-19
520 reads
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
i have subscription of github copilot which i can access in vs 2022 comunity...
Comments posted to this topic are about the item Password Guidance
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers