Automatic Sample Sizes for Statistics Updates
I mentioned in my previous post about manually updating statistics that you can specify whether they’re updated using a full...
2017-08-23 (first published: 2017-08-15)
1,520 reads
I mentioned in my previous post about manually updating statistics that you can specify whether they’re updated using a full...
2017-08-23 (first published: 2017-08-15)
1,520 reads
Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to...
2017-08-15
214 reads
Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to...
2017-08-24 (first published: 2017-08-15)
2,365 reads
I recently wrote a post about using Transparent Data Encryption (TDE) with Azure Key Vault as an alternative to managing certificates. Today’s post will explore using SQL Server’s Always...
2017-08-15
195 reads
I recently wrote a post about using Transparent Data Encryption (TDE) with Azure Key Vault as an alternative to managing...
2017-08-23 (first published: 2017-08-15)
2,227 reads
Don’t you want to go to the single largest collection of Microsoft Data Platform professionals and developers on the planet?...
2017-08-14
185 reads
Don’t you want to go to the single largest collection of Microsoft Data Platform professionals and developers on the planet?...
2017-08-14
484 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-14
986 reads
We were deploying a new web service. Because of the nature of the service, we wanted it to listen on...
2017-08-24 (first published: 2017-08-14)
1,428 reads
I’m working on a project right now and it’s going to require me not only to refresh my SSIS skills...
2017-08-14
550 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