tSQLt Test Adapter for Visual Studio 2017
So Visual Studio 2017 has been released a while and I had created a version of the test adapter (which...
2017-10-03
99 reads
So Visual Studio 2017 has been released a while and I had created a version of the test adapter (which...
2017-10-03
99 reads
So Visual Studio 2017 has been released a while and I had created a version of the test adapter (which lets you run tSQLt tests from within Visual Studio...
2017-10-03
22 reads
As mentioned in my post Auditing Data Access in SQL Server for GDPR Compliance CDC can be a useful tool for...
2017-10-03
18,073 reads
This time I'll talk about some basis with SQL Server replication, whether you need it for High availability (HA), Disaster...
2017-10-03
741 reads
If you're used to the behavior of SSMS or PowerShell ISE where upon executing code in the script panel, your...
2017-10-03
506 reads
I last posted about changing a table without changing a view that represents the table and how this may affect...
2017-10-03
375 reads
As SQL Server professionals, we sometimes encounter some issues that we haven’t seen before or have seen already but forgot...
2017-10-03
405 reads
Is my math right? The new CU servicing schedule for SQL Server 2017 is:
1 CU per month for the first...
2017-10-03
1,086 reads
Here is a quick Extended Events script I knocked up where I wanted to track Tempdb file size changes for...
2017-10-03
508 reads
Watch this week’s interview with Drew on YouTube.
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you’ve had...
2017-10-03
157 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