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
Scripts
2001-09-04
527 reads
Handling Delimited Strings in T-SQL
There may be cases where you want to work with delimited strings in T-SQL. Following two examples will cover most of the stuff that you will face while working with strings.
2001-09-01
3,161 reads
Detect and Alert DBA of Blocking SPIDS
This script will detect and alert the DBA of blocking processes. The DBA can adjust the length of time the block has exisited before sending the net send message.
2001-08-29
5,199 reads
Script to obtain datadictionary from a SQL2000 db
This script creates a stored procedure that, when executed, queries the system tables of any SQL2000 database to return a complete, ordered datadictionary. *Warning**This script only works on tables which have the description property filled out as my main purpose was to query the extended property description feature new to SQL2000. If you have not […]
2001-08-27
3,116 reads
2001-08-26
1,404 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
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