Viewing 15 posts - 21,001 through 21,015 (of 22,219 total)
Yeah, we had a guy who said he was a 10 on internals. We asked him how an index was stored... "In the database."
Ta-Da!
Thanks for playing. Our parting contestants will...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 28, 2008 at 8:06 am
Mark Markov (2/28/2008)
He said: If you need to do a lot of SELECT, would you use a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 28, 2008 at 7:48 am
What ahutchens says and check the configuration manager.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 28, 2008 at 7:34 am
Yeah, but did you log in from a different machine to the server? The reason is, you need to confirm that it's allowing external connections.
ODBC works fine with instance names....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 28, 2008 at 7:13 am
leea (2/28/2008)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 28, 2008 at 6:51 am
Verify that you've got the names correct. Can you connect using management studio from a different machine?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 28, 2008 at 6:23 am
GSquared (2/28/2008)
One small quibble with it. In one of the examples, you use "((FullName1 = 'Ed Jones') OR (FullName1 IS NULL))", as an example of how to get...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 28, 2008 at 6:20 am
What about using DATEDIFF on days where it equals zero?
Still, joining on something like this is going to be problematic. Most problematic of all, you're joining on columns that clearly...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 28, 2008 at 5:43 am
You can even go into the tempdb and watch the tables being created. You don't need to worry about the users stepping on each other. You do need to make...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 28, 2008 at 5:34 am
I'd try using a derived table with a BETWEEN clause to identify all those that are within the service period and then left join that back to the table again...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 28, 2008 at 5:29 am
Dave (2/27/2008)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 27, 2008 at 9:46 am
The company I work for puts us through a variety of tests, either administered by HR or through classes with the managers. Unfortunately, I don't know them all. One...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 27, 2008 at 6:34 am
I truly love the concept of Connect. When I first got introduced to it, early on working with Data Dude, I was all over it, constantly searching for bugs, voting,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 27, 2008 at 5:19 am
OK. Well, have you tried using a JOIN to put the data from the three tables together?
I could simply write the query for you, but this looks a bit like...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 22, 2008 at 6:47 am
What have you tried so far?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 22, 2008 at 6:25 am
Viewing 15 posts - 21,001 through 21,015 (of 22,219 total)