Something I learned while the SQL Server 2008 Internals book was in tech edit (thanks to our *awesome* tech editor Ben Nevarez – who, unfortunately, does not have a blog or anything…yet! (well, I'm hopeful)), was that you can use a FOREIGN KEY constraint to reference a UNIQUE index – one without a PRIMARY KEY or [...]
Kimberly L. Tripp
Improving my SQL skills through your questions!
Foreign Keys can reference UNIQUE indexes (without constraints)
Posted on: February 28, 2009 5:37 pm
Getting the most from the system you have now!
Posted on: February 24, 2009 1:30 pm
Given the general state of the economy…many companies are looking to cut back. Going back over what we've done and "optimizing" things -> budgets, expenses, etc. is the norm right now. And, scaling back is not always a bad thing – unless the wrong things are cut. Unless the wrong things are used to motivate [...]
Getting started in speaking publicly – clear and concise presentations
Posted on: February 15, 2009 1:00 pm
Well, I had wanted to come up with a clever reply to my husband's oh-so-romantic blog post (here). And, well, in all honesty, that *is* the best present for me… but, probably not what most would say is romantic ;-). We've both had quite an effect on each other's presentation styles. We constantly remind each [...]
Understanding backups and log-related Trace Flags in SQL Server 2000/2005 and 2008
Posted on: February 13, 2009 4:54 pm
Paul and I started discussing a comment that came up regarding the many issues surrounding logging & recovery. It's one of our favorite topics and in fact was the title to an article that Paul recently wrote for TechNet here: http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx. And, as a sidenote, depending on how much you already know about the transaction [...]
Where in the world does time go?
Posted on: February 5, 2009 12:24 am
I know where I go but where the heck does the time go (it seems to move much faster than I)? First off, I hope everyone had a truly lovely holiday season. I know they've long since past for everyone but maybe this reminder will bring back a nice memory from the holidays as it [...]
