Jeff Moden

Forum Replies Created

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

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
RE: PLE

GilaMonster - Sunday, August 27, 2017 2:06 PM
Arsh - Sunday, August 27, 2017 1:36 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 8:24 am

#1957247
RE: Right Size for LDF physical disk

luismarinaray - Saturday, August 26, 2017 5:49 PM
Jeff,
LDF file 507.965 Mb
Drive 507.974 Mb
free 9 mb
Thanks for your suggestions
If I'm reading that...
--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 28, 2017 at 9:27 am

#1957110
RE: Are the posted questions getting worse?

GilaMonster - Monday, August 28, 2017 7:37 AM
Jeff Moden - Monday, August 28, 2017 7:33 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 28, 2017 at 7:52 am

#1957085
RE: Lookup values similar to VLookUp in Excel

JJR333 - Monday, August 28, 2017 4:17 AM
Thank you Jeff, great!
Cheers,
Julian
(https://www.red-gate.com/simple-talk/sql/t-sql-programming/sql-server-apply-basics/)

DECLARE @IDHUIS VARCHAR(4)
DECLARE @IDAFD VARCHAR(4)
DECLARE @JAAR INT
DECLARE @WEEKBEGIN INT
DECLARE...
--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 28, 2017 at 7:40 am

#1957082

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