TSQL Tuesday #26 or #23 – Identity Crisis
The first opportunity of this New Year to participate in TSQLTuesday, we have been invited by David Howard (blog) to...
2012-01-10
896 reads
The first opportunity of this New Year to participate in TSQLTuesday, we have been invited by David Howard (blog) to...
2012-01-10
896 reads
We’ve all have service accounts, application accounts, sysadmin and domain admin accounts and other privileged shared accounts on our systems....
2012-01-10
652 reads
Everybody deserves a second chance in love, life, and in TSQL as well! Now that it's the beginning of a New...
2012-01-10
5,173 reads
A busy Database Server and application development environment can have – Sandbox, Dev, Test, QA, Staging, Production .
Maintaining multiple environments requires...
2012-01-10
2,659 reads
I've noticed in the forums there have been a number of people inquiring about making schema changes in a replication...
2012-01-10
5,809 reads
The Orlando IT Pro Camp marks our third event after Tampa and South Florida. As with the prior IT Pro...
2012-01-10
992 reads
It has been a quiet past few months while my family has adjusted to having
two new additions (twins!), but...
2012-01-10
930 reads
I have a friend looking for a production DBA in Denver, so if you’re interested, email me at SQLServerCentral.
They need...
2012-01-09
786 reads
We are now just a few days away from our first meeting of 2012. We have some good content lined up. Check it out here. I am looking forward...
2012-01-09
14 reads
We are now just a few days away from our first meeting of 2012. We have some good content lined...
2012-01-09
646 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