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
375 reads
2001-08-22
722 reads
2001-08-22
563 reads
2001-08-22
717 reads
Blogs
Comparing Microsoft Fabric Alternatives in AWS, GCP, and OCI in 2025
By Daniel Janik
Microsoft's unified analytics platform, Fabric, simplifies integration across various tools in Azure by offering...
Techno Security East: Quantum Computing Slides
By Brian Kelley
I always try and ensure that I post my slides to my talks here...
A Basic Update Trigger: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
Forums
SSIS raw file conversion
Hi, Does anyone know how to handle a raw data file where some rows...
Force Strict Encryption - SQL Agent fails
Hi, On my SQL 2022 (16.0.4195.2) test environment, I tried to enable Force Strict...
Error converting data type varchar to float
Hi everyone I have a bunch of CSV files that I need to import...
Question of the Day
How Many Nested Triggers?
I have DDL trigger code that I'm working on in SQL Server 2022, but I am concerned that we might end up with multiple triggers firing and the response to the user is delayed. If I want to check how many triggers have fired, or are nested, how can I do this in my code?
See possible answers