2008-09-30 (first published: 2008-07-24)
893 reads
Scripts
Getting schemas for your tables
A short script you can incorporate into any 2005/2008 code to get the full schema.table.
2008-09-29
666 reads
Script to return Rows count from table using sp_ExecuteSQL
Script to return Rows count from table using sp_ExecuteSQL
2008-09-26 (first published: 2008-07-20)
1,545 reads
Using Triggers for Detective Work
When a value is changed that causes an error, finding what caused the error can be tricky. Here an application was truncating a column. The trigger helped to identify the culprit.
2008-09-25 (first published: 2008-07-17)
1,404 reads
Checking fragmented indexes
A quick script to check for fragmentation in a database and generate a list of defrag statments you can run.
2008-09-24
2,479 reads
2008-09-19 (first published: 2008-07-20)
1,495 reads
2008-09-18 (first published: 2008-07-15)
711 reads
2008-09-16
339 reads
Create string from table
This simple script retrieves a range of values from a table and presents the results as a string.
2008-09-15 (first published: 2008-07-16)
1,630 reads
Get DBMail information
get the profile name and the account name etc about the dbmails created on the server
2008-09-12 (first published: 2008-07-13)
1,004 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
Alamat BCA KCU PURWOKERTO Tlp:0817825533
WA CS 62817825533 Alamat Jl. Jend. Sudirman No.391 A, Brubahan, Purwanegara, Kec. Purwokerto Tim.,...
Alamat BCA KCU SOLO BARU Tlp:08217555651
WA CS 628217555651 Alamat Kawasan Terpadu The Park, Jl. Ir. Soekarno, Solo Baru, Madegondo,...
Alamat Kantor BCA KCU CILACAP Tlp:08218154374
WA CS 628218154374 Alamat Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers