Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,361 through 54,375 (of 59,098 total)

RE: Tuning

James Stover (11/4/2007)
Arrogant DBA's, eh?
"What's that you say Mr. Web Developer? Just "put it in"? Sure, I'll stay up to 3am troubleshooting & optimizing your masterpiece while you are...
--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)

November 5, 2007 at 6:40 am

#748209
RE: Degree

what is good to "beef up" a resume
Ummmm... How about a couple thousand posts on a high quality forum like SQLSeverCentral.com ???
Or, how about a list of major...
--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)

November 4, 2007 at 8:53 pm

#748098
RE: Tuning

Wow... thanks for the kudo, Steve. Thanks.
I read that blog article... Michael J. Hillenbrand is pretty much spot on except maybe for the order of the first two things......
--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)

November 4, 2007 at 5:58 pm

#748080
RE: Bulk Insert into SQL Server table of file created by TransferText method inserting only one row

Sorry, I didn't check my post and I submitted it... I had included backslash n and apparently, it didn't take on this forum....
Have you tried backslash n ??
(and, now 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)

November 4, 2007 at 5:01 pm

#748077
RE: Formatted export in Ecel

Jason Coleman (11/3/2007)
LOL - toooooo many late nights reading forums... 😉
Still, I read in BOL that you have little control over the page format when rendering to Excel. Bummer.
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)

November 4, 2007 at 7:55 am

#748048
RE: Join Help

*= is severely deprecated and may produce unexpected results. Don't use it.
--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)

November 3, 2007 at 10:03 pm

#748034
RE: Cast to VarChar Without Knowing the Length

Have you tried using SELECT/INTO using QUOTENAME for each column?
--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)

November 2, 2007 at 11:28 pm

#747978
RE: Query/UDF help

Heh... now THAT's entertainment 😀 Would have loved to see their faces...:w00t:
--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)

November 2, 2007 at 10:18 pm

#747973
RE: T-SQL

So post what you've tried so we can coach 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)

November 2, 2007 at 10:11 pm

#747971
RE: Query/UDF help

Ugh! A "Sequence" table... I hate 'em... If you don't already hate 'em, you will.;)
Ok, David... let's pretend that the following is what your 3rd party sequence table looks...
--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)

November 2, 2007 at 9:59 pm

#747970
RE: Transpose Rows to Columns

You don't appear to have anything to relate the given values to logical rows... have you posted all the columns that appear in these tables?
--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)

November 2, 2007 at 8:45 pm

#747967
RE: Error in BULK insert query

The system has to be able to see the file to load it... make sure SQL Server Services use a startup account that can see the path to the file.
--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)

November 2, 2007 at 8:39 pm

#747965
RE: update charecter value to a column int

Heh... did you convert the correct column? Only way you can get that error is if the target column is actually an INT... double check the schema and make...
--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)

November 2, 2007 at 8:24 pm

#747963
RE: SQL Server 2005 v MySQL

I think you would be unhappy... unless there's a pot wad of extra money involved... in which case, you'll still be unhappy but more satisfied 😉
--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)

November 2, 2007 at 8:22 pm

#747962
RE: Alter varbinary(8000) column to varbinary(max)

What are you using to determine the size of the table?
--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)

November 2, 2007 at 8:19 pm

#747961

Viewing 15 posts - 54,361 through 54,375 (of 59,098 total)