Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,011 through 20,025 (of 59,098 total)

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
RE: SQL login name practices - development vs production

webrunner (8/2/2015)
Jeff Moden (8/2/2015)
webrunner (8/1/2015)
I know the general best practice for SQL Server is to use Windows logins, but we're not there yet.
I know you already know this 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)

August 3, 2015 at 9:46 am

#1816869
RE: Code to Archive Data

Welsh Corgi (8/3/2015)
Jayanth_Kurup (8/2/2015)
seems fairly simple , i would personally use partitioning since it handles the whole process with far less stress on the DB but it would be just...
--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:40 am

#1816864
RE: Page Life Expectancy.

ben.brugman (8/3/2015)
Grant Fritchey (8/3/2015)
Don't get hung too much on PLE.
Thanks for you reply.
I do tend to get hung up to much by 'numbers' in general, and like to understand how...
--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 7:57 am

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

Grant Fritchey (8/1/2015)
Comments posted to this topic are about the item <A HREF="/articles/Editorial/129741/">But we've always done it that way…</A>
That's my favorite example on the subject.
The only difference in...
--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 7:46 am

#1816810

Viewing 15 posts - 20,011 through 20,025 (of 59,098 total)