Display Rows Vertically or Alphabetically
Display a row vertically when a table has hundreds of columns to avoid scrolling.
2010-01-21 (first published: 2009-12-30)
3,409 reads
Scripts
datetime precision
Accuracy and precision go hand-in-hand. This script helps trim date values to whatever size is stored in a table's column.
2010-01-20 (first published: 2009-12-21)
1,536 reads
Implementing Most Recently Used Lookups
This script will adapt ordering of look-up lists by foreign key usage.
2010-01-18 (first published: 2009-12-23)
1,000 reads
Validate Deployed Databases by Version
Save all object definitions to a single stored procedure for easy validation
2010-01-14 (first published: 2009-12-18)
799 reads
return a file Last Modified Date
This function takes a UNC file as a parameter and return the last modified date
2010-01-13 (first published: 2009-12-17)
2,590 reads
Store Procedure Output in a Table
This script show a demonstration of how to interst tore Procedure Output in a Table.
2010-01-08 (first published: 2009-12-18)
2,506 reads
2010-01-07 (first published: 2009-12-18)
1,746 reads
SQL Server Agent Schedule Decoder
This script will break job schedules down into a readable format (msdb.dbo.sysschedules)
2010-01-06 (first published: 2009-12-16)
1,994 reads
Find weak login passwords in your server
Use this script to search for SQL Server logins who use weak password
2010-01-05 (first published: 2009-12-16)
4,454 reads
Script to Compress Tables and Indexes
This script creates scripts to compress all tables and indexes in a database.
2010-01-04 (first published: 2009-12-11)
15,948 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Alamat BCA KCU TANGERANG Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Kisamaun No.57, RT.001/RW.006, Sukasari, Kec. Tangerang, Kota Tangerang, Banten 15118
Alamat BCA KCP Anyer Telp:0821°7555°651
Telp/WA 628217555651 Jl. Raya Anyer-Sirih Kp. Gudang Areng, RT.04/RW.05, Anyar, Kec. Anyar, Kabupaten Serang,...
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers