What I Want For My Birthday
Dell has teased us with some images of their upcoming 12th Generation servers (that will support the Intel Sandy Bridge-EP...
2012-02-29
1,808 reads
Dell has teased us with some images of their upcoming 12th Generation servers (that will support the Intel Sandy Bridge-EP...
2012-02-29
1,808 reads
Doing things by the book isn’t necessarily the only way to learn a new skill. Sometimes, experiencing everything that can...
2012-02-28
4,138 reads
Update: Jen Lussier has blogged a summary of the talks she had at the MVP summit last week. Take a...
2012-02-28
1,618 reads
Today’s script is one I use as an example to explain that there is method behind my standards that some...
2012-02-28
1,533 reads
Since it is nearly March, I will go ahead and jump the gun by a few days and post an...
2012-02-28
1,858 reads
Welcome back to another addition of Monday Morning Mistakes series. Today’s issue is one I tend to run into quite...
2012-03-12 (first published: 2012-02-28)
42,491 reads
Today one of my user complained that a report was missing one particular ticket from the output. The report in...
2012-03-08 (first published: 2012-02-28)
4,299 reads
On Saturday, March 10, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...
2012-02-28
1,417 reads
To list a SQL Server Agent Job Steps use the T-SQL example below.
This example displays the step id, SQL Server...
2012-02-28
1,992 reads
I just found out that I will be speaking at SQLRally Dallas in May. I submitted 3 sessions. As an...
2012-02-27
677 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