Introduction to Wait Statistics in SQL Server
In today’s blog posting I want to talk more about the Wait Statistics in SQL Server and how they can...
2015-04-13
938 reads
In today’s blog posting I want to talk more about the Wait Statistics in SQL Server and how they can...
2015-04-13
938 reads
On May 11th I will deliver a precon about SQL Server 2014 Performance Improvements at the SQLDay Poland conference in...
2015-04-09
992 reads
Today I have uploaded the 23th SQL Server Quickie to YouTube. This time I’m talking about Plan Cache Pollution in...
2015-04-07
909 reads
A few weeks ago I have spoken at the SQLRally Nordic conference in Copenhagen about Latches, Spinlocks, and Lock-Free Data...
2015-03-30
1,313 reads
During the SQLRally conference in Copenhagen/Denmark, Brent Ozar (Blog, Twitter) and I had a very interesting conversation regarding Statistics on...
2015-03-16
1,098 reads
Ok, some of you will hate me after this blog posting, but it has to be said. Over the last...
2015-03-11
808 reads
In today’s blog posting I want to talk in more detail about how In-Memory OLTP logs transaction log records into...
2015-03-09
1,134 reads
After speaking at the SQLRally conference in Copenhagen earlier this week, my next stop was at the SQLBits conference in...
2015-03-07
601 reads
Whew, this was an intensive session about Latches, Spinlocks & Lock-Free Data Structures at the SQLRally Nordic conference in Copenhagen. I...
2015-03-04
598 reads
Today I have uploaded the 22th SQL Server Quickie to YouTube. This time I’m talking about the Buffer Pool in...
2015-03-02
687 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