Create SQL Server scripts with Visio 2010
If you are using Visio 2010 and creating tables via the Database Model Diagram template, you may be surprised to...
2011-12-07
2,340 reads
If you are using Visio 2010 and creating tables via the Database Model Diagram template, you may be surprised to...
2011-12-07
2,340 reads
Part 1 of Question 13: The Question.Part 2 of Question 13: The follow up to the question.This is a continuation...
2011-12-07
634 reads
The new year is just around the corner. And before you know it, we’ll have an opportunity to start moving...
2011-12-07
533 reads
My perception of the tablet market has been that the iPad is king, but at a kingly price. If I...
2011-12-07
808 reads
Yay. I finally took the plunge and decided to take Exam 70-451. This is the MCITP exam for the SQL 2008 Dev track. Frankly, I had taken my time with...
2011-12-07
14 reads
Yay. I finally took the plunge and decided to take Exam 70-451. This is the MCITP exam for the SQL...
2011-12-07
610 reads
PBM raises errors for policy violations. We can create alerts on those errors to be notified of policy violations. In...
2011-12-07
1,695 reads
Latency is the time delay measure in the system. SQL Server can only be as fast as the slowest component...
2011-12-07
1,849 reads
I wrote this piece as a guest on Bradmcgehee.com for the DBA in Space competition. Republishing here.
A DBA (Database Administrator)...
2011-12-07
1,000 reads
What is it that makes the perfect role for a Database Administrator?
Well I can’t tell you that because you and...
2011-12-07
1,315 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