The Dangers of Sub-queries!!!!
Ok, now that I have your attention this really should be titled the danger of not qualifying all objects, but...
2010-07-29
738 reads
Blog Posts
The Killer Backslash in TSQL
--it is
quite startling to see that this, in TSQL, executes.
Select \
/*
---------------------
0.00
(1
row(s) affected)
so does
this....
*/
Select null /\/\/\/\/\/\/\/\/\/\/\/\
/*
---------------------
NULL
(1
row(s) affected)...
2010-07-29
5,817 reads
What Indexes are on My Table!
In this quick blog, I want to show you one way of how to find out what indexes you have on a table...
2010-07-29
483 reads
2010 3rd Quarter Goals
Now that we are into the third quarter of 2010 I decided to post an update of my 2nd quarter...
2010-07-28
1,010 reads
Interviewed by Andy Leonard
Andy Leonard is posting interviews of all the candidates PASS Board of Directors on his blog and mine is up...
2010-07-28
386 reads
Interviewing for the PASS Board of Directors
My nomination application made it through the committee. I got an email yesterday telling me that I needed to schedule...
2010-07-28
798 reads
MDX Puzzle #4
This puzzle is rather simple, but it does introduce a few new things. Using T-SQL you typically filter queries with...
2010-07-28
551 reads
PASS 2010 Summit on LinkedIn Event Calendar – Have You RSVP’d?
Happened to notice in my weekly LinkedIn update today that Todd McDermid had signed up for the 2010 Summit event...
2010-07-28
791 reads
PASS Update #38 (SQLSaturday Wiki)
For the past couple years we’ve had a few different documents that covered how to run a SQLSaturday, but as...
2010-07-28
639 reads
Sharing Remote Desktop Sessions
I work for a very large company where divisions are spread out literally all over the world. There are many...
2010-07-28
898 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
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
A Fun Computer Quote
Comments posted to this topic are about the item A Fun Computer Quote
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