2010-09-08 (first published: 2010-09-02)
2,413 reads
2010-09-08 (first published: 2010-09-02)
2,413 reads
Do you need to take your mind off of the SQL mess you are dealing with? Try my funny words generator.
2010-09-03 (first published: 2010-08-27)
2,693 reads
This script changes the collation of columns to default database collation in all the tables
2010-09-02 (first published: 2010-09-01)
2,223 reads
A script to reveal which logins have access to your sql server via windows groups.
2010-09-01 (first published: 2010-08-26)
2,465 reads
Generates scripts to make text, ntext, varchar and char columns nvarchar/nchar
2010-08-30 (first published: 2010-08-26)
1,410 reads
2010-08-27 (first published: 2010-08-25)
3,722 reads
After scouring the site, and googling until my fingers bled, I finally put together a function that will return the dates when daylight savings time began/ended since at least 1990.
2010-08-26 (first published: 2010-08-19)
2,045 reads
Summary information and metrics for any column in a given Table/View. Metrics include: number of records, distinct records, nulls, min, max, std, quartiles, kurtosis, skew, etc.
2010-08-24
87 reads
Fill a small Tally table with a 1 column primary key using GO keyword to repeat an insert.
2010-08-18 (first published: 2010-08-16)
1,575 reads
2010-08-16 (first published: 2010-03-05)
3,916 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers