Reseeding Identity values
This Script inturn generates Script to Reseed the values of identity column
2007-11-02 (first published: 2007-08-03)
752 reads
Scripts
How to insert and update from remote linked server
Please read the how to use. unfortunately the orignal document i submitted was truncated 🙁
and i dont have time to remember what i said
2007-10-30 (first published: 2007-08-07)
2,659 reads
Create Log tables and Triggers
Usually in business applications it is necessary to maintain the history of the data being modified for auditing purposes or for later analysis. Proven way to achieve this is to create a log table for each datatable with an additional column "Action" to indicate what the user has done on the data (either insert, update […]
2007-10-26 (first published: 2007-08-09)
6,316 reads
Find Table Usage
Creates a printable report of all stored procedures, views, triggers and user-defined functions that reference any of the tables passed into the procedure.Wrote this to easily list items affected by table changes when working in a fast-paced development environment developing a shrink wrapped product undergoing many schema changes.Split function is listed after sp definintion
2007-10-23 (first published: 2005-07-27)
3,345 reads
Find Column Name Usage
This procedure produces a formatted report to list which tables, views and table functions have a column of the specified name. This is particularly useful in systems that do not enforce referential integrity or when schema changes are being evaluated.
2007-10-22 (first published: 2007-07-19)
4,193 reads
2007-10-19 (first published: 2007-07-25)
9,362 reads
MOM 2005 Datawarehousing Catchup
I wrote this script because our MOM Datawarehousing got so damn behind.Every time the windows Scheduled task tried to run to warehouse the dataout of OnePoint, it would puke because the SQL log would fill up. Thisallows you to start so many days out and it will increment it down by the number of days […]
2007-10-18 (first published: 2007-07-26)
1,415 reads
setting full text search using script
This script will help you to understand how to set & use full text search.
2007-10-18
604 reads
MOM SCDWgroom Enhancement
It might not be useful now, but if you ever wanted to downsize the amount of data that you keep in your datawarehouse, good luck. This will help you do that. This job is set to shrink it down to 120 days, but you can adjust it as you like. Runs again in 5 day […]
2007-10-16 (first published: 2007-07-26)
563 reads
How to empty database
Sometimes you need to empty the content of database. Following script can do that for you.
2007-10-15
4,909 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers