Check Availability Window - SQL2k5
This script allows you to check the several availability windows for the current day.
2008-01-12 (first published: 2007-10-29)
1,383 reads
Scripts
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,310 reads
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,056 reads
2008-01-04 (first published: 2007-10-27)
920 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,407 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,586 reads
2007-12-27 (first published: 2007-10-23)
1,025 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,085 reads
2007-12-21 (first published: 2007-10-25)
1,425 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,377 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers