Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,776 through 20,790 (of 59,098 total)

RE: Urgent SQL Developer vs Enterprise edition 2012/2014

Eric M Russell (5/13/2015)
In addition to the above, unserstand that multiple users may connect to Developer Edition, but licensing requires that each user must have a developer edition license, which...
--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)

May 13, 2015 at 7:28 am

#1797529
RE: Space needed for clustered index rebuild

Just to summarize the steps using partitioned tables that I imagine we'd do on your system, Ken, is...
1. Setup a database on the "extra storage".
2. Create the partitioned table 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)

May 13, 2015 at 7:20 am

#1797522
RE: Space needed for clustered index rebuild

Please see the attached zip file for what can be done. The Power Point presentation is well worth watching in the presentation mode, especially when you get to 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)

May 12, 2015 at 10:48 pm

#1797436
RE: Refreshing the data warehouse without hurting anybody

Heh... thanks for the feedback, Bertrand.
Now, if you haven't seen the following, make sure that you don't have your mouth full of your favorite beverage and imagine the negotiations between...
--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)

May 12, 2015 at 8:51 pm

#1797432
RE: Refreshing the data warehouse without hurting anybody

GPO (5/12/2015)
Our management decided for reasons best known to themselves, to outsource our data warehouse development. It became apparent that while the company we chose had probably built some simple...
--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)

May 12, 2015 at 7:17 pm

#1797428
RE: Month name and year in sql

There is a way to seemingly sort formatted month and year combinations. Please see the following article and apply your favorite format.
http://www.sqlservercentral.com/articles/T-SQL/71511/
I second what the others have stated, 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)

May 12, 2015 at 6:36 pm

#1797425
RE: The Service Pack Fiasco

David.Poole (5/12/2015)
I'd love to hear what Microsoft do with testing SQL Server. Do they use TDD/BDD, manual methods and are they designing SQL Server code to be testable?
What are...
--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)

May 12, 2015 at 6:10 pm

#1797421
RE: Not Only a Meeting of Minds, but of Open Minds.

Gary Varga (5/12/2015)
...and then go to the pub 🙂
Heh... that's the ultimate in "open minds" for me because just about ANY pub will do! 😛
--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)

May 12, 2015 at 6:09 pm

#1797420
RE: Update takes too long

I love it. A newbie to the forum with just 7 points and already posting million row test tables.
Welcome aboard, Jason!
--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)

May 12, 2015 at 3:19 pm

#1797393
RE: Not Only a Meeting of Minds, but of Open Minds.

xsevensinzx (5/12/2015)
Jeff Moden (5/12/2015)
Just so that no one thinks I'm a Luddite, I absolutely believe in new and better technology. For example, ROW_NUMBER and the other ranking functions are...
--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)

May 12, 2015 at 2:52 pm

#1797390
RE: Find the position of all occurrences of an expression within a string

j-1064772 (5/12/2015)
The second version has also taught me a lot.
I have been trying to complete the function so that it would return as separate "words" the characters between each delimiter...
--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)

May 12, 2015 at 11:13 am

#1797347
RE: Space needed for clustered index rebuild

Ken Davis (5/12/2015)
Jeff,
We can assume I will have more space on separate LUNs. FYI a few months ago I estimated the need for 2.5TB of space to keep us...
--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)

May 12, 2015 at 11:08 am

#1797341
RE: Not Only a Meeting of Minds, but of Open Minds.

Just so that no one thinks I'm a Luddite, I absolutely believe in new and better technology. For example, ROW_NUMBER and the other ranking functions are one of 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)

May 12, 2015 at 8:05 am

#1797280
RE: Not Only a Meeting of Minds, but of Open Minds.

Gary Varga (5/12/2015)
Don't worry Jeff. I didn't take it personally. BTW who is this Maj Orrant??? 😛
Heh... he's the voice in my head that I normally talk to so that...
--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)

May 12, 2015 at 7:51 am

#1797273
RE: where is sql server TVF return type stored in system tables

Bill Talada (5/12/2015)
Thanks everyone, the sys.columns does hold the TVF returned columns; not sure how I missed that except I was also working with TVPs at the same time which...
--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)

May 12, 2015 at 7:47 am

#1797270

Viewing 15 posts - 20,776 through 20,790 (of 59,098 total)