Thank you for Microsoft MVP
My head may very well explode. I was done some tuning today and glanced at the Outlook new mail notification....
2017-09-02
373 reads
My head may very well explode. I was done some tuning today and glanced at the Outlook new mail notification....
2017-09-02
373 reads
SARG is short for Search Argument. This is an important tuning term and something every developer and DBA should know....
2017-08-31
3,791 reads
It’s Wednesday and that means another SQL/Oracle post. Today we’ll be discussing NULL Values, which can sometimes be a real...
2017-08-28 (first published: 2017-08-16)
9,210 reads
I’ve been teaching my 17 yr old SQL Server and other various topics. I have quite a bit of experience...
2017-08-18 (first published: 2017-07-31)
2,425 reads
It’s been a while since I’ve done a SQL Saturday and I’m happy to be joining the folks in Orlando...
2017-08-16
302 reads
Over this week we’ve looked at the difference between Oracle and SQL Server from a few different angles. We’ve looked...
2017-08-11
883 reads
Today’s topic is Pagination. Paging is a really important feature for web pages and applications. Without it you’d be passing...
2017-08-10
400 reads
In today’s continuation of the SQL / Oracle series, I thought it’d be nice to show how different the two are...
2017-08-09
295 reads
Continuing my series on SQL Server and Oracle, I thought I’d highlight a function that has been in Oracle from...
2017-08-08
298 reads
Are you a DBA and just inherited a SQL Server or Oracle database? Are you migrating from one or the...
2017-08-07
305 reads
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
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...
We want to setup a gateway db to host stored procedures which use tables...
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...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers