Capture Index Usage Statistics for Better Analysis
Starting with SQL Server 2005, Microsoft introduced Dynamic Management Views to help DBAs see what's going inside of SQL Server....
2012-10-23
2,554 reads
Linked Server setup with Oracle
Linked Server
Setup with Oracle in SQL Server:
Suppose you want to access data from
oracle or other database products using T-SQL via...
2012-10-23
2,270 reads
Parallel Data Warehouse (PDW) Tip: Proof of Concept (POC) Guidelines
As with any other project our objective is to drive PDW POC success! To clear and cultivate the playing field for successful POC engagements, we must, at a minimum,...
2012-10-23
24 reads
Parallel Data Warehouse (PDW) Tip: Proof of Concept (POC) Guidelines
As with any other project our objective is to drive PDW POC success! To clear and cultivate the playing field...
2012-10-23
1,139 reads
Don’t Be That PASS Summit Guy
Don’t Be That PASS Summit Guy
PASS Summit 2012 Speaker
The SQL PASS Summit 2012 is just around the corner. Every year...
2012-10-22
1,207 reads
Trace Flag 2371 and Statistics
One of the issues that I see published often on forums like SQLServerCentral is the advice to update statistics on...
2012-10-22
9,578 reads
What Happened to rowmodctr from Sysindexes?
In my blog series Lost in Translation – Deprecated System Tables, I’ve been going through the compatibility views in SQL Server...
2012-10-22
2,594 reads
Clustered Indexes Have Statistics Too
It may seem obvious, but I’ve heard more than one person suggest to me that statistics on a clustered index...
2012-10-22
1,163 reads
Last Weeks Top 10 “Reading” Links #3
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out...
2012-10-22
706 reads
Preparing for Certification
One of my goals back when I was a young MCSE (that's Microsoft Certified System Engineer for NT4, not the...
2012-10-22
1,360 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