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
938 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
348 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,248 reads
2001-09-04
533 reads
2001-08-22
405 reads
hx_DatabaseProperties
Displays database properties. Was this the best way of doing it? Probably not, but it works.
2001-08-22
550 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
380 reads
2001-08-22
724 reads
2001-08-22
568 reads
2001-08-22
726 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers