Automatic Seeding in Always On Availability Groups in SQL Server 2016
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-08-21
1,015 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-08-21
1,015 reads
In the previous posts I posted some questions that I usually get when we talk about getting certified with SQL...
2017-08-21
145 reads
System administrators of the world, if a VM experiences a problem that takes down business-critical application, your job is to...
2017-08-21
128 reads
System administrators of the world, if a VM experiences a problem that takes down business-critical application, your job is to...
2017-08-21
306 reads
My company, Heraflux Technologies, is proud to announce a new ebook as part of our joint partnership with Pure Storage!...
2017-08-21
250 reads
You’ve installed SSDT, created an SSIS project, created any packages you need and now you want to place that project...
2017-08-21
861 reads
Azure does a lot for your SQL Database, from backups to automatic tuning but it still doesn’t have an index...
2017-08-21
995 reads
David has recorded and published a video of his presentation on SQL Server Graph Database. In his video which you...
2017-08-31 (first published: 2017-08-21)
2,675 reads
I posted a couple of messages on twitter over the weekend giving any new bloggers advice that was given to...
2017-08-21
296 reads
Hello friends, in this blog we will learn how to check whether a cloud service is available to use with...
2017-08-21
483 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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