PASS, Don’t Waste My Time
Update: Apparently I can't write, or get a point across from the
comments and a few emails, so I have...
2010-06-30
2,520 reads
DB2 – Create a Database
OK for my next DB2 trick and remaining off the path of the righteous for the time being we will...
2010-06-30
5,017 reads
Truncating the Log and Database Mirroring
I saw someone post recently that they wanted to run this code on their principal server in database mirroring to...
2010-06-30
2,136 reads
MS Access Annoyance: Doesn’t Link Synonyms
I use Access when I don’t have dedicated admin tools for editing data, frequently the case for infrequently changed data...
2010-06-30
3,153 reads
Does Your Company Have a SQL Server DR Plan?
This past month I ran a poll asking this question: “Does your company have a formal, tested, disaster recovery plan...
2010-06-30
1,561 reads
The Trade Deadline Must be Drawing Near
The Trade Deadline Must be Drawing Near
Okay, so there is no trade deadline in SQL Server like there is in...
2010-06-29
2,145 reads
Does a missing data file send a database suspect?
Short answer: No
I keep seeing this come up on various forums when people ask what makes a database go suspect...
2010-06-29
2,053 reads
Partition Alignment and Late Night Infomericals
Late night infomercials make some amazing claims. “If you order now you too can cut through a cinderblock wall and...
2010-06-29
1,522 reads
‘Tis the Season for SQL Leaving
With the announcement of Brent Ozar (Blog | Twitter ) leaving Quest for SQL Skills, Exceptional DBA finalist Jorge Segarra (blog | twitter)...
2010-06-29
1,611 reads
SQL Saturday #28 (Baton Rouge) – All about User Groups
This year at SQL Saturday #28 we will be featuring a User Group Booth alongside the Sponsor booths. The User Group...
2010-06-29
1,570 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