Save yourself from despair with full database documentation
Your ability to document thoroughly will determine your efficiency and productivity when it comes to managing your SQL Server databases....
2012-03-29
2,756 reads
Contained Databases in SQL Server 2012
One of the problems with databases in SQL Server is the dependency of the database on various parts of the...
2012-03-29
2,019 reads
Importing data from Excel – using INSERT statements
You can easily import data from an Excel file to SQL Server using SQL Server Import and Export Wizard. However,...
2012-03-29
3,333 reads
Error 18456 a little more friendly in 2012
While preparing a demo for a presentation, I generated a 18456 error in the SQL instance by selecting a non-existent...
2012-03-29
1,181 reads
Why I am excited about SQL Server 2012 (Part 2)
Earlier this month I published a blog entry on this same subject. In honor of the local Minneapolis launch event,...
2012-03-28
707 reads
I am looking for change
I am looking for a change. Yes, a change. This is the beginning of that quest. This blog will be...
2012-03-28
850 reads
Microsoft Failover cluster 2008 : Moving MSDTC to new SAN disk
We have four node cluster on Windows 2008 where the MSDTC disk hosted on a SAN array. Now we have...
2012-03-28
5,965 reads
SQL Server 2008 Diagnostic Information Queries (April 2012)
Since it is nearly April, I will go ahead and jump the gun again and post an updated version of...
2012-03-28
1,095 reads
Stress Thoughts-Part 3
It’s not fair. I hear it a couple times a day. Sometimes they are right, sometimes not, but it’s how...
2012-03-28
692 reads
TinyInt problem in SSAS
If you have a source table that has a Tinyint primary key column defined as IDENTITY and you create a...
2012-03-28
1,630 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