When a Covering Index no longer covers
I received an email from my boss on the morning supervisors approve timesheets. He stated that they are complaining about...
2012-10-14
2,074 reads
Database Design Contest at the 2012 AITP Region 3 Student Conference
Had a great Friday in Lafayette, LA on the campus of the University of Louisiana-Lafayette. 31 different teams submitted database...
2012-10-14
976 reads
2012-10-13
5 reads
2012-10-13
6 reads
2012-10-13
9 reads
2012-10-13
11 reads
Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning
The San Francisco SQL Server User Group – Oct 10 2012 Thanks you everyone for attending session, here is the presentation...
2012-10-13
325 reads
Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning
The San Francisco SQL Server User Group – Oct 10 2012 Thanks you everyone for attending session, here is the presentation...
2012-10-13
1,007 reads
CSSUG Oct2012 - My Session Presentations and Scripts Are Available Here
Chennai SQL Serve User Group Meet for Oct'2012 happend today at Microsoft Traning Centre located in Radhakrishnan Road, Chennai.
Its pleasure seeing enthusiastic...
2012-10-13
905 reads
Ask the Unicorn: How to become a DBA?
Every now and then I get a question in e-mail and I usually just reply and leave it at that. ...
2012-10-12
693 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