Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,851 through 8,865 (of 59,102 total)

Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Bugs are being fixed and things repaired. This is the first I've seen/heard of this. It's been filed.
Thanks, Steve.
--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 13, 2019 at 10:06 pm

#3671183
Reply To: Performance Improvement Tips

Wow. I guess I'd not worry about anything else until those backup issues were fixed.
Thanks for the list. Always interesting to what what sp_Blitz ferrets out.
--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 13, 2019 at 9:59 pm

#3671182
Reply To: Performance Improvement Tips

Reporting servers are just moving the problem. People will complain on the reporting servers unless you fix the primary performance issue... which almost always boils down to (borrowing some emphasis...
--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 13, 2019 at 8:31 pm

#3671161
Reply To: Create a Tally Function (fnTally)

Thanks fr posting your code, Aaron. Good to see someone else using the "Union All" trick to get the zero value (it's also what I use) but I still have...
--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 13, 2019 at 8:27 pm

#3671158
Reply To: Create a Tally Function (fnTally)

Jason A. Long wrote:
Jeff Moden wrote:
For anyone interested in MS building such a function into T-SQL, please see the following thread. It used to have 278 votes until MS moved the "Connect" system...
--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 13, 2019 at 8:18 pm

#3671156
Reply To: Are the posted questions getting worse?

Heh... more "new site" sucking sounds. The fnTally script that was recently published and nearly 4,000 reads and 9 votes yesterday. Today, it says it's only had a little over...
--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 13, 2019 at 4:27 pm

#3671094
Reply To: Create a Tally Function (fnTally)

Heh... having this posted as a script has already started to pay off for me not only in a couple of posts on this forum but also on the "Azure...
--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 13, 2019 at 4:21 pm

#3671093
Reply To: Basics to loading data

David Burrows wrote:
Jeff Moden wrote:
Phil Parkin wrote:
below86 wrote:
IMHO, you are on the right path. I'm currently doing exactly what you described. Importing flat, delimited files to a 'staging' table where all fields 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)

August 13, 2019 at 2:39 pm

#3671047
Reply To: Moving a Table

tsalha wrote:
it is especially useful, if you need a table to be online all the time, but want to load lots of data to it (e.g. full reload). Then you...
--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 13, 2019 at 2:36 pm

#3671046
Reply To: Modern Datatime Addition

Post deleted... misread a response.
--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 13, 2019 at 2:25 pm

#3671034
Reply To: Backup size is doubled now. Want to know the reason why ??

prettsons wrote:
You can also try an appropriate option to control database size.
So long as it's not "AutoShrink", DBCC SHRINKDB, or DBCC SHRINKFILE (especially since they don't affect backup size).
--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 13, 2019 at 2:20 pm

#3671032
Reply To: Questions on Degree programs

p.s. The essential key for me was learning how to make a shedload of test data in virtually any form I needed it. When it come to performance, you 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)

August 13, 2019 at 2:15 pm

#3671031
Reply To: Questions on Degree programs

Totally agree with Grant. I don't care for the certification alphabet soup a lot of people have after their names because too many of them have gamed the system 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 13, 2019 at 2:03 pm

#3671024
Reply To: Give Up on Natural Primary Keys

That's all good but you made it sound like you were suggesting that keys (in general) were allowed to be mutable. There are some rare cases where AKs (Alternate Keys)...
--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 13, 2019 at 6:47 am

#3670927
Reply To: Get an Output from a Stored Procedure

Ok... my previous post with the code and some example code on how to use it are done. Read the comments in the demo code near the end.

--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 13, 2019 at 6:26 am

#3670925

Viewing 15 posts - 8,851 through 8,865 (of 59,102 total)