Move End of Month file from source to destination
The script below executes on the first of every month and moves files from source to destination location.
2014-07-24 (first published: 2014-06-16)
953 reads
Scripts
2014-07-23 (first published: 2014-06-17)
1,772 reads
2014-07-22 (first published: 2014-05-16)
2,006 reads
Object dependencies in xml format
Most of the people know about the right-click option 'View Dependencies' in the SQL Management Studio.
It will diplay expandable tree off all dependencies each way. Correct me if I'm wrong, but I couldn't find any other way to save this othere than taking a screenshot of the window.
2014-07-21 (first published: 2014-05-19)
933 reads
Caching and paging a SQL Result Set
This is an example of how to Cache Query results on the Server side
then page though the results
2014-06-06 (first published: 2014-05-05)
2,259 reads
Start a job at a defined step on another sql instance
this is a powershell script that can start a job at a defined step name (default will be step 1), on a network instance either on a network on locally.
2014-06-04 (first published: 2014-05-05)
776 reads
2014-05-30 (first published: 2014-05-05)
1,479 reads
2014-05-28 (first published: 2014-05-02)
2,122 reads
List all the fields of a table with its properties + PK
This script returns a list of all the fields of a table with it properties, primary keys and user defined types.
2014-05-23 (first published: 2014-04-30)
1,736 reads
Size of database files for an instance of SQL Server
Size of database files for an instance of SQL Server
2014-05-07 (first published: 2014-04-10)
1,321 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers