SQL Server 2008 R2 SP1 CU3
Microsoft has released SQL Server 2008 R2 SP1 Cumulative Update 3. This is Build 10.50.2789.0, and it has 22 listed...
2011-10-18
1,173 reads
Implicit Conversions warning
After adding an index, ensuring that an index is actually used is probably the biggest win you will get in...
2011-10-17
1,269 reads
The Demise of Jar Jar
Today we have a guest post from Steve Jones as Brad is on vacation.
Today we have the third question from...
2011-10-17
535 reads
Guest Appearance in DBA in Space
Win a trip into space!
The DBA in Space competition continues today with the third question. This time I get to...
2011-10-17
1,451 reads
PASS Summit 2011: Wrap-Up
Another Summit done gone by and I’m exhausted. You know you did the Summit correctly if you’re crawling onto the...
2011-10-17
1,449 reads
Scaling SQL Server
On Friday, October 14, 2011, I had the pleasure of delivering my new Scaling SQL Server presentation at the PASS...
2011-10-17
810 reads
Performance tips for SSAS
Over the past few years I have developed a list of ways to improve performance in SSAS and in two...
2011-10-17
4,149 reads
SQL PASS Summit 2011: Session Files
SQL PASS Summit 2011: Session Files
PASS Summit 2011
This past week was the SQL PASS Summit 2011 in Seattle, WA. I...
2011-10-17
1,434 reads
Self Service BI and PowerPivot
Marco Russo and Alberto Ferrari have written a book called Microsoft PowerPivot for Excel 2010: Give Your Data Meaning that I finally...
2011-10-17
1,244 reads
Extended Events Data
I’ve been working quite a bit over the last week or so with extended events in Denali. The sheer magnitude...
2011-10-17
1,901 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