Winner of the April SQL Aloha Contest
This month’s question had 28 responses, and as usual, I found it difficult to select a winner because all of...
2010-05-05
500 reads
Spring 2010 Hardware Recommendations
Since I am very interested in various PC-based hardware, and I make an effort to stay current on new developments,...
2010-05-04
877 reads
How Can I Tell if SQL Agent is Running via SQL?
Introduction
Today’s post is a continuation in my on-going effort to document all of the scripts I use to manage my...
2010-05-04
418 reads
SQL Server Replication - Replication Agents
My first post in my replication series gave a brief overview of replication, before I dive into setting up and...
2010-05-04
7,431 reads
CLR Stability
Recently I was at a UK user group meeting and Simon Sabin of SQL Skills presented a short “SQL Nugget”...
2010-05-04
650 reads
A Glimpse of the Future
I’m not sure what happened here. I walked up to my desktop, wiggled the mouse, and nothing happened. In the...
2010-05-04
543 reads
PASS Update #31 (Election Prep)
Sometime soon we’ll start the process of the 2010 PASS election, with three seats on the Board of Directors being...
2010-05-04
411 reads
May Question: What is your favorite DBA joke?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-05-04
834 reads
Nominations for the 2010 Exceptional DBA Award are Now Open
SQLServerCentral.com, along with Red Gate Software, are glad to announce that nominations for the 2010 Exceptional DBA Awards are now...
2010-05-04
1,561 reads
SQL Server Monitoring Checklist
I have worked with a lot of organizations who just have just a small handful of SQL Server instances. In...
2010-05-03
3,136 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