Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,491 through 14,505 (of 59,101 total)

RE: PLE

Arsh - Wednesday, August 30, 2017 8:11 AM
Jeff Moden - Tuesday, August 29, 2017 8:24 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)

August 30, 2017 at 4:54 pm

#1957568
RE: Script out permissions - Azure SQL database

SQL!$@w$0ME - Wednesday, August 30, 2017 12:00 PM
SQL!$@w$0ME - Thursday, January 26, 2017 11:20 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)

August 30, 2017 at 4:01 pm

#1957563
RE: Calendar Table Function

michael-l-johnson - Tuesday, August 29, 2017 10:09 PM
I have not received a reply.
Then I'd use ScottPletcher's technique to build a real Calendar...
--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 30, 2017 at 8:46 am

#1957456
RE: Are the posted questions getting worse?

Sean Lange - Wednesday, August 30, 2017 7:40 AM
The quote from the top decision maker is "we will never be fully...
--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 30, 2017 at 8:12 am

#1957441
RE: Right Size for LDF physical disk

I could certainly be wrong but from what I'm seeing, you don't actually have a problem with your log file drive. There's no % growth (it's set to grow by...
--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 30, 2017 at 8:01 am

#1957439
RE: Calendar Table Function

michael-l-johnson - Tuesday, August 2, 2016 7:28 AM
How would you use this approach to get the next Business Day (Excluding Holidays)? 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)

August 29, 2017 at 9:49 pm

#1957349
RE: Columns to rows and rows to column conversion without pivot/unpivot

anand08sharma - Monday, August 28, 2017 11:55 AM
arihantjain121189 - Saturday, August 26, 2017 10:19 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)

August 29, 2017 at 9:21 pm

#1957348
RE: do you have a StripNonNumeric ITVF function?

Ah... scratch my previous... Even though it will likely never be needed, I add ORDER BY to physical Tally table implementations because, as Paul White said over on SE, the 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)

August 29, 2017 at 5:36 pm

#1957340
RE: Are the posted questions getting worse?

GilaMonster - Tuesday, August 29, 2017 2:46 PM
Someone remind me why I do this again...
It's good for the skin. 😉 Makes it...
--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 29, 2017 at 4:52 pm

#1957337
RE: Calculating averages

jcelko212 32090 - Monday, August 28, 2017 7:23 PM
SQLPain - Monday, August 28, 2017 5:27 PM
--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 29, 2017 at 3:36 pm

#1957331
RE: running stored procedure in a loop to get Top level Demand(s) form a Supply

skb 44459 - Tuesday, August 29, 2017 11:12 AM
I don't know the DB detail. The Stored procedure gives the list of demand...
--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 29, 2017 at 3:31 pm

#1957329
RE: Right Size for LDF physical disk

luismarinaray - Tuesday, August 29, 2017 11:57 AM
Hey,
Just checked again, 147 Gigas :crying:
Largest heap table 1 Gigabyte
:doze:
Thanks for your suggestions
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)

August 29, 2017 at 3:21 pm

#1957328
RE: do you have a StripNonNumeric ITVF function?

Eirikur Eiriksson - Tuesday, August 29, 2017 12:59 PM
Paul White - Tuesday, August 29, 2017 11:06 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)

August 29, 2017 at 2:56 pm

#1957324
RE: Right Size for LDF physical disk

luismarinaray - Tuesday, August 29, 2017 9:41 AM
Jeff,
Yes, a primary, unique, clustered index of 146 Mb
Thanks
You sure that's not GB instead of...
--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 29, 2017 at 10:20 am

#1957269
RE: Right Size for LDF physical disk

luismarinaray - Monday, August 28, 2017 12:11 PM
Hi,
Yes, dear friend, 500 Gb LDF file and 500 Gb physical drive.
Thanks again
Ugh! Just 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 29, 2017 at 8:47 am

#1957252

Viewing 15 posts - 14,491 through 14,505 (of 59,101 total)