2014-05-28 (first published: 2014-05-02)
2,126 reads
Scripts
List all the fields of a table with its properties + PK
This script returns a list of all the fields of a table with it properties, primary keys and user defined types.
2014-05-23 (first published: 2014-04-30)
1,742 reads
Size of database files for an instance of SQL Server
Size of database files for an instance of SQL Server
2014-05-07 (first published: 2014-04-10)
1,322 reads
Find database where table is located
Return a list of databases which contain a table from wildcard table name.
2014-05-05 (first published: 2014-04-14)
1,201 reads
2014-05-02 (first published: 2014-04-09)
1,789 reads
2014-05-01 (first published: 2014-04-09)
1,513 reads
Format decimal value to fraction using a tally table.
We use a tally table to find the appropriate denominator for a given decimal part of a number.
2014-04-29 (first published: 2014-04-07)
1,202 reads
Exporting data with header using Powershell
Extracting data with header information using PowerShell
2014-04-28 (first published: 2014-04-07)
1,503 reads
2014-04-24 (first published: 2014-04-05)
2,010 reads
Restore script genrator for moving dbs
usefull script for moving databases from one server to another
2014-04-23 (first published: 2014-03-29)
950 reads
Blogs
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...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
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...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
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