Multiple query plans for the same query?
A while back i was creating a stored procedure to be used for pulling data from the SQL Server into...
2011-10-25
13,754 reads
Tuesday Hardware Tidbits
There have been a few interesting developments on the hardware front over the past week that I want to cover...
2011-10-25
1,075 reads
It’s Your Career
It’s your career. It’s something you have to take ownership of and work on. I know that life is busy,...
2011-10-24
1,192 reads
What is Microsoft TAP and RDP?
Technology Adoption Program (TAP) and Rapid Deployment Program (RDP) are ways for Microsoft to get early feedback on new products or product...
2011-10-24
2,278 reads
Brad or Spot?
Today we have another guest post from Steve Jones.
I’m no expert on animals, but I have a little experience out...
2011-10-24
625 reads
SET ARITHABORT ON
When completing an installation I saw the following error – which stopped the installation .
The error occurred during the creation of...
2011-10-24
1,917 reads
I Can’t Go To Space
If I could win the DBA In Space contest, I’d be all over it like white on rice. But I...
2011-10-24
1,467 reads
SQL Server 2012 Developers Training Kit
Microsoft has recently released the SQL Server Developer Training kit for SQL Server 2012. The developers kit includes fantastic resources...
2011-10-24
1,804 reads
PASS Update #66 (All Good Things)
Last week I emailed the Board of Directors my resignation effective December 31st of this year, ending my current term...
2011-10-24
648 reads
ALTER SCHEMA
Use this select statement to create a list of ALTER SCHEMA statements for all stored procedures in a SQL Server...
2011-10-24
1,877 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