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,650 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,943 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,034 reads
2011-10-03 (first published: 2008-03-27)
7,192 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,547 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,219 reads
Blogs
PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Forums
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers