Choosing the right professional
I’m writing this blog post from my bed, you may think that’s a little too much information there is a...
2012-01-11
494 reads
I’m writing this blog post from my bed, you may think that’s a little too much information there is a...
2012-01-11
494 reads
Thanks for everyone who attended my presentation “How To Make a LOT More Money as a Consultant” at HASSUG.
Here is...
2012-01-11
613 reads
If you’ve been working with databases for any length of time, you have heard the term normalization.
Normalization is the process...
2012-01-11 (first published: 2012-01-06)
5,107 reads
A neat test for read speed backup throughput is to use the Backup to NUL .
NUL is a special “file”. It's...
2012-01-11
967 reads
I've been using 4 alerts for corruption now for about 2 years for Errors 823, 824, 825 and 9100. Basically...
2012-01-11
1,058 reads
Since I work mostly from home, video/voice conferencing and IM are of major importance to me, and using the right...
2012-01-11
1,039 reads
Given a customer table:
CREATE TABLE Customers
(CustId INT, OrderDate DATE, OrderAmount MONEY) ;
INSERT Customers VALUES
(1, ’2011-12-03', 12500)
, (1, ’2011-10-07', 15000)
, (1,...
2012-01-10
850 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
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'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
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