A DMV a Day – Day 27
The DMV for Day 27 is sys.dm_tran_locks, which is described by BOL as:
Returns information about currently active lock manager resources....
2010-04-27
7,563 reads
PASS Summit, Kilt Wednesday
Last year at the PASS Summit we held a silly little event called Kilt Wednesday. Only three people took part,...
2010-04-27
1,409 reads
SQLSaturday #49 Call for Speakers is Open & Call for Our PreCon Seminar
SQLSaturday #49 will be held in Orlando on October 16th, 2010, and our call for speakers is now open. We’re...
2010-04-27
595 reads
One Trip Booked – TechEd 2010
Tia thinks I’m crazy to book early, but I like to have a choice of flights, and I like to...
2010-04-27
784 reads
SQL Server Replication Overview
For my next series of blog posts I intend to document and write about SQL Server replication. This is a...
2010-04-27
2,511 reads
SQLSaturday #41 – Atlanta Recap
I had the opportunity to go present at SQLSaturday #41-Atlanta this past weekend (April 24, 2010) and I had a...
2010-04-27
824 reads
SQL Saturday - Columbia, SC - October 2, 2010
This is the official announcement that we are officially scheduled for holding a SQL Saturday in Columbia, SC, on October...
2010-04-27
894 reads
Latest Issue of The SQL Server Standard – Volume 7 Issue 3
Available for download by all PASS members (membership is free), this issue has Techies Talking to Non-Techies by Don Gabor....
2010-04-27
631 reads
The PASS Summit Survey Results 2010
I hope there will be more surveys, so I’ll tag this as 2010. The results were released recently, and there...
2010-04-27
2,193 reads
SQL Server 2005 Diagnostic Information Queries (April 2010)
Since SQL Server 2008 R2 has gone RTM, and will soon be available for purchase, I am going to be...
2010-04-26
1,002 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