2014-12-04 (first published: 2014-11-17)
1,407 reads
William Talada
- Interests: non-dualism
2013-07-03 (first published: 2013-06-07)
845 reads
ASCII Character Groups in String
Powerful function to find strings containing or excluding classes of ASCII characters.
2012-09-10 (first published: 2012-08-28)
1,020 reads
Find botched constraints, idxs, fks
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,449 reads
IsNumber fails cast while IsBigInt passes cast
IsNumber does weak checking and fails cast to BigInt so I wrote IsBigInt to replace it.
2010-06-11 (first published: 2010-05-05)
2,544 reads
Display Rows Vertically or Alphabetically
Display a row vertically when a table has hundreds of columns to avoid scrolling.
2010-01-21 (first published: 2009-12-30)
3,143 reads
datetime precision
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,357 reads
Implementing Most Recently Used Lookups
This script will adapt ordering of look-up lists by foreign key usage.
2010-01-18 (first published: 2009-12-23)
888 reads
Validate Deployed Databases by Version
Save all object definitions to a single stored procedure for easy validation
2010-01-14 (first published: 2009-12-18)
764 reads
2010-01-07 (first published: 2009-12-18)
1,658 reads
Blogs
SQLServerCarpenter Tools
Over the past couple of years, I’ve developed several tools that I’ve been using...
usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON
/* Author:Brahmanand Shukla (SQLServerCarpenter.com) Date:27-May-2022 Purpose:To get all the stored procedures and triggers missing the use of...
A New MVP Led Training Initiative – Cloud Formations
By Arun Sirpal
Hello Readers – I wanted to make sure those who follow my blog have...
Forums
Deploying a standalone Azure VM running SQL Server into an availability zone
If i deploy a standalone Azure VM running SQL Server into an availavility zone;...
SQL Server 2014 Question
So I have inherited an older SQL 2014 Server and have been working on...
Removing UNION and getting the same result
Hi, I need to update my sql script and remove the UNION but get...
Ask SSC