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
866 reads
Blog Posts
Keep Your Data Clean
In working with client data you start to notice trends that raise flags in your mind. In my case I'm...
2010-03-05
502 reads
More SQL Azure Samples
I have been playing around some more with SQL Azure in order to get ready for an upcoming presentation, so...
2010-03-05
2,274 reads
PASS Update #24
Time to update you again on all things PASS. First, I haven’t made a lot of progress on the speaker...
2010-03-05
533 reads
SQL Saturday Schedule Update
In January, I blogged about the upcoming SQL Saturdays for 2010, and since then, many more events have been scheduled,...
2010-03-05
612 reads
Worst Thing to Do to your DBA
Recently Andy Warren Blogged about things that could drive your DBA mad. There was a lot of feedback on SQLServerCentral...
2010-03-05
757 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
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
372 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
558 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
999 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers