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
844 reads
Blog Posts
Columnstore Indexs
Columnstore Indexes for Fast DW
The SQL Server 11.0 release (2012) introduces a new data warehouse query acceleration feature based on...
2012-03-19 (first published: 2012-03-15)
4,050 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,398 reads
Powershell - Working with Cluster Resources - Byte Arrays
Over the next few weeks, I plan to share some of the discoveries I've had when working with Windows 2008R2...
2012-03-19
2,485 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
895 reads
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
809 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,196 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,809 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,395 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,313 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers