Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,471 through 10,485 (of 59,102 total)

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
RE: Sql injection

andycadley - Sunday, December 2, 2018 9:48 AM
Using parameterised queries can avoid pretty much every possible case of this (except maybe second-order...
--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 2, 2018 at 10:30 am

#2015240
RE: Replace trigger with some other approach?

I don't recall looking at this one. I can tell you that I don't have the time to look at every post.
If I had looked at it, keep...
--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 2, 2018 at 9:47 am

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

Eirikur Eiriksson - Saturday, December 1, 2018 12:34 PM
Jeff Moden - Friday, November 30, 2018 8:15 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 1, 2018 at 3:08 pm

#2015219
RE: Need index suggestion

Heh... ok. I'm confused. Here's the original query posted by the OP.
SELECT SalesDate, SalesPersonID FROM dbo.Sales WHERE ProductID='PD1’ Order by productname;
Can someone please...
--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)

November 30, 2018 at 8:59 pm

#2015194
RE: Issues with filling in the blanks from a calendar table.

I might simply be missing it but do you have an example of what you actually want to save to a table using the given data?
--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)

November 30, 2018 at 6:49 pm

#2015191
RE: Sql injection

Matt Miller (4) - Friday, November 30, 2018 5:21 PM
Matt Miller (4) - Friday, November 30, 2018...
--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)

November 30, 2018 at 6:41 pm

#2015190
RE: Sql injection

autoexcrement - Friday, November 30, 2018 2:37 PM
I'd love to see an example too. But it seems the issue is somewhat complicated...
--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)

November 30, 2018 at 5:46 pm

#2015188
RE: Database Performance slowness issue

santosh.mane - Friday, November 30, 2018 7:05 AM
muthukkumaran Kaliyamoorthy - Friday, November 30, 2018 4:58 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)

November 30, 2018 at 4:57 pm

#2015184

Viewing 15 posts - 10,471 through 10,485 (of 59,102 total)