2011-10-12 (first published: 2011-08-31)
945 reads
Scripts
2011-10-10 (first published: 2011-08-24)
834 reads
Get Modified Objects As on Date
This table Valued Function return the Modified Objects (SP /Views) For the Date specified.
2011-10-07 (first published: 2007-11-23)
1,387 reads
2011-10-06 (first published: 2007-11-14)
1,935 reads
Using sys.dm_exec_requests to estimate completion time for a process
The following script is used to check on the progress of a database restore, backup and other processes currently executing on SQL Server.
2011-10-05 (first published: 2011-09-09)
7,663 reads
Generating number sequences with Common Table Expressions
The script shows one of ways generating number sequence - this one uses CTE.
2011-10-04 (first published: 2008-02-06)
1,944 reads
Getting Age in Text or Date Difference in text format
This function returns the difference between the date in text format
2011-10-03 (first published: 2011-08-30)
1,035 reads
2011-10-03 (first published: 2008-03-27)
7,194 reads
Copy Multiple objects from One Schema to Another Schema
Copy Multiple objects from One Schema to Another Schema
2011-09-30 (first published: 2011-09-07)
1,548 reads
Function to Expand Tab Characters
A function to replace tab characters with the correct number of spaces to align the text as originally intended.
2011-09-29 (first published: 2007-10-11)
2,221 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers