First Impressions
SELECT @@Version
Microsoft SQL Server “Denali” (CTP1) – 11.0.1103.9 (X64)
I’ve been playing with the CTP for a few days (with absolutely no...
2010-11-09
1,440 reads
SELECT @@Version
Microsoft SQL Server “Denali” (CTP1) – 11.0.1103.9 (X64)
I’ve been playing with the CTP for a few days (with absolutely no...
2010-11-09
1,440 reads
So, it’s the second Tuesday of the month again, and it’s time for T-SQL Tuesday again. This month it’s hosted...
2010-10-12
1,289 reads
Or “If one index is good, surely many indexes (indexes? indices? indi?) will be better”
This is a question that comes...
2010-09-14
1,590 reads
Or “Plan cache monitoring – insert and remove”
Previously I took a look at the CacheHit and CacheMiss events to see how...
2010-08-31
1,826 reads
Or “Monitoring plan cache usage”
For people interested in the details of how SQL is using and reusing execution plans, there...
2010-07-27
1,154 reads
Short answer: No
I keep seeing this come up on various forums when people ask what makes a database go suspect...
2010-06-29
2,053 reads
On the first day of DBA hell, the server gave to me
A database with damaged system tables and no good...
2010-06-15
974 reads
Over the last several months I’ve had a look at IN, Exists, Join and their opposites to see how they...
2010-04-27
1,363 reads
And to wrap up the miniseries on IN, EXISTS and JOIN, a look at NOT EXISTS and LEFT OUTER JOIN...
2010-03-23
13,268 reads
Or “Shot gun query tuning”
There have been a fair few forums questions in recent months asking for help in removing...
2010-03-11
487 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