Forum Replies Created
Viewing 15 posts - 14,191 through 14,205 (of 22,224 total)
-
RE: 40 vs. 45 Hour Workweeks
CirquedeSQLeil (10/5/2010)
Grant Fritchey (10/5/2010)
I carve time out of my day, at work, to make sure I'm learning stuff. I read a bit, test a bit, write a bit, at work,..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Women and Men - Same or Different?
mtillman-921105 (10/5/2010)
pjdiller (10/5/2010)
I'm short. Don't tall people make more on the average? :discuss:From what I've heard on the news, more tall people become managers.
That's because we can see...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Steve Jones - SSC Editor (10/5/2010)
I see this a lot, even with authors. People think you are following along with them, or they don't realize they're skipping steps to..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL2008 -> SQL2005 using 'copy database' and SMO objects - just won't work!
I wouldn't try it that. Instead, script out the 2008 database to a script or set of scripts. Then you can run those on the 2005 instance, fixing what you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Women and Men - Same or Different?
Men want to stop playing these games and just do the job.
Will that day ever come?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: How to: Check which query causing the most cpu usage?
Exactly what Gail says. You can use the list she provided earlier as the basis for your server side trace.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: How to: Check which query causing the most cpu usage?
tt-615680 (10/5/2010)
Grant Fritchey (10/5/2010)
Which, do the same as the default trace or capture RPC:Complete & SQL:BatchComplete events?Yes, I know there are many queries or sysyem sp's that cannot be used...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL SERVER Training on Advanced database administration
Then all you've got to do is run a search through Google or Bing. Here's one. First thing listed is, again, Microsoft training. Going to the source never hurts.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: How to: Check which query causing the most cpu usage?
tt-615680 (10/5/2010)
GilaMonster (9/29/2010)
arr.nagaraj (9/29/2010)
Default trace contains the recently ran queries along with a few useful informationlike CPU, starttime etc. .. Probably can help your root cause analysis
The default trace does...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL SERVER Training on Advanced database administration
I don't know that there's any one place to get advanced training online (meaning for free). But there are several places you can go. Microsoft has a number of courses...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: 40 vs. 45 Hour Workweeks
I carve time out of my day, at work, to make sure I'm learning stuff. I read a bit, test a bit, write a bit, at work, so that I'm...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: New User, just wanted to say hi
Welcome to the party. Keep your hands and feet inside the vehicle at all times.
Yeah, the ability to run a search engine should probably be one of the most introductory...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Index tuning advisor errors. cannot find stored procedure
I'm still of the opinion that you are either not connecting to the correct database, or your security doesn't allow you to see those procs. It's also possible that they're...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Chad Crawford (10/4/2010)
Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just one DVD with select sessions..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
GilaMonster (10/4/2010)
I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?Doesn't really matter does it?...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 14,191 through 14,205 (of 22,224 total)