Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,281 through 11,295 (of 59,099 total)

RE: Profiling spikes in query duration

Long shot but are the stats up to date for what the loop uses? Also, it is possible that you're suffering from a bit of bad parameter sniffing for certain...
--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)

September 6, 2018 at 9:26 am

#2004732
RE: Index on a computed column

Kind of a bad "correct" answer. The reason why it can't be used in an index is because it's indeterminate and whatever reason you chose, the end of it all...
--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)

September 6, 2018 at 9:22 am

#2004730
RE: Creating Subtotals and Totals in Aggregated Queries

You shouldn't rely on NULLs for the detection of totals and subtotals because some of the groups can be based on an aggregate of things that have NULL "labels". You...
--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)

September 6, 2018 at 9:16 am

#2004729
RE: Automate date to always show current Tuesday

Sergiy - Thursday, September 6, 2018 8:02 AM
Zero date is Monday.
To get Tuesday we need to add 1 day to zero date:
--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)

September 6, 2018 at 8:48 am

#2004719
RE: When is too many columns too many columns?

andycadley - Thursday, September 6, 2018 6:19 AM
In this particular case it is still a 32-bit system and most queries against 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)

September 6, 2018 at 7:04 am

#2004698
RE: When is too many columns too many columns?

Kevlarmpowered - Thursday, September 6, 2018 6:16 AM
Jeff Moden - Wednesday, September 5, 2018 7:47 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)

September 6, 2018 at 6:59 am

#2004696
RE: Separating SSIS Datetime

RonKyle - Wednesday, September 5, 2018 12:32 PM
Jeff Moden - Wednesday, September 5, 2018 12:19 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)

September 6, 2018 at 6:21 am

#2004693
RE: When is too many columns too many columns?

andycadley - Wednesday, September 5, 2018 10:19 PM
I'd never do it with date and time values, it just becomes impossible to query...
--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)

September 6, 2018 at 5:36 am

#2004675
RE: When is too many columns too many columns?

Kevlarmpowered - Wednesday, September 5, 2018 6:51 PM
Without having it right in front of me, I'm willing to say that almost all...
--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)

September 5, 2018 at 7:47 pm

#2004625
RE: Managing a large SQL estate ?

CC-597066 - Wednesday, September 5, 2018 2:20 PM
I built an in-house monitoring system based on Rodney Landrum/David Bird's SSIS packages 10 years ago...
--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)

September 5, 2018 at 3:49 pm

#2004612
RE: When is too many columns too many columns?

ScottPletcher - Wednesday, September 5, 2018 12:04 PM
Jeff Moden - Wednesday, September 5, 2018 11:38 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)

September 5, 2018 at 12:21 pm

#2004569
RE: Separating SSIS Datetime

RonKyle - Wednesday, September 5, 2018 11:43 AM
Jeff Moden - Wednesday, September 5, 2018 11:36 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)

September 5, 2018 at 12:19 pm

#2004568
RE: When is too many columns too many columns?

ScottPletcher - Wednesday, September 5, 2018 11:34 AM
Sergiy - Tuesday, September 4, 2018 9:04 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)

September 5, 2018 at 11:38 am

#2004556
RE: Separating SSIS Datetime

RonKyle - Wednesday, September 5, 2018 11:17 AM
Jeff Moden - Wednesday, September 5, 2018 10:46 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)

September 5, 2018 at 11:36 am

#2004555
RE: Are the posted questions getting worse?

Brandie Tarvin - Wednesday, September 5, 2018 10:28 AM
Sean Lange - Wednesday, September 5, 2018 8:38 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)

September 5, 2018 at 11:01 am

#2004547

Viewing 15 posts - 11,281 through 11,295 (of 59,099 total)