Why would you do this?
select distinct(hostname),
(select count(*) as criticalCnt
from @temp where severity_guid='0168A833-1732-411E-8205-C2F6CD91737D'
and hostname=t.hostname
group by hostname),
(select count(*) as criticalCnt...
2010-07-16
1,920 reads
This is just a short post for a Friday, I have no technical content ready to publish today but lots...
2010-07-16
644 reads
I’ll announce it here first, along with some reasons why I’m waffling from an earlier post:
I’m going to run...
2010-07-16
2,185 reads
Tour de Career
It’s July and for some that means baseball and bar-b-ques. For me it means my birthday and Tour...
2010-07-16
635 reads
My first guest editorial published !
http://www.sqlservercentral.com/articles/Editorial/70725/
Would appreciate any comments you have.
2010-07-15
579 reads
With query performance becoming a constant battle, its often a forgotten fact that cursors should be avoided (in the majority...
2010-07-15
683 reads
This is the review of the second chapter of the book Defensive Database Programming. The title of this chapter is...
2010-07-15
1,822 reads
This will start a new trend on my blog. Every Friday morning I'll have a blog post covering the free SQL...
2010-07-15
746 reads
I’ve had variations of this conversation a couple of times lately and thought it was worth writing down some thoughts....
2010-07-15
506 reads
Download Script
Sorry that it’s taken me so long to write this post, but I have been a little busy with...
2010-07-15
691 reads
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
Comments posted to this topic are about the item Lots of FKs
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Comments posted to this topic are about the item Can You Let Go of...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers