System Reserved Partition and monitoring
On Windows 2008 R2 , a System Reserved Partition is created. It is 100 MB and acts as a preparatory step...
2011-12-02
1,049 reads
Using NOLOCK hint
Use NOLOCK hint to avoid block - this is what I have often heard/see in many forums I participate, during local...
2011-12-01
624 reads
Database Mirroring In A Windows Workgroup
Database Mirroring is a popular high availability solution and low-cost alternative to clustering, especially for smaller shops who can't afford...
2011-12-01
4,784 reads
The Blocked Process Report
A few days ago, one of my customers asked if there is a possibility to get a notification
from SQL Server...
2011-12-01
5,626 reads
SQL Saturday 99 – Digineer Interview
Welcome to the second of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-12-01
778 reads
PASS Update #67
It’s been a slow few weeks since my last update. This week I did a call with Karla and Wes...
2011-12-01
439 reads
SQL Server 2012 – Bug in sys.fn_xe_file_target_read_file?
So I finally managed to get my hands on a VM with Windows 2008 R2 SP1 so I could install...
2011-12-01
1,162 reads
PASS Update #67 (Election)
Today the slate of candidates for the 2012-2013 term was announced;
Adam Jorgensen, Denise McInerney, Geoff Hiten, Kendal Van Dyke,...
2011-12-01
648 reads
DBA in Space: Behind the Scenes—Question 9
This is a continuation of my DBA in Space journal.
Episode nine was filmed in the “Mars” exhibit. In this scene,...
2011-12-01
637 reads
December Question: When reflecting on this year, what has gone well, and what would you do differently?
December is the last month of the year, and is often a good time to reflect on the past year...
2011-12-01
1,185 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