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-27 (first published: 2015-11-22)
1,726 reads
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-27 (first published: 2015-11-22)
1,726 reads
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-22
72 reads
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-22
26 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
4 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,217 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
5 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
Day 1 is an absolute thrill at re:Invent! I normally dedicate this dynamic day...
With all the changes that have happened with VMware since the Broadcom acquisition I...
Each year around this time, companies enter the familiar ritual of budgeting. For many,...
Comments posted to this topic are about the item Adding a Lot of Seconds
Comments posted to this topic are about the item SQL Server Licensing is Simple,...
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
When does this code work and when does it fail?
DECLARE @BaseDate DATETIME = '1900-01-01'; SELECT DATEADD(SECOND, 2147483648, @BaseDate) AS [MaxIntSecondsAdded];See possible answers