Viewing 15 posts - 15,916 through 15,930 (of 22,219 total)
Jeff Moden (1/13/2010)
Grant Fritchey (1/13/2010)
"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
January 14, 2010 at 5:51 am
Steve Jones - Editor (1/13/2010)
Grant,I didn't think it was that bad, but when it doubt, doesn't hurt to apologize.
Yep. I agree. As soon as it was pointed out I threw...
"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
January 13, 2010 at 9:29 am
Try the cache refresh, CTL-SHIFT-R
"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
January 13, 2010 at 9:18 am
My sincere apologies to the group for the term I used. I had learned it, a long time ago, in terms like this, not like the first slang listed here....
"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
January 13, 2010 at 7:58 am
Lynn Pettis (1/13/2010)
Maybe, but I'm willing to try and help him. And looking at was suggested by his PAID developers, it is an opportunity to show him we are...
"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
January 13, 2010 at 6:27 am
I just read through that whole rigamarole. What a dink. Lynn, you're WAY too nice.
"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
January 13, 2010 at 5:39 am
umailedit (1/7/2010)
The reason I asked this was, database corruption almost...
"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
January 7, 2010 at 1:59 pm
nVarchar(max) only has a size limit, not a character limit and we're talking gb's, so you shouldn't be hitting that limit (not saying you're not, but you sure shouldn't be).
"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
January 6, 2010 at 12:56 pm
Steve Jones - Editor (1/6/2010)
When I'm with Scouts, if we're out in the woods and something breaks, you need to have things to respond 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
January 6, 2010 at 9:51 am
GilaMonster (1/6/2010)
"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
January 6, 2010 at 8:30 am
CirquedeSQLeil (1/5/2010)
Lynn Pettis (1/5/2010)
CirquedeSQLeil (1/5/2010)
Urgent, going to lose my job.http://www.sqlservercentral.com/Forums/Topic834653-338-1.aspx
And then three weeks later...
http://www.sqlservercentral.com/Forums/Topic842291-149-1.aspx?Update=1
Hmmm...I guess the prof gave him an extension?
Actually, nothing earlier indicated that it was urgent, so more...
"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
January 5, 2010 at 1:14 pm
There are multiple web sites out there that list the various symbols used by the different modeling methods. For example, here's the class, probably most reductive example: http://en.wikipedia.org/wiki/Entity-relationship_model
"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
January 5, 2010 at 1:05 pm
Tossing another penny down the well, I'd go with the Internals books. I'd especially focus on T-SQL Querying book. It has a couple of chapters on how the optimizer works...
"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
January 5, 2010 at 7:04 am
sunpalozzi (1/5/2010)
"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
January 5, 2010 at 6:59 am
The thing you're looking for is the TOP operator (check it out in BOL) but it's going to return nonsense values if you don't supply additional information, basically something 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
January 5, 2010 at 6:56 am
Viewing 15 posts - 15,916 through 15,930 (of 22,219 total)