Script to Create A TempDB File Per Processor
Introduction
Trying to keep the streak alive so here is my 5th blog post in 5 days. This one is another...
2010-04-09
2,648 reads
S3OLV April Meeting Recap
We held our meeting last night and had a good time. Thanks to those that were able to make it...
2010-04-09
465 reads
How do I ... Write a Backup Strategy?
How do I Write a Backup Strategy?
DBA's harp about the need to have backups. The first thing many DBA’s do when they inherit...
2010-04-09
977 reads
Prius Update – Three Years In
I’ve had the Prius for 3 years as of Mar 31, 2010, and it’s been a great car for us....
2010-04-09
389 reads
Reporting Services 2008 R2 KPI Ready
As I begin to explore more and more of the new feature that will be available in SQL Server 2008...
2010-04-09
1,849 reads
Thoughts on ORM
I’ve posted before about issues I’m having either with behaviors of nHibernate, or behaviors of teams using nHibernate, but I...
2010-04-09
979 reads
The Tweetup
An interesting experiment from Microsoft tonight. They brought 8 or 9 bloggers/press people from around the country to Redmond for...
2010-04-09
1,104 reads
Cloud Computing - Will Data Breaches Cost More?
That's the main point from the following article:
Video: Data breaches to cost more in the cloud
The cost was calculated per...
2010-04-09
1,046 reads
A DMV a Day – Day 9
The DMV for Day 9 is sys.dm_os_schedulers, which is described by BOL as:
Returns one row per scheduler in SQL Server...
2010-04-09
968 reads
Learn How Vendors Price Their Software
As DBAs, we are often put in the position of purchasing software from third-party vendors. If you are like me,...
2010-04-09
1,375 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