Capacity planning for new hardware
I get asked this question a lot: When getting a new application and database, what kind of hardware do I...
2012-01-09
1,653 reads
I get asked this question a lot: When getting a new application and database, what kind of hardware do I...
2012-01-09
1,653 reads
When building a data warehouse, it is important that primary keys of dimension tables remain stable. To accomplish this, it...
2012-01-09
3,998 reads
Last month, a number of us got together to share how we use social networks to enhance our careers and...
2012-01-09
578 reads
It’s always handy to know if there any problems with your servers before you get into work in the morning....
2012-01-09
682 reads
Meme Monday was pushed back this month to the second Monday of the month. That is a good thing or maybe a bad thing or maybe a non-discussion at...
2012-01-09
12 reads
Meme Monday was pushed back this month to the second Monday of the month. That is a good thing or...
2012-01-09
570 reads
This is a revised post of an original article that I first published in December. Even though I thought that...
2012-01-09
260,660 reads
SQL Server Books online defines the wait type WRITELOG as “Occurs while waiting for a log flush to complete. Common...
2012-01-09
1,282 reads
Yes, it's Monday again, and not only that - it's another edition of Meme Monday (the first of 2012), started by...
2012-01-09
1,372 reads
Many of you have first hand experience of our phenomenal sql community (affectionately labelled the #sqlfamily).
Your first encounter with it...
2012-01-09
606 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