GET MVP DEEP DIVES VOL 2 50% OFF - TODAY ONLY!
Quick blog post to let you know that a special ONE-DAY TODAY ONLY deal by the publisher of the fantastic SQL Server...
2011-10-04
1,339 reads
Index usage
Last week I blogged about how to get help identifying possible missing indexes by using some of the DMV’s provided...
2011-10-04
823 reads
TCP Chimney offload
On Windows 2003 Enterprise Edition Service Pack 2 TCP Chimney was enabled by default. It took me a while to...
2011-10-04
1,261 reads
Backup/Restore vs Detach & Attach
You want to move a database from one server to another. There are two options to do that.
1) Detach/Attach: To...
2011-10-04
1,034 reads
Attend the PASS Summit from Home, 2011 edition
Hidy-ho there, neighbors! This is an update of last year’s Attend the PASS Summit from Home blog. I’ll be updating this...
2011-10-03
1,548 reads
SQL Server – Marking a stored procedure as system object
Marking a stored procedure as system object allows to run the procedure in a user database context. There are two...
2011-10-03
2,739 reads
SQL Bits 9
SQL Bits was great
It’s been two years or more that I’ve been invited to SQL Bits. Not by email, but...
2011-10-03
1,274 reads
Using Configuration Tables in SSIS 2008/2005
SSIS packages are great ETL tools and can do just about anything you need in terms of ETL. Most organizations...
2011-10-03
1,284 reads
A "New Guy" Joins Our Team
It's a great day for me and Moulding and Millwork (the company I work for). A few weeks back, I let you all know that I'd been given the...
2011-10-03
13 reads
A "New Guy" Joins Our Team
It's a great day for me and Moulding and Millwork (the company I work for). A few weeks back, I let you all know that I'd been given the...
2011-10-03
15 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