The Alpha and the Omega. The BEGIN and the END.
The BEGIN/END block is a fairly standard thing if you’ve ever done any coding, but it never hurts to do...
2017-10-04
965 reads
The BEGIN/END block is a fairly standard thing if you’ve ever done any coding, but it never hurts to do...
2017-10-04
965 reads
If you remember last month I wrote about DBCC CHECKDB and Azure SQL Database, more specifically whose responsibility (Microsoft’s) it...
2017-10-04
557 reads
Let’s take a look at what a Sequence is in relation to an Identity Column in SQL Server. Did you...
2017-10-04
5,279 reads
Routine maintenance rolls around and it’s time to failover your AG’s to new Primary’s to allow for patching and restarts…...
2017-10-04
328 reads
One question that I get asked regularly is, “can you limit the host resources to individual containers?”
This is a great...
2017-10-04
473 reads
I’ve spent what feels like a lifetime working on automating SSIS deployments, more specifically SSIS packages that have been created...
2017-10-04
2,911 reads
A blog post about how many reverse bicep curls or Romanian DeadLiftsI can do…? As Rob Farley (t | b | w)...
2017-10-04
502 reads
This time I'll talk about some basis with SQL Server replication, whether you need it for High availability (HA), Disaster Recovery (DR), load balance your applications or any other...
2017-10-04
35 reads
So Visual Studio 2017 has been released a while and I had created a version of the test adapter (which...
2017-10-03
637 reads
So Visual Studio 2017 has been released a while and I had created a version of the test adapter (which...
2017-10-03
90 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