Choosing the Right Microsoft Reporting Technology Part 3: PowerPivot
Today I’ll be continuing in a blog series designed to help you decide which presentation tool is best for your...
2012-03-21 (first published: 2012-03-16)
2,962 reads
Today I’ll be continuing in a blog series designed to help you decide which presentation tool is best for your...
2012-03-21 (first published: 2012-03-16)
2,962 reads
The Merge Join is a Physical Operation when joining 2 sets of data that are in the same order.
There...
2012-03-15
5,914 reads
Columnstore Indexes for Fast DW
The SQL Server 11.0 release (2012) introduces a new data warehouse query acceleration feature based on...
2012-03-19 (first published: 2012-03-15)
4,065 reads
Last night I presented a new presentation I'm working to add to my inventory, SQL Server Permission and Security. This...
2012-03-15
598 reads
In part 1 I explained how I was hunting for the root cause for some query timeouts that happened every...
2012-03-20 (first published: 2012-03-15)
2,923 reads
This will be my first Meme15 (here’s Jason Strate’s original Meme15 post), and today we’re talking Facebook. The question is:
How...
2012-03-15
825 reads
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-03-15
654 reads
I spent sometime to understand more about tempdb today. posting some key points for our quick reference.
some key books/links on...
2012-03-15
2,299 reads
This is a short script to help the DBA with documentation purposes. This would come in handy especially in those cases where you are consulting or you have taken...
2012-03-15
12 reads
This is a short script to help the DBA with documentation purposes. This would come in handy especially in those...
2012-03-15
862 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