Grant Fritchey

Forum Replies Created

Viewing 15 posts - 13,861 through 13,875 (of 22,232 total)

RE: How do I know when to use temp tables/table variables?

Craig Farrell (12/2/2010)
SQLNW (12/2/2010)
Thank you Wayne, I am thinking why do we use temp table in the first place? As soon as you see a problem how you decide 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

December 2, 2010 at 1:28 pm

#1258097
RE: How do I know when to use temp tables/table variables?

SQLNW (12/2/2010)
Thanks so much Grant. I have a silly question. when do you actually know when to use temp table concept in the first place, I mean if you look...
"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

December 2, 2010 at 1:27 pm

#1258095
RE: Set Up And Schedule a Server Side Trace

CavyPrincess (12/2/2010)
Grant Fritchey (12/2/2010)
Writing to file is much, much faster than writing to a database, so yes, it does make a difference. Also, is that database on the same 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

December 2, 2010 at 7:49 am

#1257898
RE: Set Up And Schedule a Server Side Trace

PAH-440118 (12/2/2010)
What is the command to delete to the trace definition?
Right here in the Books Online:
1.Execute sp_trace_setstatus by specifying @status = 0 to stop the trace.
2.Execute sp_trace_setstatus by specifying @status...
"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

December 2, 2010 at 7:15 am

#1257865
RE: Set Up And Schedule a Server Side Trace

Jack Corbett (12/2/2010)
Great article again Grant. I just prefer to use sys.traces over fn_trace_getinfo. I think it gives an easier to decipher set of information.
Hmm, I'm going 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

December 2, 2010 at 7:08 am

#1257858
RE: Set Up And Schedule a Server Side Trace

CavyPrincess (12/2/2010)
Thanks for the great article. I create a baseline performance measure every so often on my servers, and this will simplify the process. I'm currently placing 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

December 2, 2010 at 7:07 am

#1257855
RE: Export with Headers

For the non-SSIS version, what language are you using? Because if it's not PowerShell, I might want to do one using PowerShell.
"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

December 2, 2010 at 6:27 am

#1257826
RE: Set Up And Schedule a Server Side Trace

jason.spangler (12/2/2010)
Great article. I have been using this technique for a few months now and it saves tons of resources on the server, plus helps with my sleep when...
"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

December 2, 2010 at 6:09 am

#1257821
RE: Set Up And Schedule a Server Side Trace

PAH-440118 (12/2/2010)
Thanks for this article. it was just what I needed and a feature I did not know about. I have been experimenting and it looks great however I 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

December 2, 2010 at 6:08 am

#1257819
RE: How do I know when to use temp tables/table variables?

The one place where I consider using table variables is when I'm having issues with excessive, or long running, recompiles on a query. In that instance, I might choose 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

December 1, 2010 at 6:10 pm

#1257692
RE: Are the posted questions getting worse?

GilaMonster (12/1/2010)
You know there's a problem when...
In the last 2 weeks there have been three resignations at current client:
The senior developer (leaving only 2 permanent developers)
The Chief Enterprise...
"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

December 1, 2010 at 6:48 am

#1257311
RE: optimizer "LIKE" vs "="

joerg.kannengiesser (12/1/2010)
It seems, that MS changed something in the optimization,
maybe it's a bug in 2005R1 - I will check this again after installation of SP3.
Does anyone know if there's 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

December 1, 2010 at 6:24 am

#1257294
RE: TIMESTAMP

The thing to remember is, despite it's unfortunate name, TIMESTAMP has nothing whatsoever to do with time. It's simply an incrementing number that is automatically updated each time a row...
"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

December 1, 2010 at 5:44 am

#1257266
RE: self join

I'm sorry, I don't understand the order that you're trying to achieve. It doesn't look like you're ordering by managerid or by employee id. Are you trying to retrieve 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

December 1, 2010 at 5:42 am

#1257265
RE: How to know which join will be used first & so on?

For what it's worth, foreign keys, constraints, statistics, and indexes can all affect the execution plan, so simply pointing at a query and asking which table is accessed first can't...
"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

December 1, 2010 at 5:32 am

#1257258

Viewing 15 posts - 13,861 through 13,875 (of 22,232 total)