Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,006 through 13,020 (of 59,095 total)

RE: Calendar table

Darko Martinovic - Friday, February 2, 2018 12:51 AM
Jeff Moden - Thursday, February 1, 2018 1:12 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)

February 2, 2018 at 6:39 am

#1978336
RE: Huge Latency in TempDB

kevaburg - Friday, February 2, 2018 5:06 AM
Have you looked at your wait stats? Although you haven't provided any detail I can guess...
--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)

February 2, 2018 at 6:36 am

#1978335
RE: $LASTDAYOFMONTH

Sergiy - Thursday, February 1, 2018 7:52 PM
If DeliveryDt contains (will possibly ever contain) a time portion (the data type DATETIME would...
--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)

February 1, 2018 at 9:29 pm

#1978294
RE: Sort comma separated value in SQL Table

The question now is, especially since you posted in a 2016 forum, are you actually using SQL Server 2016?
--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)

February 1, 2018 at 5:00 pm

#1978284
RE: Need counts of orders per week grouped by week

meichmann - Thursday, February 1, 2018 9:14 AM
ScottPletcher - Thursday, February 1, 2018 7: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)

February 1, 2018 at 4:53 pm

#1978282
RE: Calendar table

Darko Martinovic - Wednesday, January 31, 2018 11:10 PM
Jeff Moden - Wednesday, January 31, 2018 7:35 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)

February 1, 2018 at 1:12 pm

#1978262
RE: Today's Random Word!

TomThomson - Wednesday, January 31, 2018 7:10 PM
Ray K - Wednesday, January 31, 2018 2:11 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)

January 31, 2018 at 7:50 pm

#1978122
RE: Calendar table

Darko Martinovic - Wednesday, January 31, 2018 5:19 PM
Jeff Moden - Wednesday, January 31, 2018 4:11 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)

January 31, 2018 at 7:35 pm

#1978121
RE: Calendar table

Darko Martinovic - Wednesday, January 31, 2018 2:25 PM
Jeff Moden - Wednesday, January 31, 2018 1:35 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)

January 31, 2018 at 4:11 pm

#1978113
RE: Lowering the Noise

One of the best ways that I've found to lower the noise is the one that many shops avoid for some reason and that is to identify the code that's...
--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)

January 31, 2018 at 1:40 pm

#1978098
RE: Calendar table

Darko Martinovic - Wednesday, January 31, 2018 1:27 PM
I was wondering why people are not so enthusiastic with my...
--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)

January 31, 2018 at 1:35 pm

#1978096
RE: Calendar table

drew.allen - Tuesday, January 30, 2018 11:37 AM
K. Brian Kelley - Tuesday, January 30, 2018 11:21 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)

January 31, 2018 at 8:14 am

#1978033
RE: Lowering the Noise

jmlakar 69347 - Tuesday, January 30, 2018 8:45 AM
What I would give to see all client environments have just disk monitoring 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)

January 31, 2018 at 8:09 am

#1978031
RE: Today's Random Word!

Revenant - Tuesday, January 30, 2018 5:39 PM
ManicStar - Tuesday, January 30, 2018 9:17 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)

January 30, 2018 at 8:08 pm

#1977988
RE: How to copy a database with one big mdf file to another server with smaller multiple drives.

Apparently, the OP has left the building.
--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)

January 30, 2018 at 3:55 pm

#1977973

Viewing 15 posts - 13,006 through 13,020 (of 59,095 total)