2015-12-29 (first published: 2015-12-09)
2,008 reads
2015-12-29 (first published: 2015-12-09)
2,008 reads
This script adds empty first step for every job for easier job history viewing.
2015-12-28 (first published: 2015-12-10)
1,905 reads
2015-12-25 (first published: 2015-12-17)
1,748 reads
Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML.
2015-12-24 (first published: 2012-03-19)
6,824 reads
Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.
2015-12-23 (first published: 2009-04-29)
5,065 reads
2015-12-22 (first published: 2012-11-26)
3,436 reads
A script to get the user table query ratio and update radio,etc
2015-12-21 (first published: 2015-12-11)
1,811 reads
2015-12-18 (first published: 2015-12-09)
4,678 reads
This script outputs sql server service, start type, status, Service Account, installation location, start up time, uptime of sql server related services along with startup trace flags.
2015-12-17 (first published: 2015-12-09)
1,163 reads
Use this script to set recommended Log files size growth for larger DBs. For more, please refer article: http://sqlmag.com/blog/choosing-default-sizes-your-data-and-log-files
2015-12-15 (first published: 2015-12-07)
1,258 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