What’s new in SQL Server RC0 setup
Datacentre Edition is no longer available as a MS SQL Server 2012 RC0 candidate, Read MoreMS SQL Server 2012 RC0...
2011-12-28
725 reads
Datacentre Edition is no longer available as a MS SQL Server 2012 RC0 candidate, Read MoreMS SQL Server 2012 RC0...
2011-12-28
725 reads
Results of the 2011 PASS Board of Directors election were officially announced this morning. I want to congratulate my friends...
2011-12-28
786 reads
SQL Server Master Data Services (MDS) has a number of enhancements in SQL Server 2012:
Improved web user interface – If you...
2011-12-28
1,841 reads
Getting row count for all tables in a database is straight forward. You can display row count for all tables...
2011-12-28
2,840 reads
The 2011 Election results were just posted, congratulations to Adam Jorgensen, Denise McInerney, and Rob Farley for taking the top...
2011-12-28
697 reads
I’m writing this on December 17th, thinking back on 2011, and it has been a good year. Not always simple...
2011-12-28
652 reads
You can only use the position() function within an xquery predicate and can't use it to return the position value...
2011-12-28
6,821 reads
I have seen a few recap posts bouncing around the net and started thinking about my own blog. So out of curiosity, I decided to take a look at...
2011-12-28
14 reads
I have seen a few recap posts bouncing around the net and started thinking about my own blog. So out...
2011-12-28
851 reads
Microsoft is working on the next round of certification exams for SQL Server 2012. So now is the best time...
2011-12-28
1,628 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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