Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,726 through 1,740 (of 59,099 total)

Reply To: Master Data - Hierarchies Creation, Change and Maintenance

Thanks, Jason. I have to tell you, you've made my month. I had no idea about that and I sometimes wonder to myself whether or not I accomplished my goal...
--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)

March 16, 2023 at 10:17 pm

#4161679
Reply To: Index rebuild / stats update taking lot of disk space.

Here's the "formula" I've been using in production
FF
100 - Static or usually static.
99 - Usually, some form of ever-increasing keyed index that suffers no fragmentation, which also means no "ExpAnsive"...
--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)

March 16, 2023 at 9:39 pm

#4161677
Reply To: Index rebuild / stats update taking lot of disk space.

Ya gotta be careful, though. If you do the index maintenance incorrectly, you could be setting up the index to do massive page splits which will cost you dearly 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)

March 16, 2023 at 8:31 pm

#4161638
Reply To: Partial Matching the Columns

If you want really good help, then see the article at the first link in my signature line below for one of many ways to provide example data in 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)

March 16, 2023 at 4:15 pm

#4161541
Reply To: Is it possible to SUM on two different ranges in one SELECT query?

Then pray that your data has no times in it because of the use of 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)

March 16, 2023 at 4:13 pm

#4161540
Reply To: Database Design workaround with Views or Synonyms

The biggest downside would be that your "temporary solution" will become permanent. You may also be in serious violation of the 3rd party license agreement if you take this kind...
--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)

March 16, 2023 at 4:12 pm

#4161539
Reply To: Index rebuild / stats update taking lot of disk space.

Arsh wrote:
Dear Friends,
Please advise why the Index rebuild and Update stats jobs on one server consume lots of disk space after they run..I have to manually shrink the data file...
--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)

March 16, 2023 at 2:24 pm

#4161506
Reply To: Master Data - Hierarchies Creation, Change and Maintenance

Thank you both for the feedback and the very kind words.
--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)

March 16, 2023 at 5:48 am

#4161324
Reply To: Hexa 2 decimal 20 digits

Jonathan AC Roberts wrote:
Convert does just truncate the answer if it is too long with no error.
Heh... unfortunately, I know that problem all too well because some folks at...
--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)

March 16, 2023 at 5:44 am

#4161323
Reply To: Hexa 2 decimal 20 digits
SwePeso wrote:
Keep it simple
```
DECLARE @sample 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)
March 15, 2023 at 9:59 pm

#4161235
Reply To: Average runtime beyond 24 hr

Without having to look much at the code you posted, what is the unit value of the h.run_time column?

--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)

March 15, 2023 at 9:57 pm

#4161234
Reply To: Decoding Set Options

They do it in a lot of languages... I hate it when people number the bits differently than the exponent of "2". 😀
--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)

March 15, 2023 at 9:52 pm

#4161233
Reply To: Use a flag, or calculate, to retrieve counts

edwardwill wrote:
Jeff Moden wrote:
Steve Collins wrote:
Imo it depends on whether or not Approved is exactly equivalent to Taken. Could a user be officially approved and yet not take the day? If there'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)

March 15, 2023 at 9:44 pm

#4161232
Reply To: Hexa 2 decimal 20 digits
Serious "chicken dinner" there for performance, Jonathan... here are the stats from a test on a million rows of 16 hex digits (8 bytes)...
```
 SQL Server Execution...
```
--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)
March 15, 2023 at 9:12 pm

#4161222
Reply To: Hexa 2 decimal 20 digits

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Jonathan AC Roberts wrote:
That's because bigint stores integers as Two's complement, negative numbers need 2^64 (18446744073709551616) added to them to represent the number as an unsigned int.
--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)

March 15, 2023 at 8:52 pm

#4161187

Viewing 15 posts - 1,726 through 1,740 (of 59,099 total)