A View On Views
In my experience, there are few database objects more poorly understood, misunderstood, misused, and outright abused, than the humble view....
2017-11-16 (first published: 2017-11-05)
2,003 reads
In my experience, there are few database objects more poorly understood, misunderstood, misused, and outright abused, than the humble view....
2017-11-16 (first published: 2017-11-05)
2,003 reads
Indexes are a vast subject and well documented elsewhere on the web. But, it is still a very commonly asked...
2017-11-15 (first published: 2017-11-05)
5,266 reads
It’s day 2 of the PASS Summit. Yesterday was a whirlwind of a day, after my early-morning post-Halloween trip to...
2017-11-02
648 reads
Today, Microsoft claims that Linux runs like a First-Class citizen on Azure, .NET Core has been open-sourced, and has been...
2017-11-02
637 reads
This morning, Dr Rimma Nehme tells us the story of the birth of Azure Cosmos DB, a global, scale-out database system. At the beginning of the talk, I can already...
2017-11-02
28 reads
What? Is probably the most common reply out there and if it is then that is how I felt when...
2017-11-02
425 reads
Sometimes the mistakes you make in the coding lead you to a better understanding of a particular concept.
This happened recently...
2017-11-14 (first published: 2017-11-02)
4,836 reads
Today's post is in regards a feature that was released with SQL Server 2012, it hasn't gotten the attention or used that it deserves even when it helps solving...
2017-11-02
50 reads
Today's post is in regards a feature that was released with SQL Server 2012, it hasn't gotten the attention or...
2017-11-01
562 reads
I’m a big fan of using queries based on the dynamic management view sys.dm_exec_query_stats to capture the most resource hungry...
2017-11-13 (first published: 2017-11-01)
5,305 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