SQL Server 2008 Diagnostic Information Queries (December 2011)
Here is a fresh set of diagnostic information queries for SQL Server 2008 and 2008 R2 for December 2011. Some...
2011-12-29
2,052 reads
Here is a fresh set of diagnostic information queries for SQL Server 2008 and 2008 R2 for December 2011. Some...
2011-12-29
2,052 reads
How fitting that I should close out the A to Z series while I close out the year. We’ve finally...
2011-12-29
2,087 reads
I saw the following post from Andy Warren (blog | twitter), one of the creators of SQL Saturday. He was trying to...
2011-12-29
2,806 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
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
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
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
ISOWEEK 52 Weeks in the Year
Stardate 12:20:2011 Week 51 SSC.Com Web Blog, Planet Earth. With only approximately two weeks left...
2011-12-28 (first published: 2011-12-20)
15,269 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
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