Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,151 through 12,165 (of 59,102 total)

RE: Be Prepared with Baselines

Heh... I wonder how many people actually know how bad their system currently is when they take that first baseline. I also wonder if they actually do anything about 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)

June 11, 2018 at 8:31 pm

#1993627
RE: Cross Apply not summing correctly

tshad - Monday, June 11, 2018 1:32 AM
I was able to use this in the actual select statement and it worked perfectly.
Thanks.
Like...
--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)

June 11, 2018 at 8:26 pm

#1993626
RE: Career, Certification, MCSA?2012? 2016?

claudioporter - Friday, June 8, 2018 9:01 AM
I do plan to change job because I believe where I am currently haven't given...
--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)

June 11, 2018 at 8:20 pm

#1993625
RE: Microsoft and GitHub

Steve Jones - SSC Editor - Monday, June 11, 2018 11:20 AM
I think some people are driven by fear. Some want things...
--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)

June 11, 2018 at 8:02 pm

#1993624
RE: T-SQL help needed to eliminate duplicates from table

mw_sql_developer - Sunday, June 10, 2018 3:00 PM
To make a long story short, one of our tables that have rx data...
--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)

June 11, 2018 at 7:35 pm

#1993622
RE: remove only number in the given string

Is there any guarantee that ALL of the numeric characters will ALWAYS be contiguous in EVERY string?
--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)

June 11, 2018 at 7:31 pm

#1993621
RE: Get Index Fragmentation Cheaply

Great. Ya just gotta love some of the intrinsic functions. Thanks for the feedback.
--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)

June 10, 2018 at 10:51 pm

#1993500
RE: xp_fileexist undocumented store procedure

I'm at work and don't have the time to test right now nor the code that I used previously but you don't actually need a certificate for this type 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)

June 8, 2018 at 11:32 am

#1993425
RE: xp_fileexist undocumented store procedure

Lynn Pettis - Friday, June 8, 2018 10:53 AM
jasona.work - Friday, June 8, 2018 10:14 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)

June 8, 2018 at 11:00 am

#1993420
RE: xp_fileexist undocumented store procedure

Crud. Sorry Lynn... I got busy last night and forgot.
--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)

June 8, 2018 at 10:45 am

#1993417
RE: Using HTML files as resources in SSRS no longer works after SP2

I'd still call MS.
--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)

June 8, 2018 at 8:54 am

#1993387
RE: CPU Pegged at 100%

dropsa999 - Friday, June 8, 2018 4:15 AM
Hello,
We are planning to move from SQL 2012 to 2017 for the "Perfomance Improvement", on our...
--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)

June 8, 2018 at 8:31 am

#1993380
RE: Using HTML files as resources in SSRS no longer works after SP2

I guess I'd hum a rock at MS and see what they have to say.
--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)

June 8, 2018 at 8:26 am

#1993379
RE: Get Index Fragmentation Cheaply

I don't know if cutting down on the number of joined tables will help but it can't hurt. Here's an example of what I use pared down to what 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)

June 7, 2018 at 6:22 pm

#1993318
RE: High lazywrites - what other counters to look for

I think people spend way too much time looking at counters. Right click on the instance in the Explorer Window, click on reports, and follow your nose for the real...
--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)

June 7, 2018 at 5:00 pm

#1993316

Viewing 15 posts - 12,151 through 12,165 (of 59,102 total)