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,423 reads
Display a row vertically when a table has hundreds of columns to avoid scrolling.
2010-01-21 (first published: 2009-12-30)
3,423 reads
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,550 reads
This script will adapt ordering of look-up lists by foreign key usage.
2010-01-18 (first published: 2009-12-23)
1,009 reads
Save all object definitions to a single stored procedure for easy validation
2010-01-14 (first published: 2009-12-18)
806 reads
This function takes a UNC file as a parameter and return the last modified date
2010-01-13 (first published: 2009-12-17)
2,596 reads
This script show a demonstration of how to interst tore Procedure Output in a Table.
2010-01-08 (first published: 2009-12-18)
2,514 reads
2010-01-07 (first published: 2009-12-18)
1,759 reads
This script will break job schedules down into a readable format (msdb.dbo.sysschedules)
2010-01-06 (first published: 2009-12-16)
2,002 reads
Use this script to search for SQL Server logins who use weak password
2010-01-05 (first published: 2009-12-16)
4,469 reads
This script creates scripts to compress all tables and indexes in a database.
2010-01-04 (first published: 2009-12-11)
15,971 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Telp/WA 628217555651 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
Telp/WA 62817825533 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
Comments posted to this topic are about the item Server-level Roles
In SQL Server 2025, can I alter a fixed server role?
See possible answers