Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,026 through 20,040 (of 59,098 total)

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
RE: Are the posted questions getting worse?

Alvin Ramard (8/1/2015)
Jeff Moden (7/31/2015)
Alvin Ramard (7/31/2015)
I guess I've had enough of this forum for this week.
http://www.sqlservercentral.com/Forums/Topic1707595-2799-1.aspx
You did fine and you're absolutely spot on. You've said what we're...
--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:34 am

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

sushantkatte (8/1/2015)
Thank You very much @SScrazy for providing the solution. i am very new to the sql server programming and have started learning recently. could you please help me understand...
--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:23 am

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

LinksUp (8/1/2015)
If the ordering is indeed the alter_msg, then I would create another table to define the sorting method. Hard coding each possibility could quickly become a nightmare! :w00t:
Here 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 10:19 am

#1816676
RE: SQL login name practices - development vs production

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 I have 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:08 am

#1816672

Viewing 15 posts - 20,026 through 20,040 (of 59,098 total)