This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.
2011-04-18 (first published: 2008-10-01)
4,688 reads
If you've ever been stuck having to write stored procedures to support an application, check this script out. This script will automatically generate seperate parameter driven select, insert, delete, and update stored procedures. Simply call these stored procedures from your application, passing parameters. This stored procedure requires only one parameter; table name. Creates scripts with […]
2002-02-21
335 reads
If you've ever needed a convenient and quick way to convert/validate what could possibly be a mm/yy or mm/yyyy date to mm/dd/yyyy (date of month is 01) check out this custom function. Eg: select dbo.datemy('04/02') outputs smalldatetime '2002-04-01 00:00:00'. Select dbo.datemy('04/2002') outputs the same smalldatetime '2002-04-01 00:00:00'.
2002-02-15
875 reads
Have you ever wanted to have SQL note a failure on a step, yet continue running the job. I found it to be annoying that you have to fail (and end) a job in order to send a message to an operator. I have processes that run at off times, I want to know when […]
2002-02-13
2,302 reads
The last T-SQL Tuesday of the year is hosted by my good friend Mike...
By Steve Jones
This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he...
The setup My day job involves babysitting a lot of Git repositories hosted on...
Hi So I have the below select query that won't return results if I...
Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise:...
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers