First steps with Extreme Transaction Processing – Hekaton
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
A few hours...
2013-07-02 (first published: 2013-06-25)
3,883 reads
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
A few hours...
2013-07-02 (first published: 2013-06-25)
3,883 reads
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
The 1st half...
2013-06-24
1,289 reads
Almost everytime when I’m doing SQL Server consulting engagements, DBAs are showing me queries and their Execution Plans, where SQL...
2013-06-12
1,636 reads
Yesterday during the opening keynote of TechEd North America Microsoft released the first official details about the next version of...
2013-06-04
2,810 reads
Today is a very sad day for me. My love, my dear Windows has passed away. We were together for...
2013-05-17
1,089 reads
Every one of us knows Bookmark Lookups in SQL Server. They are great, because you don’t need to care about...
2013-04-15
760 reads
Since September 2012 I'm a Microsoft Certified Master SQL Server 2008,
which is the highest technical certification for SQL Server that...
2013-02-13
1,055 reads
Since September 2012 I’m a Microsoft Certified Master SQL Server 2008, which is the highest technical certification for SQL Server...
2013-02-13
824 reads
Today I have uploaded the 5th SQL Server Quickie to YouTube. This time Santa Claus
talks about Bookmark Lookup Deadlocks in...
2012-12-16
1,521 reads
Today I have uploaded the 5th SQL Server Quickie to YouTube. This time Santa Claus talks about Bookmark Lookup Deadlocks...
2012-12-16
845 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