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
933 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
339 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,239 reads
2001-09-04
527 reads
2001-08-22
399 reads
hx_DatabaseProperties
Displays database properties. Was this the best way of doing it? Probably not, but it works.
2001-08-22
544 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
372 reads
2001-08-22
721 reads
2001-08-22
560 reads
2001-08-22
712 reads
Blogs
The Data API Builder Start and Add Extensions in VS Code
By Steve Jones
One of the things that I like about the Data API Builder (DAB) is...
Using OneLake for Excel Files in Microsoft Fabric
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
Another AI Faux Pax
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
Forums
Counting Bits
Comments posted to this topic are about the item Counting Bits
Can You Become a More Productive Engineer?
Comments posted to this topic are about the item Can You Become a More...
Boosting Data Accuracy: Resolving Common Data Quality Issues Using SQL
Comments posted to this topic are about the item Boosting Data Accuracy: Resolving Common...
Question of the Day
Counting Bits
What does the BIT_COUNT function do in SQL Server?
See possible answers