2012-08-23 (first published: 2008-06-05)
1,715 reads
Scripts
2012-08-22 (first published: 2008-03-24)
1,905 reads
Identify Unique Columns
Tool to automatically query combinations of columns in your table to determine candidate for unique key.
2012-08-21 (first published: 2008-01-28)
2,939 reads
Display Names and Locations of SQL Database Files and DB Owners
Displays the names of all of the SQL databases on a SQL Server instance, their data and transaction log files, their owner, and their physical locations.
2012-08-20 (first published: 2012-07-27)
1,606 reads
Trim Left Char (for single words)
Remove the first replications of a specified char in a word. It does not work well with text that contains blank spaces in the middle.
2012-08-16 (first published: 2012-08-02)
961 reads
Script to get an ordered list of all stored procedures with parameters
Generate a per-schema, per-procedure ordered list of all stored procedures for the current database, together with their parameters, datatypes and nullability.
2012-08-14 (first published: 2012-08-08)
2,263 reads
List of objects from particular schemas
This helps to get list of all objects in a particular schemas.
2012-08-13 (first published: 2012-08-08)
1,166 reads
2012-08-10 (first published: 2012-07-31)
1,794 reads
2008 Index Rebuild using DMV
Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.
2012-08-09 (first published: 2012-07-26)
1,667 reads
Calculate alphabetic sequence
This simple function allows to calculate a code sequence of letters. AAA, AAB, AAAC, ADF, .... AAZ, ABA, ABC, ... ZZZ
2012-08-08 (first published: 2012-07-25)
976 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 KCP Pasar Minggu Center Tlp:08218200203
Telp/WA 62 8218200203 Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta...
Alamat Kantor BCA KCP Santa Telp:0821-8200-233
Telp/WA 62 8218200233 Jl. Wolter Monginsidi No.54, RT.2/RW.4, Petogogan, Kec. Kby. Baru, Kota Jakarta...
Alamat BCA KCP Buaran Raya Telp:0821-8200-174
Telp/WA 62 8218200174 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec....
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