When did SQL Server start and how long is the downtime window?
This is an old topic, and there have been quite a few blogs (and following comments) that illustrate how to...
2010-05-27
3,753 reads
This is an old topic, and there have been quite a few blogs (and following comments) that illustrate how to...
2010-05-27
3,753 reads
In case you are considering to apply SQL Server SP3 CU5 (http://support.microsoft.com/kb/972511) to your system, I'd like to point out one issue / bug we found with CU5.
2009-09-15
3,000 reads
In case you are considering to apply SQL Server SP3 CU5 (http://support.microsoft.com/kb/972511) to your system, I'd like to point out...
2009-09-12
1,587 reads
I was working on a table partition management task yesterday. The table is partitioned on a datetime column, and each...
2009-08-10
8,979 reads
I have been reading blogs from various sources, such as blogs on SSC, and on sqlblog.com etc. However on all...
2009-04-22
775 reads
What is literature? I find this definition is pretty intuitive at http://classiclit.about.com/od/literaryterms/g/aa_whatisliter.htm and also this one is more comprehensive at...
2009-04-19
1,021 reads
I always consider taking seminars and technical conferences as a key component in my DBA education framework
2009-02-03
1,484 reads
I always consider taking seminars and technical conferences as a key component in my DBA education framework
Last week (Jan 21...
2009-01-27
1,751 reads
I have tried hard to google a SQL query to find what objects exist in a specific filegroup, but in...
2009-01-16
12,569 reads
There is a saying that "The important is often not
urgent and the urgent not important". I could not agree more...
2009-01-03
18,372 reads
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