Index your FK
A few months ago I read an article from SQLServerCentral.com about some Foreign Key gotchas. Since that article, I have seen...
2010-03-05
872 reads
Time Off, Down Time, Round Up
I have taken some time off this week, I have been to the beach with my two golden retriever puppies....
2010-03-04
692 reads
Speaking at SQLSaturday #33 in Charlotte
I'll be presenting two sessions this Saturday (March 6, 2010) in Charlotte - Automate SQL Server Administration with PowerShell and Gather...
2010-03-04
573 reads
Schedule for SQLSaturday #33
Final schedule for the Charlotte event and it is impressive – 9 tracks, 54 sessions!
2010-03-04
514 reads
Focus on Your Passion
Tuesday night I was having a conversation with my younger son, whom we call Turtle. It's a nickname that came...
2010-03-04
1,084 reads
Output = MAXDOP 1
It is widely know that data modifications on table variables do not support parallelism, Peter Larsson has a good example...
2010-03-04
561 reads
Timing Matters
A few weeks ago I got an email from my backup administrator with a message like this:
Set type : Backup
Set...
2010-03-04
312 reads
Self Promotion & Self Marketing
The title of this post illustrates my own ambiguity on the topic. It’s fair and necessary to let others know...
2010-03-04
629 reads
Heading to Charlotte
I think I’ll forever associate Charlotte, NC with my middle son. We were heading back to Denver from Virginia Beach...
2010-03-04
378 reads
Please Provide PASS with Feedback on its Speaker’s Resource Pages
The PASS Program Committee is gearing up for the 2010 PASS Community Summit “Call for Speakers”, and it would like...
2010-03-04
1,002 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