Busy times
It has been a pretty long time since my last blog post but with good reason!
The last month and a...
2014-11-12
454 reads
It has been a pretty long time since my last blog post but with good reason!
The last month and a...
2014-11-12
454 reads
In the 4th article of the Wait Statistics series we will dive into LCK_M_xx waits. This is another wait type...
2014-09-26
1,336 reads
More good news! I will be speaking on SQLSaturday #311 Bulgaria.
If you read this blog and will attend the event,...
2014-09-16
539 reads
We use databases to store a lot of information. This can also include sensitive information we don’t want to give...
2014-09-02
4,374 reads
I received some great news this week, my session about wait statistics is selected for SQLSaturday #336 in Utrecht, Holland!
This...
2014-08-23
717 reads
As you can see the webpage has changed!
New features are:
– Syntax highlighting on code snippets (and easy copy/paste)
– Better readability
–...
2014-08-11
526 reads
On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this...
2014-07-11
3,509 reads
On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this article we...
2014-07-11
596 reads
One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using...
2014-06-26
443 reads
One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using...
2014-06-26
3,267 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