Re-blog – March 2 – March 8
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-09
621 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-09
621 reads
The buzz started yesterday, with the rumblings about Database Mirroring showing up on the "Features Not Supported in a Future...
2012-03-09
969 reads
Welcome to another week of SQL Roundup. Just in case you missed, SQL Server 2012 was released this week and...
2012-03-09
753 reads
As you might know, Microsoft has released on March 7 the RTM version of SQL Server
2012. If you are an...
2012-03-09
4,528 reads
From the newly released SQL 2012 Books Online documentation:
This note shows that as of SQL Server 2012, which will be...
2012-03-09
3,020 reads
On a routine scan of Event Viewer System, Logs I found this message on 4 different servers hosting SQL Server...
2012-03-09
3,282 reads
One of the most compelling features of the new SSAS Tabular Model is the ability to set the model’s Query...
2012-03-09
2,987 reads
Are your SQL Servers healthy? If the things went south today today, would you be able to say you can...
2012-03-08
1,776 reads
I’m travelling to several upcoming events and I’d love to sit down and talk with you. Yes, I get it,...
2012-03-08
883 reads
Bodypaint not required
It seems that March is another great month for getting your geek on without having to leave the...
2012-03-08
649 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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