Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,621 through 13,635 (of 59,101 total)

RE: Choosing the Birthday of a Customer by month?

chef423 - Wednesday, November 22, 2017 10:12 AM
Lynn Pettis - Wednesday, November 22, 2017 8:52 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)

November 22, 2017 at 1:55 pm

#1969266
RE: Choosing the Birthday of a Customer by month?

ScottPletcher - Wednesday, November 22, 2017 12:25 PM
Lynn Pettis - Wednesday, November 22, 2017 12:05 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)

November 22, 2017 at 1:52 pm

#1969264
RE: Are the posted questions getting worse?

Shifting gears a bit... I get a lot of spam from recruiters. Some of them are trying to be helpful and one of them sent an email about "WHAT TRAITS...
--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)

November 22, 2017 at 9:53 am

#1969213
RE: Are the posted questions getting worse?

GilaMonster - Tuesday, November 21, 2017 10:23 AM
Ed Wagner - Tuesday, November 21, 2017 5:34 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)

November 22, 2017 at 9:46 am

#1969211
RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

patrickmcginnis59 10839 - Tuesday, November 21, 2017 8:29 AM
Jeff Moden - Tuesday, November 21, 2017 8:13 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)

November 22, 2017 at 9:40 am

#1969209
RE: Date Ranges - Simple, but seemingly impossible

whenriksen - Wednesday, November 22, 2017 7:33 AM
DO NOT "correct" the data from your source. It is very common for 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)

November 22, 2017 at 9:21 am

#1969206
RE: Better TSQL Performance

PrettyMegaDBA - Wednesday, November 22, 2017 8:16 AM
Thank you all for your responses. All have been very helpful. And forgive me, 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)

November 22, 2017 at 8:20 am

#1969180
RE: Force execution plan in a view

Luis Cazares - Wednesday, November 22, 2017 7:41 AM
Jeff Moden - Tuesday, November 21, 2017 9:10 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)

November 22, 2017 at 8:15 am

#1969178
RE: The Pressure to Perform

Jack 49290 - Wednesday, November 22, 2017 3:21 AM
From Code Magazine .... Legal Notes: Should Software Developers Be...
--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)

November 22, 2017 at 8:12 am

#1969176
RE: The Pressure to Perform

mark.magagna - Wednesday, November 22, 2017 7:45 AM
What is the function of a salesman? For many organizations, it is "Get the customer'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)

November 22, 2017 at 8:03 am

#1969175
RE: Choosing the Birthday of a Customer by month?

saravanatn - Wednesday, November 22, 2017 12:55 AM
Hi,
This might fitting into your requirement.
SELECT *
FROM (

--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)

November 22, 2017 at 7:27 am

#1969169
RE: Slow query - client or server issue

leehbi - Wednesday, November 22, 2017 5:00 AM
I can't easily share the plans as there is sensitive data in column names. ...
--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)

November 22, 2017 at 7:19 am

#1969168
RE: trying to edit a stored procedure

To answer the immediate question...
I've also seen the rest of the code on your other posts. You're accumulating the information for each database in the global temporary 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)

November 22, 2017 at 6:54 am

#1969163
RE: Replicate data from PROD into test

If your system has a SAN, most SANs have some option to do a SAN "Snapshot" either as a built in or optional feature.
I still think a restore...
--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)

November 22, 2017 at 6:30 am

#1969159
RE: Better TSQL Performance

See that DISTINCT? Figure out which join(s) are causing the need for that and fix it. That will almost certainly be the root of your performance problem. If you want...
--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)

November 22, 2017 at 6:23 am

#1969156

Viewing 15 posts - 13,621 through 13,635 (of 59,101 total)