SSDT DevPack - Highlight expensive queries
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-22
71 reads
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-22
71 reads
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-22
25 reads
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-22
15 reads
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially slow or has a high IO or CPU cost...
2015-11-22
3 reads
I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and...
2015-11-23 (first published: 2015-11-17)
2,215 reads
I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and...
2015-11-17
27 reads
I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and...
2015-11-17
25 reads
I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and stub tests. If you open a stored procedure in...
2015-11-17
4 reads
Automatically name primary key constraints
There are some things you see when writing t-sql code and schemas that just look sloppy,...
2015-11-16
444 reads
Automatically name primary key constraints There are some things you see when writing t-sql code and schemas that just look...
2015-11-16
24 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