Viewing 15 posts - 15,886 through 15,900 (of 22,219 total)
Paul White (1/29/2010)
Jeff Moden (1/28/2010)
Would someone explain to me the attraction to sites like Twitter and FaceBook and explain what they're actually good for so...
It's a bit like SQL Server...
"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 29, 2010 at 7:00 am
No, that was some seriously scattered questions & responses. I think a bit of the old hickory was needed.
"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 28, 2010 at 8:48 am
Gianluca Sartori (1/28/2010)
My sincere apologies to everybody for posting code in The Thread.It will never happen again.:-D
The more code we post in the Thread, the sooner it achieves consciousness and...
"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 28, 2010 at 6:36 am
jcrawf02 (1/28/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 28, 2010 at 6:30 am
And on a move that big, test your backups. Simply backing up is not enough. You need to know that they work.
"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 28, 2010 at 5:49 am
Alvin Ramard (1/27/2010)
Lynn Pettis (1/27/2010)
Alvin Ramard (1/27/2010)
How nice it would be if getting answers from PASS was as simple as dealing with the OPs on here.One can only wish.
Are 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
January 27, 2010 at 2:04 pm
Yep, they can all run on the same machine without issue, except of course that they'll compete for the resources available on that 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
January 27, 2010 at 7:44 am
Connection settings can be changed, independent of your database default connection settings. It's possible for the app to come in using serializable. I'd check the code if you're sure the...
"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 27, 2010 at 7:36 am
I agree. If you're just moving the box, there's little you need to sweat on the server. But, you will need to validate that the clients aren't using IP &...
"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 27, 2010 at 7:34 am
GilaMonster (1/26/2010)
Grant Fritchey (1/26/2010)
Only the unique constraint on the index would be of use when looking at the execution plan.And whether or not it's filtered
Oh, true, didn't think about...
"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 26, 2010 at 8:02 am
There isn't one hard & fast number for most of these values. Almost all of them are dependent on your particular hardware and it's configuration. But, most performance monitoring or...
"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 26, 2010 at 7:51 am
One thing you can use to look at "hung" processes is to go after the dynamic management view sys.dm_exec_requests. This will show you the active processes in the server including...
"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 26, 2010 at 7:48 am
WayneS (1/25/2010)
GSquared (1/25/2010)
Grant Fritchey (1/25/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 26, 2010 at 6:07 am
That's good. Buck Woody also did a fantastic presentation about it at the last PASS Summit.
"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 26, 2010 at 6:01 am
They can be any number of things. Lots of resources use tempdb within SQL Server, sort operations, table spools, hash joins, cursors, lots of stuff. You'll see that encrypted name,...
"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 25, 2010 at 7:48 am
Viewing 15 posts - 15,886 through 15,900 (of 22,219 total)