It’s All in the Name, Index Naming Conventions
Awhile back, if you are on Twitter, you can probably recall my ranting about the 949 indexes I was reviewing....
2018-01-10
1,729 reads
Awhile back, if you are on Twitter, you can probably recall my ranting about the 949 indexes I was reviewing....
2018-01-10
1,729 reads
This post is by Chris Gibson
I recently wanted to exclude some temporary SQL databases from being discovered by our SCOM...
2018-01-10
1,376 reads
Last week I was working on a couple of SQL instances that contained databases which were part of an Always...
2018-01-10
502 reads
The challenge at hand - conquering that technical problem and getting that high associated with the metaphorical high of summiting a tough task.
Related Posts:
Summiting that Technical Challenge Part II...
2018-01-10
9 reads
Conquering Challenges
I really like the topic of the TSQLTuesday party today. Today we have been instructed in no uncertain terms...
2018-01-19 (first published: 2018-01-10)
1,087 reads
Hello!
Very recently a user of salt got in touch with me about a bug when setting the job schedules up...
2018-01-09
257 reads
How can you tell what version of TLS is currently used for client connections? Unfortunately there isn't a handy queryable column...
2018-01-09
2,510 reads
A common finding in security audits these days is the failure to conduct all communications via TLS 1.2. (Correspondingly, a...
2018-01-16 (first published: 2018-01-09)
31,457 reads
Overview
The database protection and recovery is a vital role of database administrators. While working on SQL Server, sometimes users get...
2018-01-09
1,496 reads
Have you ever had to run a query on multiple servers? You could connect to each server one by one...
2018-01-09
494 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