2018-04-26
449 reads
2018-04-26
449 reads
If you are a DBA, especially Infrastructure DBA, Production DBA or Operations DBA then you don't necessarily always know what...
2018-04-26
419 reads
On one of the last clients I have worked, I have implemented dbachecks in order to get the state of...
2018-04-26
500 reads
If you were like me, you would know your AG configuration by heart. However, what if you get busy with...
2018-04-26
385 reads
-- Health and status of WSFC cluster. These two queries work only if the WSFC has quorumSELECT*FROMsys.dm_hadr_clusterSELECT*FROMsys.dm_hadr_cluster_members
-- Health of the AGsSELECT...
2018-04-26
17,497 reads
Redgate Software is putting on a one day SQL Privacy Summit on May 18 in London at the Grange Tower...
2018-04-26
396 reads
CEIP (Customer Experience Improvement Program) is somethings runs from ages and almost each vendor perform it to collect product usage...
2018-04-26
9,011 reads
Third time in a month, I will be presenting Machine Learning Server, this time at SQL Saturday Wheeling
2018-04-25
32 reads
SQL Server allows you to nest multiple transactions but the results of doing so are completely not obvious.
Take the following...
2018-04-25
72 reads
Hello everybody! Thank you once again for stopping by and reading. April has been pretty busy with presentations, and I...
2018-04-25
126 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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...
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