Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,996 through 20,010 (of 59,072 total)

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
RE: Using rand() inside a function

Why MS made it so difficult to write functions with indeterminate results, I'll never know. You'll need to do the following hack...
First, create this view. The name 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)

August 3, 2015 at 7:38 am

#1816805
RE: How To Keep Up with SQL Server

Eric M Russell (8/3/2015)
Jeff Moden (7/31/2015)
It used to be bad enough just to keep up with the new features and when to use them. Lately, a new wrinkle 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)

August 3, 2015 at 6:48 am

#1816784
RE: Are the posted questions getting worse?

Cadavre (8/3/2015)
Jeff Moden (8/2/2015)
What a total waste of time for the interviewers. Pork chops are not enough for these people whether they believe themselves to be innocent or not.
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)

August 3, 2015 at 6:41 am

#1816778
RE: How Do I Select Data From Table With A Particular Priority

sushantkatte (8/2/2015)
I was not able to understand how the Case statement is working,particularly the THEN part (THEN 1,THEN 2,THEN 2)
CASE WHEN alert_msg ='Meter' THEN 1
...
--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:36 am

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

The one on automating Excel Hell isn't too bad, either. 🙂
--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:17 am

#1816767
RE: SSIS-data insert from Temp table to real sql table

metroman17 (7/31/2015)
I cannot create a Stored proc across 100's of servers.
I will be running this code across servers from the SSIS package.
Are all those servers on the same domain?
As 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)

August 2, 2015 at 12:04 pm

#1816689
RE: SSIS Package development functionality

The 3rd point sounds like they want to keep the original source files forever.
--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 2, 2015 at 11:59 am

#1816688
RE: Restore using the GUI

Welsh Corgi (8/1/2015)
I read in Brad McGehee’s Backup and recovery book that when you perform a restore you only need to provide the Full, Differential and the last transaction log...
--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 2, 2015 at 11:49 am

#1816686
RE: Need help in Pivot Table with Column Names to Rows.

Rahuul (8/2/2015)
Thanks a lot Jason.
Saved my day!!
On another note, could it be done using Pivot?
Thanks again.
Rahuul
Using PIVOT for this can make things slower but, for more information, please see...
--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 2, 2015 at 11:45 am

#1816684
RE: Code to Archive Data

I'd be really careful when considering partitioning (either partitioned tables or views) just for purposes of archiving. There are a whole lot of caveats (for example, partitioned column is...
--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 2, 2015 at 11:38 am

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

Michael L John (8/1/2015)
Jeff Moden (8/17/2011)
Jayanth_Kurup (8/17/2011)
Probably not in production. While there are secure ways of using xp_cmdshell. I can't/won't trust everybody to use it the way its meant to...
--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 2, 2015 at 10:51 am

#1816680

Viewing 15 posts - 19,996 through 20,010 (of 59,072 total)