Sorry fellas but Red-gate bought the site and now claims all copy-rights for its content, so I deleted this script. You can find it in other sites throughout the internet, such as http://education.sqlfarms.com/ShowForum.aspx?ForumID=20
2005-06-16
1,035 reads
In MS SQL, January 1 of any year defines the starting number for the week. The DATEPART(wk, 'Jan 1, xxxx') always return 1. However, a lot of reports Week No is actually based on ISO 8601 standard, that is January 1 of any year can be Week 53/52 or Week 1. (http://www.merlyn.demon.co.uk/weekinfo.htm#IDC)The Rule is as […]
2005-06-14 (first published: 2005-05-27)
317 reads
This script adds to others posted on this site by formatting and displaying text information about table and index space allocation.
2005-06-13
444 reads
This is a User Defined Function that returns a 1 if date is a holiday else, it returns a 0.The holidays are:New years Day, MLK Day, Presidents Day, Memorial Day, Independance Day, Labor Day, Columbus Day, Veterans Day, Christmas Eve and Christmas Day
2005-06-13 (first published: 2005-05-27)
302 reads
Makes a paged query with the sql parameters to build itand page parameters to filter.Add "No","CurrentPage","TotalPages" coumns to the queryto manage paging at user interface.The query Lose the identity column orderIt works fine for me!
2005-06-12
172 reads
A simple User Function which will guarantee always to return a value from a division without any errorsExample : GPDivNErr(@Val1 float, @Val2 float)
2005-06-10 (first published: 2005-05-29)
477 reads
A function to convert varbinary to hex string. Have you every tried to deal with varbinary via T-SQL? Passwords and SIDs are of this datatype. In Query Analyzer this datatype displays as hex string but under the hood it is binary. Try concatenating a varbinary to a string in a print statement and you get […]
2005-06-09 (first published: 2005-03-30)
263 reads
Hai raino,I saw ur query posted in SQLServerCentral.It was very useful.But if try to run the querydbcc traceon(3604)dbcc rebuild_log ('Training','Training_Log')Its showing the error=================Error================DBCC execution completed. If DBCC printed error messages, contact your system administrator.Server: Msg 5105, Level 16, State 2, Line 2Device activation error. The physical file name 'Training_LOG' may be incorrect.DBCC execution completed. If […]
2005-06-08 (first published: 2005-05-19)
365 reads
This script originally created by Greg Larsen has been modified by me. This procedure is used to create the restore commands needed to restore a database using the lates full and any transaction or differential backups. The parameter @dbname was added to just create the restore statements for a particular database. Leaving off this parameter […]
2005-06-07 (first published: 2005-05-19)
1,242 reads
Initial analysis of a new source system can be quite time consuming to manually examine tables and columns to determine which even have worthwhile values in the first place. Running this script against the current database will generate useful information for all the columns of all the tables. Details include data types with varchar lengths, […]
2005-06-07
458 reads
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers