sp_MSTableSpace and sp_MSforeachtable combined
The following stript combines two previous articals. sp_MStablespace was being demonstrated with a cursor. To reduce the code the sp_MSforeachtable could be used.
2003-07-08
546 reads
Scripts
Script to Return Last Weeks Data
I was asked by a customer to create a scheduled weekly report detailing work that had been completed in the previous week (Monday to Friday) I figured they might lose the report or something might happen to stop the scheduler from running it, and I didn't want to have to modify my script to work […]
2003-07-07
163 reads
2003-07-02
645 reads
2003-07-02
405 reads
SUBSTR - SUBSTRING function extension
SUBSTR returns a portion of char, beginning at character @StartPos, @Length characters long. If @StartPos is 0, it is treated as 1. If @StartPos is positive, Oracle counts from the beginning of char to find the first character. If @StartPos is negative, Oracle counts backwards from the end of char.
2003-07-02
281 reads
Adds TIME portion of a DT to the DATE of another
UDF that returns a DATETIME which is the concatination of the TIME portion of one DATETIME and the DATE portion of another.EXAMPLES:DECLARE @Date DATETIME, @Time DATETIMESET @Date = '7/1/03 16:00'SET @Time = '5/16/1999 9:30 AM'PRINT dbo.FN_AddDateTime(@Date,@Time )RETURNS: Jul 1 2003 9:30AMPRINT dbo.FN_AddDateTime(@Date,0)RETURNS: Jul 1 2003 12:00AM
2003-07-01
103 reads
Script to list object names on a given Filegroup
This script is useful when want find out the list of the object on a given filegroup.
2003-07-01
237 reads
Decimal2Text Measurement Function
This function is based on a script by Tim Dietrich (tim@timdietrich.us) named format_height.sql. His function took what he called a decimal representation of a measurement and formatted it as feet and inches. In reality the input value was just a measurement formatted to look like a decimal number but it was not a true decimal […]
2003-06-27
92 reads
Manage Extended Property
While we are exploring the possibility to build data-driven application whose GUI are all dynamically generated according to database objects' extended property, we find the system provided procedures: sp_addextendedproperty, sp_dropextendedproperty,sp_updateextendedproperty can add extended property to only one object each time, while fn_listextendedproperty can not let you search objects to display their extended property. […]
2003-06-27
497 reads
Script to backup all databases
A proc which gets a list of all databases (Exluding "excluded" ones) and backs them up.The backup files are stored in the directory \DatabaseName\DatabaseName.bakUNC names are supported provided SQL Server has write access to the location.It deletes backups older than x (Current 3) days.This can be changed.Add a job to execute the script of proc […]
2003-06-26
714 reads
Blogs
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
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....
Forums
ALAMAT BCA KCU SCBD Telp:08218154392
WA CS:08218154392 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl....
Alamat Kontak BCA KCU BEKASI WA CS:08218154392
WA CS:08218154392 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks,...
ALAMAT BANK BCA KCU GUNSA 45 TLP/WA 08218154374
Hub Cs: 08218154374 Jl. Gn. Sahari No.45, RT.7/RW.5, Gn. Sahari Utara, Kecamatan Sawah Besar,...
Question of the Day
SQL Server Certificates
Which of these is not true for certificates used for SQL Server connections?
See possible answers