Seven Reasons You Should Attend SQLBits 7
SQLBits is Europe’s Largest SQL Server Event
That’s right, just take a moment to let that point hit home. If you...
2010-07-22
883 reads
SQLBits is Europe’s Largest SQL Server Event
That’s right, just take a moment to let that point hit home. If you...
2010-07-22
883 reads
"Defend Your Data"
If you’re a SQL Server Database Administrator and you don’t know what CHECKDB is then you need to...
2010-07-14
541 reads
One of the great things about working with SQL Server is the opportunity to be involved in our fantastic SQL...
2010-07-13
592 reads
As a DBA you will encounter processes, code and design decisions within your environment that require change for the better....
2010-07-01
630 reads
Like most DBA’s I’m sure you often find yourself delivering information to the business concerning the performance of your SQL...
2010-06-30
1,528 reads
Whilst perusing the forums over at SQL Server Central today I stumbled across an interesting question regarding how to identify...
2010-06-25
579 reads
I know that you have seen it yourself too. That forum or blog post that contains “advice” that is daft,...
2010-05-02
585 reads
Part 2 of the SQL Server Essentials Series looks at why you should be using the Full Recovery Model to protect your data assets.
2009-09-21
9,158 reads
Tweaking SQL Server memory settings to provide support for managed code.
2009-07-06
12,441 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