Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,821 through 35,835 (of 59,102 total)

RE: Set Up And Schedule a Server Side Trace

Good stuff as always, Grant! Thanks for taking the time to write articles like this. This one should be in every DBA's quick reference guide. 🙂
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 2, 2010 at 10:43 pm

#1258213
RE: temp table usage

Ninja's_RGR'us (12/1/2010)
pspeagle (12/1/2010)
I have read that using the SELECT column list INTO #tablename syntax to create temp tables holds locks in tempdb (create object locks) for the entire duration of...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 2, 2010 at 10:22 pm

#1258205
RE: Export with Headers

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, SQLCMD", but...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 2, 2010 at 10:16 pm

#1258202
RE: Default trace - A Beginner's Guide

Thanks for the tip, Jack.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 2, 2010 at 10:11 pm

#1258201
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Nicole Bowman (12/2/2010)
Thanks Jeff! That is really helpful!
Cheers,
Thanks for the feedback and for stopping by, Nicole. 🙂
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 2, 2010 at 10:08 pm

#1258200
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

James Stephens (12/2/2010)
crashdan (12/1/2010)
please also consider 0E0 and numbers like them.
Wasn't that covered in the Old_MacDonald() Function? Or was that the Flying_Monkeys() I'm thinking of?
Sorry...couldn't help it. 🙂
Heh... too...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 2, 2010 at 10:07 pm

#1258199
RE: Default trace - A Beginner's Guide

peter-970097 (9/21/2010)
Helpful article Adam - thank you.
How can I use this to trace Queries and Sp activity?
Peter
Melbourne, Australia
I don't believe you can. The default trace wasn't setup to detect...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 2, 2010 at 1:00 pm

#1258081
RE: Default trace - A Beginner's Guide

I recently had cause to revisit this fine article... well done, Adam. Great for neophytes and alumni alike.
As a side bar, here's the code I ended up using which...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 2, 2010 at 12:52 pm

#1258073
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Steve Jones - SSC Editor (12/1/2010)
Excellent article. Thanks for this bit of SQL Spackle.
Thanks Steve but the real thanks goes to you. You had a wonderful idea when you...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 2, 2010 at 7:41 am

#1257892
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

steven.malone (12/1/2010)
First off thanks, like others I had not stopped to think about "d" and "e" and I am a little surprised "x" was not included if they were. go...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 2, 2010 at 7:31 am

#1257882
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

crashdan (12/1/2010)
please also consider 0E0 and numbers like them.
Good point but that's actually and explicity covered in the article. 🙂
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 2, 2010 at 7:22 am

#1257872
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Holy moly... 61 posts. I've read them all and I'll try to summarize...
First, thank all of you again for the high quality level of discussion. This one has...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 2, 2010 at 7:14 am

#1257863
RE: Are the posted questions getting worse?

David Burrows (12/1/2010)
CirquedeSQLeil (11/30/2010)
For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].
Anyone know if there will be a recording available, 2.30AM is a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 1, 2010 at 7:37 pm

#1257704
RE: Are the posted questions getting worse?

CirquedeSQLeil (11/30/2010)
Jeff Moden (11/30/2010)
CirquedeSQLeil (11/30/2010)
For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].
Very cool... looking forward to that.
Put it on the calendar and...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 1, 2010 at 7:35 pm

#1257703
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Wow! Great discussions going on here, folks! I'm at work right now so can't respond in detail. I'll have to wait until tonight. In the meantime,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 1, 2010 at 10:47 am

#1257506

Viewing 15 posts - 35,821 through 35,835 (of 59,102 total)