Generating number sequences
Two queries below show one of many ways how You can generate a sequence of numbers.
2008-01-14
939 reads
Scripts
Check Availability Window - SQL2k5
This script allows you to check the several availability windows for the current day.
2008-01-11 (first published: 2007-10-29)
1,404 reads
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,316 reads
2008-01-04 (first published: 2007-10-27)
924 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,423 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,592 reads
2007-12-27 (first published: 2007-10-23)
1,031 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,098 reads
2007-12-21 (first published: 2007-10-25)
1,435 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,385 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
ALAMAT BCA KCU JAMBI 082225313145 WA CS
WhatsApp 082225313145 Jl. Dokter Sutomo No.50-50A, Ps. Jambi, Kec. Ps. Jambi, Kota Jambi, Jambi...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers