Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,981 through 19,995 (of 59,072 total)

RE: Sql Query

Might have to add the 3 different WHERE clauses to that... they are all different.
--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)

August 4, 2015 at 8:34 am

#1817138
RE: Code to Archive Data

Then you might want to consider the methods in the attached presentation. It's definitely worth going through the presentation in the "present" mode because it's somewhat animated to explain...
--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)

August 4, 2015 at 7:59 am

#1817116
RE: Problem with Importing flat files with embedded (CR)(LF) characters.

To add to what Phil stated, text qualifiers are usually conditional. That is, the system only considers them when they are present. They aren't treated as if they...
--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)

August 4, 2015 at 7:04 am

#1817091
RE: But we've always done it that way…

On the other side of the same coin...
I won't support change for the sake of change or for the sake of someone being a cool kid that just deployed the...
--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)

August 3, 2015 at 11:23 pm

#1816996
RE: But we've always done it that way…

So, why did the chicken cross the road? Because he's always done it that way. 🙂 Why won't he stop? Because he's never tried that before. 🙂
--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)

August 3, 2015 at 6:26 pm

#1816984
RE: Outputting Sproc result set to a new physical table

Not as convenient as a SELECT INTO, though.
--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)

August 3, 2015 at 5:53 pm

#1816982
RE: To SHRINK or not to...

... and don't forget to rebuild the indexes on EVERY table because even one-off shrinks are going to fragment the hell out of your database.
--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)

August 3, 2015 at 4:35 pm

#1816974
RE: Problem with Importing flat files with embedded (CR)(LF) characters.

kingdonshel (8/3/2015)
Thanks Phil for highlighting where I initially pointed out that the comments column is already in double quotes, I think the supplier of the flat file has already done...
--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)

August 3, 2015 at 4:33 pm

#1816973
RE: temporary tables (# tables) & tempdb

GonnaCatchIT (7/31/2015)
Hi Team,
I have a Database say DB1 which has collation "SQL_Latin1_General_CP1_CI_AS".
The tempdb in the sql server is set to collation "Latin1_General_CI_AS".
I have SP's which create temp tables say :#temp1...
--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)

August 3, 2015 at 4:32 pm

#1816972
RE: Temp Db issue

New persopn (8/3/2015)
I have a problem with TEMPDb. i have configured the tempdb with 30Gb space with initial size we have total 30+Gb disk space. now we have total 500MB...
--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)

August 3, 2015 at 4:26 pm

#1816971
RE: Using rand() inside a function

Matt Miller (#4) (8/3/2015)
Jeff Moden (8/3/2015)
a_ud (8/3/2015)
Thanks Jeff, perfect solution. Testing it now.
I also found this explanation, pretty much in the same line, that also seems easy enough:
http://blog.sqlauthority.com/2012/11/20/sql-server-using-rand-in-user-defined-functions-udf/
Thanks for the...
--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)

August 3, 2015 at 4:14 pm

#1816970
RE: Outputting Sproc result set to a new physical table

JaybeeSQL (8/3/2015)
Hi all,
I figure I need to output a sproc into a new physical table, so the column definitions match the output.
So far I think I'll need a
Select Into...
--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)

August 3, 2015 at 4:09 pm

#1816969
RE: Code to Archive Data

Welsh Corgi (8/3/2015)
There are 3 file groups and 6 files.
Not that it will matter much but for what? The database or that one 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)

August 3, 2015 at 10:08 am

#1816887
RE: If you could use xp_CmdShell securely, would you?

Thanks for the feedback folks. I'll start working on the article. Shouldn't be too difficult considering the Power Point "document" I already have on the subject.
Heh... ironically, I...
--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)

August 3, 2015 at 10:06 am

#1816885
RE: Using rand() inside a function

a_ud (8/3/2015)
Thanks Jeff, perfect solution. Testing it now.
I also found this explanation, pretty much in the same line, that also seems easy enough:
http://blog.sqlauthority.com/2012/11/20/sql-server-using-rand-in-user-defined-functions-udf/
Thanks for the feedback. The problem with...
--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)

August 3, 2015 at 9:56 am

#1816877

Viewing 15 posts - 19,981 through 19,995 (of 59,072 total)