A DMV a Day – Day 17
The DMV for Day 17 is sys.dm_db_index_usage_stats, which is described by BOL as:
Returns counts of different types of index operations...
2010-04-17
908 reads
SQL Server 2008 R2 Update for Developers Training Kit (April 2010 Update)
On Aprill 2010 is available the SQL Server 2008 R2 Update for Developers Training Kit. This training kit inlcudes:
Presentations (22)Demos...
2010-04-16
727 reads
My Idea for the PASS Summit 2010 Opening Night Reception
First, some background. If you’ve been to the Summit you know that we have an opening night reception, lots of...
2010-04-16
1,127 reads
Powershell SMO Problem
We’ve been running the Enterprise Policy Management tools available from Codeplex for a few months now (Thanks to Buck Woody’s...
2010-04-16
728 reads
Confio Ignite: Part II
I’m continuing to evaluate Confio’s Ignite database monitoring tool. I’ve had it collecting data on a couple of production servers...
2010-04-16
1,823 reads
Book Review – SQL Server Integration Services: Problem – Design – Solution
I usually don't do book reviews (at least publicly, anyway), but when I find a piece of work that I...
2010-04-16
2,166 reads
SQL Server 2008 R2
The RTM date is out for SQL Server 2008 R2. At the UK Tech Days it was released as May...
2010-04-16
629 reads
Visiting Chicago
A few weeks back I was in Chicago for three days for work. I’ve been through the airport a couple...
2010-04-16
965 reads
A DMV a Day – Day 16
We have two DMVs for Day 16. The first one is sys.dm_exec_cached_plans, which is described by BOL as:
Returns a row...
2010-04-16
682 reads
SQL Server 2008 R2 – Release Date
This is a very short post
I’m probably very late to this party but…SQL Server 2008 R2 is scheduled for release...
2010-04-15
520 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