It is always good to enrich SSRS reports with multi-value parameters; users have more flexibility to combine different reporting scenario...
2014-09-03 (first published: 2014-08-27)
28,010 reads
Thursday night (8/28) I'll be presenting Inspector Insert And The Case Of The Mistaken IDENTITY for the Orlando SQL User...
2014-08-27
1,207 reads
I’ve been told over the years that I’m pretty good at finding jobs. I mean in the last 25 years...
2014-09-04 (first published: 2014-08-27)
7,712 reads
As I mentioned earlier, we use Perforce as our source control package, so all of the scripts presented here are...
2014-09-03 (first published: 2014-08-27)
7,381 reads
Continuation from the previous 38 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
In this post I shall try to discover more interesting information about...
2014-08-26
610 reads
This is part of a series of tips for speakers to make your presentations better.
I wanted to give some specific SQL...
2014-09-01 (first published: 2014-08-26)
7,299 reads
The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released since the...
2014-08-26
20 reads
Registration is 332 as of 8 am on August 26. We added a whopping 40 registrations last week – a very...
2014-08-26
1,073 reads
I was having a discussion the other day and was quite surprised to hear that there still appears to be...
2014-08-26
179 reads
I was having a discussion the other day and was quite surprised to hear that there still appears to be...
2014-09-02 (first published: 2014-08-26)
7,906 reads
As for me, I'll keep writing whenever time permits. I don't expect every post...
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Comments posted to this topic are about the item Pay for Performance, which is...
Hi I have this slow query that is pulling data from a linked server....
Comments posted to this topic are about the item Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers