2011-01-14 (first published: 2010-12-28)
1,586 reads
2011-01-14 (first published: 2010-12-28)
1,586 reads
I needed to run an ssis package / job on many dates that were not consistent and initially started creating dozens of job schedules before coming up with this idea...
2011-01-13 (first published: 2010-12-29)
1,283 reads
Consider you have 100+ tables in your database, you want to find a quick way to find no. of rows in each table
2011-01-11 (first published: 2010-12-22)
2,487 reads
It will display the multiple
rows values in one row value.Like if there are 5 rows with values then that will be displayed in single row with specified separator.
2011-01-10 (first published: 2010-12-23)
3,653 reads
This procedure creates insert statements for the given table and given range of values of primary key column.
2011-01-07 (first published: 2010-12-23)
3,033 reads
This script create Job and backup the database.This job backup the database.This job is scheduled for particular time.
2011-01-06 (first published: 2010-12-23)
2,117 reads
2011-01-03 (first published: 2010-12-15)
3,013 reads
2010-12-30 (first published: 2010-03-18)
2,518 reads
Simple script formatting the date and naming a backup file path for a t-log and restoring those logs.
2010-12-29 (first published: 2010-12-15)
1,533 reads
A short procedure for your tools database. Use it to test connectivity to linked servers.
2010-12-28 (first published: 2010-03-19)
6,845 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