Slick New Software
I’m lazy. And frankly, I’m not ashamed to admit it. When a software comes along that can do the work...
2010-05-24
1,294 reads
Create Indexes from the Missing Indexes DMV
Glenn Berry (Blog) writes a lot of queries to extract information from the system DMV’s. One of them in particular...
2010-05-24
2,428 reads
East Coast PASS Event Options
After asking members about where the PASS Summit should be located and then deciding to keep it in Seattle for...
2010-05-24
811 reads
Image Testing
One of the things I heard recently from someone was that they clicked some of the links in the newsletter...
2010-05-24
694 reads
PASS Update #33 (SQLSaturday Transfer)
I’ve just finished handing over the source code for all the SQLSaturday related items after finishing up a couple minor...
2010-05-24
498 reads
The World Famous Stapler Method
This is long overdue and goes out to my buddies from the SSAS Class I taught late last year. Two...
2010-05-24
418 reads
SQL Saturday Jacksonville
Well, for those of you who attended, SQL Saturday Jacksonville, was, well I’ll say it, EPIC. Between all the great...
2010-05-24
314 reads
MS Airlift Event in Seattle
I have posted several entries lately about events that I’ve been attending, speaking and listening at and one of the...
2010-05-24
706 reads
Upcoming SQL Events
I realized this morning that I will be participating in three SQL Events this week and I want to share...
2010-05-23
592 reads
IndyTechFest
What would get over 400 techies to give up a beautiful Saturday and spend the day inside learning about SQL...
2010-05-23
1,034 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