Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,456 through 10,470 (of 59,095 total)

RE: Missing Indexes

Kendra.Little - Monday, December 3, 2018 7:58 AM
Jeff Moden - Monday, December 3, 2018 7:51 AM
--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 3, 2018 at 8:03 am

#2015318
RE: always on in cloud amazon

abdalah.mehdoini - Monday, December 3, 2018 7:44 AM
Hello everyone
I must migrate an always on instance to the AWS azure cloud
the configuration 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)

December 3, 2018 at 7:58 am

#2015317
RE: Missing Indexes

While I absolutely agree with what has been stated in the explanation, the question was (emphasis is mine)...
How many missing index requests are in the execution plan...
--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 3, 2018 at 7:51 am

#2015314
RE: Understanding a Database

roger.plowman - Monday, December 3, 2018 6:49 AM
Jeff Moden - Monday, December 3, 2018 6:27 AM
--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 3, 2018 at 7:37 am

#2015311
RE: Update Row for same ID

Hold the phone a minute... why do you have two tables that you must maintain the name in? That's not "normalization" and having to do such maintenance is contrary 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)

December 3, 2018 at 7:32 am

#2015310
RE: CONTAINS() function generates crash dump file

SALIM ALI - Monday, December 3, 2018 6:01 AM
Found the issue and fixed it.
It was a corrupt ResourceDB database. It's not one...
--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 3, 2018 at 7:28 am

#2015307
RE: Traverse hierarchy with a tally table

s.duvernay 71743 - Monday, December 3, 2018 6:27 AM
Hi Jeff,
I read both article but I' have probably miss something...
The point 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)

December 3, 2018 at 7:26 am

#2015301
RE: Understanding a Database

Just remember that "all relationships" are normally based on the presence of FKs. A whole lot of 3rd party vendors don't even know how to spell "FK". I've not worked...
--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 3, 2018 at 6:27 am

#2015294
RE: Traverse hierarchy with a tally table

Please see the following articles.
Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets
Hierarchies on Steroids #2: A Replacement for...
--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 3, 2018 at 6:19 am

#2015292
RE: adding each row incremental

I don't have access to a 2016 box just now but I believe this can be done using Lead or Lag. I believe that Books Online has an example.
--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 3, 2018 at 6:06 am

#2015290
RE: CONTAINS() function generates crash dump file

SALIM ALI - Monday, December 3, 2018 3:46 AM
Hi,
I'm seeing lots of crash dump files generated (SQL Server 2012) due to this...
--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 3, 2018 at 5:57 am

#2015288
RE: Fast Table Valued Function to return all prime numbers within a range

@jonathan-2,
Nice function. It seems like you've included just about every optimization for rejecting non-prime candidates there 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)

December 3, 2018 at 5:55 am

#2015287
RE: Freeing up space on mdf file.

Funny you should bring this up...
I'm working on (but have not yet completed) a method to determine which index/heap the last page of an MDF file maps 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)

December 3, 2018 at 5:53 am

#2015285
RE: Fast Table Valued Function to return all prime numbers within a range

Just a thought...
This reminds me of the Factorial function. The same values will always be returned. With that in mind, it would probably be the best to store...
--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 3, 2018 at 5:38 am

#2015283
RE: Request code review for UDF: ContainsControlChar and CleanString

Scott In Sydney - Sunday, December 2, 2018 4:17 PM
Hi All,
Thanks for the replies so far. TBH, I kind of expected "looks...
--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 3, 2018 at 5:28 am

#2015278

Viewing 15 posts - 10,456 through 10,470 (of 59,095 total)