2014-12-04 (first published: 2014-11-17)
1,411 reads
2014-12-04 (first published: 2014-11-17)
1,411 reads
2013-07-03 (first published: 2013-06-07)
851 reads
Powerful function to find strings containing or excluding classes of ASCII characters.
2012-09-10 (first published: 2012-08-28)
1,033 reads
Shows awesome view of columns with constraints and indexes and foreign keys to spot errors fast.
2010-08-04 (first published: 2009-12-03)
1,451 reads
IsNumber does weak checking and fails cast to BigInt so I wrote IsBigInt to replace it.
2010-06-11 (first published: 2010-05-05)
3,142 reads
Display a row vertically when a table has hundreds of columns to avoid scrolling.
2010-01-21 (first published: 2009-12-30)
3,225 reads
Accuracy and precision go hand-in-hand. This script helps trim date values to whatever size is stored in a table's column.
2010-01-20 (first published: 2009-12-21)
1,425 reads
This script will adapt ordering of look-up lists by foreign key usage.
2010-01-18 (first published: 2009-12-23)
938 reads
Save all object definitions to a single stored procedure for easy validation
2010-01-14 (first published: 2009-12-18)
766 reads
2010-01-07 (first published: 2009-12-18)
1,704 reads
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Can anyone recommend an Azure SQL Managed Instance book? I'm looking for information about...
hi we run 2019 std but i'm testing this on 2016. following some old...
If you run this code it creates a 2 row cursor loop. Within the...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers