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)
478 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
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
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...
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers