Modify All Database Data and Logfile Names
This script modifies all dtabase .mdf and .ldf to have a standardized name of DatabaseName_Data and DatabaseName_Log.
2011-08-08 (first published: 2011-07-28)
974 reads
This script modifies all dtabase .mdf and .ldf to have a standardized name of DatabaseName_Data and DatabaseName_Log.
2011-08-08 (first published: 2011-07-28)
974 reads
2011-08-05 (first published: 2011-07-23)
2,290 reads
2011-08-04 (first published: 2011-07-25)
3,334 reads
These scripts will extract security for Windows Logins, Database Users, Roles, Objects and SQL Logins.
2011-08-03 (first published: 2011-07-28)
2,228 reads
2011-08-02 (first published: 2011-07-28)
3,055 reads
2011-08-01 (first published: 2011-07-28)
3,217 reads
This script will rename the Primary keys to standard notation - PK_TableName
2011-07-29 (first published: 2010-02-09)
1,725 reads
A quick and simple SysProcess query which will display most of the common parameters of interest.
2011-07-28 (first published: 2011-07-23)
1,422 reads
Verifies that a specified login name exists and has correct settings.
2011-07-27 (first published: 2011-07-11)
1,771 reads
This script will gather a number of Server Information items that are useful in baselining a SQL Server.
2011-07-25 (first published: 2010-01-19)
7,435 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