Data Virtualization vs Data Warehouse
Data virtualization goes by a lot of different names: logical data warehouse, data federation, virtual database, and decentralized data warehouse....
2017-08-24
923 reads
Data virtualization goes by a lot of different names: logical data warehouse, data federation, virtual database, and decentralized data warehouse....
2017-08-24
923 reads
Yet another tale from the ticket queue...
The DBCC CheckDB was failing on INSTANCE99 and after some investigation it looked like...
2017-09-07 (first published: 2017-08-24)
4,373 reads
SQL Server Deadlocks – Also known as “The deadly Embrace” occurs when there are 2 processes and neither can advance and...
2017-09-08 (first published: 2017-08-24)
2,018 reads
I’m excited to say that I will be speaking at Ignite this year in Orlando! I was at Ignite in Atlanta last year and it was an excellent experience....
2017-08-23
15 reads
I’m excited to say that I will be speaking at Ignite this year in Orlando! I was at Ignite in Atlanta last year and it was an excellent experience....
2017-08-23
18 reads
I’m excited to say that I will be speaking at Ignite this year in Orlando! I was at Ignite in Atlanta last year and it was an excellent experience....
2017-08-23
12 reads
I’m excited to say that I will be speaking at Ignite this year in Orlando!
I was at Ignite in Atlanta...
2017-08-23
323 reads
In this article, we take the sledgehammer approach in searching for MDFs and then comparing them against files which are...
2017-08-23
506 reads
This coming weekend, at SQLSaturday #635 in Vancouver BC, I will be presenting a brand new talk about Temporal Tables,...
2017-08-23
134 reads
Continuing the comparison between these two database giants, we dive into the substring function. If you’ve been working with databases...
2017-09-05 (first published: 2017-08-23)
7,292 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