SMS Script
This script will modify INI file on destops through SMS push to point server connection from A to B.
2008-01-09 (first published: 2007-10-29)
1,296 reads
Scripts
Script for all Foreign Keys of all tables of a DB
Foreign Keys of all tables in a database? with? table? name? and? column? name??
2008-01-08 (first published: 2006-12-27)
1,040 reads
2008-01-04 (first published: 2007-10-27)
908 reads
Automatically generate SUID procs for any table
This proc generates SELECT, UPDATE, INSERT, and DELETE procs for any given table.
2008-01-02 (first published: 2007-11-08)
1,383 reads
Split by Row & Field delimitters
Like my tdard split but this will take a string and split it by 2 delimiters
2007-12-28 (first published: 2007-11-13)
1,576 reads
2007-12-27 (first published: 2007-10-23)
1,003 reads
Bit Manipulation Functions (4)
Four bit manipulation functions:
1. Turn bit ON
2. Turn bit OFF
3. Check if bit is ON
4. Toggle bit ON/Off
2007-12-25 (first published: 2007-11-01)
1,068 reads
2007-12-21 (first published: 2007-10-25)
1,407 reads
Update Statistics - All Tables (No System)
This proc executing the update statistics command in all user tables (no system).
2007-12-20 (first published: 2007-10-24)
2,370 reads
2007-12-18 (first published: 2007-10-18)
2,667 reads
Blogs
Book Review – Microsoft Power BI Performance Best Practices
I was asked to do a review of the book Microsoft Power BI Performance...
SQL Server Distributed Availability Groups and Kubernetes
A while back I wrote about how to use a Cross Platform (or Clusterless)...
Introducing SQL Server 2025 - Enterprise Ready AI
Introducing SQL Server 2025 - Enterprise Ready AI SQL Server 2025 is an upcoming...
Forums
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
A Strange Result
Comments posted to this topic are about the item A Strange Result
Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing
First time here...hoping I can find some direction and answers so I can devise...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers