Script to Search Through all Databases for a Table Name
This script will search the entire server and give the name and schema of the database where the table exists.
2012-06-25 (first published: 2012-06-09)
1,485 reads
Scripts
The joy of sp_spaceused
This script uses a cursor to loop through all tables and get the count and table sizes using sp_spaceused. It is much faster and efficient than use 'SELECT COUNT(*) FROM TABLE_NAME'.
2012-06-22 (first published: 2012-06-09)
1,993 reads
Delete Duplicates in SQL 2000, SQL 2005, SQL 2008 or Higher
Delete Duplicates in SQL Server without using Cursor or Temporary tables
2012-06-21 (first published: 2006-11-22)
3,255 reads
2012-06-20 (first published: 2012-05-30)
8,769 reads
Script to calculate Precision & Scale of a Decimal Value
A script to help you find the Precision & Scale parts of a decimal value.
2012-06-19 (first published: 2012-06-04)
5,007 reads
Generate insert statements with column names for any or all tables
Generate a script of insert statements with column names for any table including those with identity columns.
2012-06-15 (first published: 2012-05-22)
3,148 reads
Random DEFAULT string for a column using CASE and NEWID
Sometimes you just need to populate a CHAR/VARCHAR column for testing with a random selection of string literals at table CREATE time. Here is a quick and easy script.
2012-06-14 (first published: 2008-01-16)
1,185 reads
A CONCAT Function For The Rest Of Us
SQL Server 2012 introduces a new string concatenation function. This can be recreated in earlier versions of SQL Server.
2012-06-06 (first published: 2012-05-16)
2,177 reads
Central Management Server Daily Script
These are scripts I run each morning on my registered CMS servers to check immediate health.
2012-06-04 (first published: 2012-05-09)
2,901 reads
Variable Grouping Using a Case Statement
The code below uses a CASE STATEMENT to group sales data based on date,week,month and quarter. It should be executed in AdventureWorks 2005 or 2008.
2012-05-30 (first published: 2012-05-10)
2,047 reads
Blogs
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...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Alamat BCA KCP Dewi Sartika Tlp:08218200233
Telp/WA 62 8218200233 Jl. Dewi Sartika No.189, RT.1/RW.5, Wil, Kec. Kramat jati, Kota Jakarta...
Alamat Kantor BCA KCP MT Haryono Tlp:08218200203
Telp/WA 62 8218200203 Gedung Patria Park Jl. D.I. Panjaitan Kav. 5-6-7, Rukan-MZ No.RK 01...
Alamat BCA KCP Pondok Gede Tlp:08218200174
Telp/WA 62 8218200174 Jl. Raya Pd. Gede No.43, RT.1/RW.7, Lubang Buaya, Kec. Cipayung, Kota...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers