2016-08-10 (first published: 2015-05-05)
5,446 reads
2016-08-10 (first published: 2015-05-05)
5,446 reads
This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently
2016-08-08 (first published: 2014-12-29)
8,389 reads
Generates # of dates in before/after current year.
No more hardcoded date ranges.
2016-08-08 (first published: 2016-07-28)
596 reads
Identify the current statement and its line number within a running batch. Includes a link to the execution plan, if available.
2016-08-08 (first published: 2015-03-03)
5,410 reads
This script will detect and display a quick summary of your SQL Server installation.
2016-08-03 (first published: 2015-01-29)
9,111 reads
This script reports jobs which are running when another job is also running. This could be a reason for performance degradations.
2016-07-29 (first published: 2014-06-21)
2,621 reads
A script we use in our company, that rebuilds online=on by default, but takes care of special exceptions.
2016-07-28 (first published: 2014-06-06)
2,345 reads
Based upon todays date as suffix and chosen string as prefix, select data from predefined table into dynamically named new table. Script is properly error handled with most common errors
2016-07-27 (first published: 2015-05-04)
2,526 reads
2016-07-26 (first published: 2014-11-20)
2,236 reads
This script alert when a table on a DB has a low number of identities available
2016-07-25 (first published: 2016-07-16)
514 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers