Viewing 15 posts - 18,226 through 18,240 (of 22,226 total)
Yeah Steve, give us more stuff!
OK, maybe just for George here for having a bit more wit than others.
"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 24, 2009 at 6:22 am
To really answer the question, we'd need to see the query, but tempdb is used when you create temporary tables, either table variables or old fashioned temp tables, when you...
"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 24, 2009 at 5:50 am
1) Without an index, I suspect both queries will result in a table scan. You would want an index there. With an index, I've generally found TOP to work better...
"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 24, 2009 at 5:48 am
Temporary tables can be dropped automatically as the process that created them leaves scope (the user logs off or breaks the connection). Global temp tables are dropped automatically when all...
"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 24, 2009 at 5:33 am
Yeah, it sounds like duplicate entries and you don't have a natural key defined on the database. That is one of the problems with using an Identity only PK method....
"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 23, 2009 at 6:43 pm
Bruce W Cassidy (2/23/2009)
GilaMonster (2/23/2009)
Maybe the blatant feminism. MZB's not subtle about that when she...
"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 23, 2009 at 6:32 pm
Bob Hovious (2/23/2009)
She Who Must Be Obeyed
You either read H. Rider Haggard or Rumpole....
Gail, yes the Illuminatus Trilogy is worth reading, although written in the early seventies and geared towards...
"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 23, 2009 at 6:30 pm
Bruce W Cassidy (2/23/2009)
GilaMonster (2/23/2009)
Odd, because I normally love Arthurian myth.
[font="Verdana"]After Mary Stewart (brilliant), I find most Atrhurian myth disappointing.
But on the note of dissapointing movies from books and Arthurian...
"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 23, 2009 at 1:20 pm
GilaMonster (2/23/2009)
Grant Fritchey (2/23/2009)
I tried three times to read Mists of Avalon. I got a few pages further each time before flinging the book across the room.
I got about half...
"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 23, 2009 at 1:16 pm
Bob Hovious (2/23/2009)
So.... The Illuminatus! Trilogy?
fnord Hail Eris! fnord
"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 23, 2009 at 1:11 pm
Lynn Pettis (2/23/2009)
I tried reading that book in High School, could do it, don't even want to try now.
I tried three times to read Mists of Avalon. I got 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 23, 2009 at 1:10 pm
I'm extremely weak on replication, so I couldn't begin to tell you why, but I'm pretty sure that's required.
"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 23, 2009 at 1:00 pm
Bruce W Cassidy (2/23/2009)
You don't need the illegal drugs: Philip K Dick did them for you! 😀
Read Exegesis years ago. I don't think I would go back to...
"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 23, 2009 at 12:59 pm
Bruce W Cassidy (2/23/2009)
I've read everything Philip K Dick published (including the short stories), but...
"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 23, 2009 at 12:47 pm
You need to remove the publication prior to upgrade. Then perform the upgrade and then reestablish the publication.
"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 23, 2009 at 12:36 pm
Viewing 15 posts - 18,226 through 18,240 (of 22,226 total)