Slides & Samples from my SQLSaturday #115 presentation about ColumnStore Indexes
As I have announced in my ColumnStore presentation last Saturday in Lisbon, you can
find here the slides
& samples for download....
2012-03-19
816 reads
SQL Server 2012: xVelocity
After SQL Server 2012 was released this past week, I saw a few mentions from Microsoft about a new feature...
2012-03-19
1,206 reads
Looking to Windows 9
I haven’t played with Windows 8 yet, and only a little with Windows Phone 7, but I am a little...
2012-03-19
1,403 reads
RYO Maintenance Plan – Integrity Checks
Happy Monday! Everyone fully recovered from St. Patrick’s Day? Hopefully the weather where you are was as perfect as it...
2012-03-19
904 reads
TDE and Compression
I knew that enabling TDE would cause the information stored within to, effectively, be randomized, which means it would seriously...
2012-03-19
2,813 reads
24-Hours of PASS - Be on-time!
Right on the heels of the recent SQL Server 2012 virtual online launch event (as in virtually not there :-), a...
2012-03-19
1,820 reads
Another Interesting Sort
Some code requirements can be met through various means including the use of a different collation - which means a lot of testing.
Related Posts:
Creative Database Naming January 2, 2020...
2012-03-19
9 reads
Another Interesting Sort
In October of 2011, I shared an example of a peculiar set of sort requirements. Today, I am going to...
2012-03-19
850 reads
Troubleshooting Event ID 9 - The device, xxxxx, did not respond within the timeout period.
The System logs returned :
The device, xxxxxxxxxxxxxx, did not respond within the timeout period.
Some common causes
1) SCSI controller firmware
2) Incorrect...
2012-03-19
1,410 reads
Activity Monitor in SQL Server 2012: an Improved Embedded Optimisation Gizmo for the Thrifty DBA
Waaaay back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul Nielsen...
2012-03-18
21,333 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