Displays Identity Column Values
Displays identity column values, number of rows in the table, and the difference between the two. The difference can indicate the amount of deletions that could be going on.
2001-10-21
935 reads
Display Identity Values and Other Info
Displays identity values, number of rows in the table, and the difference between the two. The difference can indicate the amount of deletions that could be going on.
2001-09-06
343 reads
Display Stored Procedure Parameters
Display any stored procedures using input and output parameters. I took the view, PARAMETERS that ships with SQL 2000 and cleaned it up a bit.
2001-09-04
1,244 reads
2001-09-04
530 reads
2001-08-22
400 reads
hx_DatabaseProperties
Displays database properties. Was this the best way of doing it? Probably not, but it works.
2001-08-22
545 reads
hx_dbMaintancePlans
Displays Maintance plan history if any. I used distinct to filter out and return only what is relevent to what I need. You may not wish this for your purposes. Feel free to make changes
2001-08-22
377 reads
2001-08-22
722 reads
2001-08-22
565 reads
2001-08-22
718 reads
Blogs
Sabbatical le Troisième: A Recharge Week
By Steve Jones
It’s been a week since I flew home from London and Redgate to begin...
SQL Server Careers: Still a Goldmine, or a Dead End?
When you're searching about the future of a career in MS SQL Server, you're...
AI Destroying Creativity or Creative Industry
By Rohit Garg
In 2025, artificial intelligence is no longer a futuristic concept—it’s a central force in...
Forums
how to move all SP from one db to another db?
Hi everyone I have two db - one is test and other is archive. ...
The Long Weekend
Comments posted to this topic are about the item The Long Weekend
Need Help to implement the De Duplication
Dear All, Good Day. I have a requirement to implement de-duplication on customer data...
Question of the Day
Independence Day
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers