2002-05-01
467 reads
Scripts
Disk usage for the databases and tempdb.
This procedure will return size of the data files & log files of the database and tempdb. This is returned in one resultset so you can use this procedure to store fluctuation in database sizes.
2002-05-01
1,765 reads
Eliminate Weekends And Holidays From Days Elapsed
This script is designed to eliminate weekends and designated non business days (such as holidays and other days a company is closed) from a computation to determine if a particularorder was shipped on time, early, or late.
2002-05-01
797 reads
Get stored procs that call a specified procedure
This script will list all stored procedures that are calling the specified stored procedure. Also could be used to find procedures that contain any specified expression or words.
2002-05-01
1,020 reads
GetPage - paging functionality
All what you need to do is to set the values of a couple of variables; NAME OF the TABLE you want to query (or you can write your own select statement here), NAMES OF COLUMNS you want to display, name of COLUMN for SORTING, define NUMBER OF ROWS on one page, NUMBER OF REQUIRED […]
2002-05-01
409 reads
Left pad any string with another char
Pads a string (e.g. a number that needs left padding with zeros) with any character for as many as it takes to bring the inputted string to the total desired length.
2002-05-01
569 reads
Returning values of combining nulls and non nulls
This script shows how to retrieve combination of different columns that may have nulls.
2002-05-01
768 reads
Row Length
This select will be useful for developers/ database designers / DBAs to find the rowlength instantly. This select also makes use of system function to get rid of joins. Only for sql7 and up.
2002-04-30
452 reads
Find fields with similar name in all tables
In most places, we use some kind of field naming convention. Many times we have one or more fields with similar name in all tables for some kind of tracking. You can use this query to find similar names in all tables.
2002-04-29
257 reads
Generate CROSS-TAB Scripts Automaticly !
Need to Transform a table with Summaries to be plugged into EXCEL or place a table of info in one row. This is cool and has been a real time saver!!! Simply save as a Template file in your favorite template folder. In Query Analyzer go to Menu Tools... Options... General... Note the path of […]
2002-04-26
1,826 reads
Blogs
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Forums
whats that ssis analyzer product that documents lineage
hi, a few years ago was at a very large company that bought a...
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
BIT_COUNT() III
Comments posted to this topic are about the item BIT_COUNT() III
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers