Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,216 through 10,230 (of 59,093 total)

RE: SQL Query to Calculate Monthly Budget

First things first. We need to generate date sequences. There are a whole lot of methods to do that but it's pretty simple when you use the "Swiss Army Knife"...
--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 27, 2018 at 10:17 pm

#2017480
RE: SQL Query to Calculate Monthly Budget

madanvenkat535 3293 - Thursday, December 27, 2018 7:26 PM
Jeff Moden - Thursday, December 27, 2018 3:39 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)

December 27, 2018 at 8:13 pm

#2017479
RE: Primary keys for an OLTP database

sqlvogel - Thursday, December 27, 2018 11:44 AM
Business needs and human factors ought to take priority when designing keys for a 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)

December 27, 2018 at 5:42 pm

#2017477
RE: trigger blues no primary key

fizzleme - Thursday, December 27, 2018 11:12 AM
The tables are small so the cursor is acceptable.
No, it's actually not. 😉 I hope...
--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 27, 2018 at 5:34 pm

#2017476
RE: Primary keys for an OLTP database

Ron Hinds - Thursday, December 27, 2018 11:53 AM
Theoretically, these clustered indexes usually have a hotspot on left or right side...
--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 27, 2018 at 5:22 pm

#2017474
RE: Porting SQLServerCentral

Awesome. I cannot speak for others but the ability to simply copy and paste code from SSMS without something wonky going on with the format would be key to me. ...
--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 27, 2018 at 5:00 pm

#2017473
RE: Suggestions on How to Improve Delete

RGP - Thursday, December 27, 2018 4:33 PM
Thanks for the quick response, Iâ€™ll post the code soon
Also post how many "records" there...
--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 27, 2018 at 4:50 pm

#2017472
RE: SQL Query to Calculate Monthly Budget

madanvenkat535 3293 - Thursday, December 27, 2018 12:56 PM
Mike01 - Thursday, December 27, 2018 12:03 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)

December 27, 2018 at 3:39 pm

#2017465
RE: Parent/Child - where I am standing

Lynn Pettis - Thursday, December 27, 2018 2:46 PM
You and your ISO Standards. I am still waiting for you to provide...
--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 27, 2018 at 3:26 pm

#2017464
RE: Convert string MMDDYYYY to a date

below86 - Thursday, December 27, 2018 8:28 AM
Jeff Moden - Friday, December 21, 2018 2:06 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)

December 27, 2018 at 2:25 pm

#2017460
RE: Primary keys for an OLTP database

Carlo Romagnano - Thursday, December 27, 2018 9:28 AM
You may have differerent results if you insert rows in separated batch and...
--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 27, 2018 at 9:38 am

#2017429
RE: Primary keys for an OLTP database

RonKyle - Thursday, December 27, 2018 9:18 AM
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)

December 27, 2018 at 9:31 am

#2017427
RE: Primary keys for an OLTP database

Evgeny Garaev - Wednesday, December 26, 2018 11:46 PM
Comments posted to this topic are about the item Primary keys 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 27, 2018 at 9:18 am

#2017424
RE: Primary keys for an OLTP database

Thom A - Thursday, December 27, 2018 3:05 AM
Thanks Evgeny. I didn't actually know there was a NEWSEQUENTIALID() function. I...
--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 27, 2018 at 9:05 am

#2017417
RE: Primary keys for an OLTP database

RonKyle - Thursday, December 27, 2018 8:04 AM
With...
--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 27, 2018 at 9:01 am

#2017414

Viewing 15 posts - 10,216 through 10,230 (of 59,093 total)