Quick SQL Server Configuration Summary Report
This script will detect and display a quick summary of your SQL Server installation.
2016-08-03 (first published: 2015-01-29)
9,616 reads
This script will detect and display a quick summary of your SQL Server installation.
2016-08-03 (first published: 2015-01-29)
9,616 reads
This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently
2016-08-02 (first published: 2014-12-29)
8,660 reads
Identify the current statement and its line number within a running batch. Includes a link to the execution plan, if available.
2016-08-01 (first published: 2015-03-03)
5,470 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,717 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,432 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,640 reads
2016-07-26 (first published: 2014-11-20)
2,289 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)
567 reads
This script will generate 5 lottery numbers plus one mega and you can set how many tickets and the range for the numbers for the different types of lotteries.
2016-07-22 (first published: 2016-07-13)
2,118 reads
standard missing index script but has a create statement to copy and past
2016-07-21 (first published: 2016-07-07)
2,176 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers