SQL Saturday 103 Recap
SQL Saturday 103 was in Curacao, a beautiful Dutch Island in the Caribbean. I was fortunate enough to be able...
2012-03-14
633 reads
SQL Saturday 103 was in Curacao, a beautiful Dutch Island in the Caribbean. I was fortunate enough to be able...
2012-03-14
633 reads
On March 9th a tweet went out by David Fargo announcing the 2012 Idera ACE’s and my twitter handle was...
2012-03-14
621 reads
I am bringing an oldie back with another twist. I recently ran into the need to correlate information between a couple of different queries that I like to use....
2012-03-14
15 reads
I am bringing an oldie back with another twist. I recently ran into the need to correlate information between a...
2012-03-14
1,135 reads
Business users are often interested in finding distinct counts in addition to other aggregations. They may want to know the...
2012-03-14
1,277 reads
Ryan Recruiter meet Dave DBA…
As a contractor and consultant I get to speak to many agents and recruiters and over...
2012-03-14
726 reads
Sometimes on a heavy loaded server(many databases/connection). You may get an error log when your backup maintenance plan job gets...
2012-03-14
7,315 reads
Due to a few scheduling conflicts the SQL Lunch scheduled for tomorrow as been rescheduled. The event will be on March...
2012-03-14
808 reads
Due to a few scheduling conflicts the SQL Lunch scheduled for tomorrow as been rescheduled. The event will be on...
2012-03-14
662 reads
There is one thing every DBA knows with certainty, and that is that databases grow with time. MDFs grow, backups...
2012-03-13
2,035 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