Grant Fritchey

Forum Replies Created

Viewing 15 posts - 13,846 through 13,860 (of 22,219 total)

RE: Export with Headers

Jeff Moden (12/2/2010)
Grant Fritchey (12/2/2010)
For the non-SSIS version, what language are you using? Because if it's not PowerShell, I might want to do one using PowerShell.
Steve asked for "using bcp,...
"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 3, 2010 at 5:43 am

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

Jack Corbett (12/2/2010)
ALZDBA (12/2/2010)
I haven't noticed it would not cleanup the trace def in systraces after the end time.
Tested in SQL2000 / SQL2005 / SQL2008R2 CU4 .... ehm .... yes...
"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:31 pm

#1258177
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

Viewing 15 posts - 13,846 through 13,860 (of 22,219 total)