Quotename in SQL
Quotename() is a SQL Server String function.
It accepts an input string of of up to 128 characters. Which is a...
2011-11-15
8,094 reads
Speaking Engagements
It only seems like a couple of weeks ago since I wrote a post about new years resolutions which you...
2011-11-15
529 reads
Tuesday Hardware Tidbits, Nov 15, 2011
A couple of interesting developments this week. First, Intel has officially released (and lifted the embargo) on their new high-end,...
2011-11-15
854 reads
Writing queries without data
Sometimes it’s not possible to have the data you need in order to create the most efficient queries possible. This...
2011-11-15
726 reads
SQL Inspire NYC – 2011
The lineup for SQLInspire
I spoke at the SQL Inspire event this last weekend and it was a greart experience. This...
2011-11-14
1,506 reads
Do You Use “Forced Parameterization”?
In SQL Server 2005 and later, there is a database option called “forced parameterization”. When it is turned on, it...
2011-11-14
800 reads
DBA in Space: Behind the Scenes Part 1
The DBA in Space contest ends November 18, 2011. If you haven’t entered yet, you still have time.
Filming DBA in...
2011-11-14
737 reads
Another reason that T-SQL beats the GUI
In IT, we have a few very solid and universal principles that no one ever argues with. The first of...
2011-11-14
582 reads
No SQL Saturday - Columbia, SC in 2012
Last week my partner in crime, Bobby Dimmick (blog | twitter) and I sat down for lunch and caught up and...
2011-11-14
1,677 reads
Many-to-Many Dimensions
In SSAS, data structures do not always conform to the snowflake or star schema model where one fact is associated...
2011-11-14
1,522 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