Thank God I Chose SQL Server part II: How to Improperly Install Oracle 11gR2
As part of my ongoing effort to teach by bad example and pass on what little I’ve learned about programming...
2012-05-01
3,564 reads
Less Energy through Better Design
When I attended SQL Saturday #131 at the Chandler Gilbert Community College, I was struck by a few design elements...
2012-04-30
2,005 reads
SQL Saturday #131 Recap
This past weekend I attended a SQL Saturday in the desert. SQL Saturday #131 was held in Phoenix, AZ
It’s April,...
2012-04-30
1,924 reads
Generate restore script automatically by backup history table
I wrote a store procedure which could generate restore script automatically by backup history table. it can help you select...
2012-04-30
7,016 reads
There is awesomeness to be had at #SQLRally
Two days of precons.
60 regular sessions over two days.
The now-famous Women in Technology luncheon.
Open access to Microsoft Customer Service and...
2012-04-30
1,514 reads
You need to run DBCC CheckDB regularly
You never know when you’ll encounter corruption. It can happen at any time, usually due to some sort of hardware...
2012-04-30
3,351 reads
SSAS File System Error
I received this error the other day when trying to process a particular SSAS cube:
Error 18 File system error: The...
2012-04-30
2,923 reads
SQL Server 2008 Diagnostic Information Queries (May 2012)
Since tomorrow is May 1, I think it is time to publish the latest set of SQL Server 2008 Diagnostic...
2012-04-30
1,950 reads
Blogging Tools: BlogDesk Review
As a blogger, you have several options available to you when it comes to writing posts. You can write them...
2012-04-30
2,227 reads
Changing DB_CHAIN Can Clear the Plan Cache
If you make changes to the settings of a database, it can cause the procedure cache to be cleared. Microsoft...
2012-04-30
1,798 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