Want to recruit me? Please follow these rules
I get 15-30 calls/emails a week from recruiters (not counting the dozens of auto-generated emails I get). Being a contractor...
2012-01-23
912 reads
I get 15-30 calls/emails a week from recruiters (not counting the dozens of auto-generated emails I get). Being a contractor...
2012-01-23
912 reads
The BACKUP LOG WITH NO_LOG and WITH TRUNCATE_ONLY options are discontinued in SQL Server 2008.
There is no replacement for this...
2012-01-22
2,807 reads
Output Clause:- The SQL SERVER 2005 gives us an Output Clause which gives us the information about each row affected by the...
2012-01-22
2,208 reads
AdvertisementsSQL server clustering the timeout period elapsed prior to completion of the operation
Recently I faced one of our application could...
2012-01-22
16,191 reads
Q. “I need to modify Production Data directly on a Production database. What are some steps I can follow to...
2012-01-21
1,018 reads
Today's post is a follow on from one earlier this month Database uplevel Restores. I got round to testing restoring...
2012-01-20
1,161 reads
Reprinted from my editorial in Database Weekly.
I know a lot of DBAs who make SQL Server the focus of their...
2012-01-20
904 reads
Staying true to the meaning of SQL Community with respect to local chapters and user groups, I wanted to bring you...
2012-01-20
1,588 reads
Over the last few weeks, I’ve been watching SQL Server videos and webcasts. My primary motivator in doing this is...
2012-01-20
605 reads
If you are interested in viewing the recorded sessions for the PASS Summit 2011, you can order the DVD. You...
2012-01-20
910 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