2011-12-14
635 reads
2011-12-14
635 reads
A couple months back the laptop my wife uses was fading away, the internal power connector was broken/barely working and...
2011-12-14
648 reads
One challenge I’ve had recently is getting a list of servers imported in to a CMS (Central Management Server). While...
2011-12-13
5,175 reads
I document the CPU Count for SQL Server inventory management.
Using a powershell script , iterate through all the SQL Servers and...
2011-12-13
1,014 reads
Welcome to the fifth of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-12-13
658 reads
The Shredder Challenge was a contest sponsored by DARPA to find ways of putting shredded documents back together. Take a...
2011-12-13
854 reads
Tis the Season It is the season for TSQL Tuesday. More importantly it is the season for giving and reflection. And whether you celebrate Christmas or Chanukkah or Kawanzaa...
2011-12-13
17 reads
It’s that time of the month again, no not time, T-SQL time! If you have not heard of T-SQL Tuesday...
2011-12-13
890 reads
Another month and it’s another T-SQL Tuesday. This month we are being hosted by Allen White (Blog | @SQLRunr) and the...
2011-12-13
629 reads
And the trick i share for this month’s T-SQL Tuesday is… Distraction free management studio.
If you’re an avid writer, you might...
2011-12-13
744 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