2012-04-26 (first published: 2012-04-02)
1,075 reads
2012-04-26 (first published: 2012-04-02)
1,075 reads
2012-04-25 (first published: 2012-04-02)
2,293 reads
2012-04-24 (first published: 2012-03-30)
1,886 reads
This script will list the operators that have jobs
that are configured to notify them with alerts.
2012-04-23 (first published: 2012-03-29)
1,034 reads
The scripts provided below will show you the "Recovery Mode (Model)" for any given database
2012-04-19 (first published: 2008-03-18)
2,032 reads
Procedure to find any object such as table/stored procedure by its name, or find for ant text inside stored procedures, functions.
2012-04-18 (first published: 2008-05-28)
3,031 reads
2012-04-17 (first published: 2008-02-15)
7,524 reads
A script to check the owners, collations and backups on the server.
2012-04-16 (first published: 2007-10-19)
2,673 reads
2012-04-13 (first published: 2007-10-19)
3,427 reads
Restore server/database users and roles from another server when we are restoring databases to another server.
2012-04-12 (first published: 2007-10-23)
3,147 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