Using Custom Code Functions in Reporting Services Reports
Reporting Services is one of those tools that just keeps on giving. I’ve been using SSRS since the early beta...
2011-10-11
2,871 reads
Learn to Help Yourself
I used to work with a guy who was adamant that before you asked him for help, you had done the...
2011-10-11
1,313 reads
Hardware 301: Diving Deeper into Database Hardware
On Wednesday, October 12, at 10:15AM, I am going to get the pleasure of presenting my Hardware 301: Diving Deeper...
2011-10-11
1,110 reads
Resource Governor clamps down on Greedy Reports
One of the things I run into every now and then is this provincial idea that reports can and should...
2011-10-10
1,312 reads
PASS Summit 2011: Day One
After getting a little lost from the rail to the hotel, I finally got to sleep Sunday night after a...
2011-10-10
520 reads
New and Improved DMVs in SQL Server 2008 R2 SP1
With relatively little fanfare, Microsoft added a few new DMVs into the SQL Server 2008 R2 SP1 release, which came...
2011-10-10
1,362 reads
SQLBits9
SQLBits9 – “Query across the Mersey” was held in the majestic Adelphi hotel. This was my first SQLBits experience and was...
2011-10-10
918 reads
MADPASS Follow-Up
A couple weeks back, I drove out to Madison to present at the MADPASS user group. These guys have a...
2011-10-10
534 reads
SQL Saturday 98 Follow-Up
I’ve been meaning to follow-up with links to the presentations that I delivered at SQL Saturday 98. It’s a few...
2011-10-10
585 reads
Sometimes temp tables can be your best friend
Here is a quick example of when using temporary tables will give you a big performance gain. I recently was...
2011-10-10
899 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
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