Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,651 through 31,665 (of 59,099 total)

RE: Pivot Table Headache

Alright, Bill... here we go!
First, we need a little bit more data than what you provided so we can see this work. A million rows spread out from 2000-01-01...
--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)

December 16, 2011 at 10:00 pm

#1422785
RE: PowerShell, xp_cmdshell, and T-SQL

SQLKnowItAll (12/15/2011)
You always have a logical way of putting things frankly, Jeff. I guess I was trying to make an argument that did not need to be made. 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)

December 16, 2011 at 6:16 am

#1422441
RE: PowerShell, xp_cmdshell, and T-SQL

MysteryJimbo (12/16/2011)
Completely off the walll and not what I would do, but you could start SQL Agent job with powershell steps from a stored procedure.
I don't believe that's such an...
--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)

December 16, 2011 at 6:02 am

#1422428
RE: Pivot Table Headache

bill.sutcliffe (12/15/2011)
Jeff,
I've read part 1 and 2 of your articles and also the article on the Tally table. It looks like you hard code the months in your SUM...
--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)

December 15, 2011 at 8:24 pm

#1422288
RE: Pivot Table Headache

bill.sutcliffe (12/15/2011)
Jeff,
I've read part 1 and 2 of your articles and also the article on the Tally table. It looks like you hard code the months in your SUM...
--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)

December 15, 2011 at 8:22 pm

#1422287
RE: 8hr hour query ?!?!?!?!?!?!?!

Fraggle-805517 (12/15/2011)
An update on this. The MAXDOP statement worked the best. It took the entire process down from 8-15hours to under 5 minutes.
Thanks,
Nathan
Heh... call it what...
--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)

December 15, 2011 at 7:46 pm

#1422283
RE: Non-SysAdmins have been denied permission to run CmdExec job steps

SQLRNNR (12/15/2011)
Create a proxy and execute the job with the proxy account.
Basically, yes. You just need to do it in a way where the low-priv user doesn't even need...
--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)

December 15, 2011 at 7:36 pm

#1422280
RE: PowerShell, xp_cmdshell, and T-SQL

SQLKnowItAll (12/15/2011)
Does that not defeat the point?
Not in my book. 🙂 Think about why they added the CLR capability... it's to extend what you can do from 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)

December 15, 2011 at 7:29 pm

#1422279
RE: Dynamically adding columns

That's why I asked the question. The ROW_NUMBER() thing is necessary if the OP wants separate columns and isn't necessary if a space delimited, multi-element column is all that's...
--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)

December 15, 2011 at 7:19 pm

#1422278
RE: How to make column dymanic to recognise 1 character or 2 characters

Post withdrawn... didn't read the requirements quite right.
--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)

December 15, 2011 at 4:59 pm

#1422265
RE: Non-SysAdmins have been denied permission to run CmdExec job steps

There are ways to allow for the system to execute xp_CmdShell and for users to execute stored procedures that contain xp_CmdShell without the users being able to execute xp_CmdShell and...
--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)

December 15, 2011 at 4:56 pm

#1422264
RE: Find lower case field names

newbieuser (12/15/2011)
We are facing some issues on the application with the lower case fields in the database.. So we need to change them all to upper case..
I would...
--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)

December 15, 2011 at 4:53 pm

#1422262
RE: Monitoring date specific changes

Brandie Tarvin (12/15/2011)
Why would you put your CLUSTERED index on the ID field of the table?
To prevent page splits on a massive 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)

December 15, 2011 at 4:48 pm

#1422261
RE: PowerShell, xp_cmdshell, and T-SQL

SQLKnowItAll (12/15/2011)
One of the questions that my co-worker had was how we call or open a session of PowerShell in a stored proc. I believe the answer is "you don't."
BWAA-HAAA!!!!...
--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)

December 15, 2011 at 4:43 pm

#1422260
RE: Dynamically adding columns

Do you want separate columns or do you want a single column with items separated by spaces?
--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)

December 15, 2011 at 4:34 pm

#1422259

Viewing 15 posts - 31,651 through 31,665 (of 59,099 total)