Running a script on multiple servers
One of my favorite features of SQL Server Management Studio (SSMS) is the ability to run a script on multiple...
2012-03-02
2,740 reads
One of my favorite features of SQL Server Management Studio (SSMS) is the ability to run a script on multiple...
2012-03-02
2,740 reads
Edit: The group I’m speaking to is the Content Team, not the Books Online (BOL) team!
Edit: Updated with FAQs and...
2012-03-02
740 reads
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-02
472 reads
Database Recovery Advisor is a new feature in SQL Server 2012 that introduces significant user experience enhancements to the ways DBAs...
2012-03-02
1,048 reads
Today’s script is also one I used in my migration on Wednesday. It again uses string manipulation to generate a...
2012-03-02
537 reads
Today’s script is one that I used earlier this week. On Thursday I migrated a server from SQL Server 200...
2012-03-02
538 reads
I have inherited a SQL 2005 server with SQL Agent job notifications in place, and a request to clear the...
2012-03-02
923 reads
An inspiring story. A hard one, and one that comes from someone with talent.
I like seeing stories like this, and...
2012-03-02
1,017 reads
Following in the foot steps of John Sansom (b|t), I’m going to post a roundup of links from other blogs every Friday. I’ll...
2012-03-02
994 reads
<rant> One of the most frustrating things about working with the Microsoft BI Stack is after you go through all...
2012-03-02
9,353 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