Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,256 through 6,270 (of 59,072 total)

Reply To: What's the Lunch Factor?

From the Article:
...Microsoft does, as do lots of organizations trying to embrace DevOps and produce higher quality...
Ok... you caused me to blow a pork chop bone out of 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)

October 9, 2020 at 2:34 am

#3794325
Reply To: Sudden PLE drop

VastSQL wrote:
Grant Fritchey wrote:
And you're seeing exactly why PLE is a horrible measure, standing on it's own. In combination with other measures, it may tell you things. Just PLE, nope. No...
--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)

October 8, 2020 at 7:57 pm

#3794199
Reply To: Log File Growing

PebbleRock978 wrote:
Hi,
We have a database that has 50GB of data, 99% of which is in one table. In this table there are 31,004,447 records, the developer is running a 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)

October 8, 2020 at 4:46 pm

#3794142
Reply To: Query
If the format is guaranteed an you only want the first element, then the code can be greatly simplified.
```
 SELECT Result = SUBSTRING(SomeText,4,CHARINDEX('&',SomeText,4)-4)
   FROM #Stuff
...
```
--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)
October 7, 2020 at 6:04 pm

#3793753
Reply To: Execution Plan

Admingod wrote:
Thanks guys! We noticed this issue again. So this time I did not restart the database server at all and instead advised to restart application servers only and everything...
--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)

October 7, 2020 at 4:45 pm

#3793717
Reply To: Execution Plan

Admingod wrote:
How about query time-out to exit the query when it has been executed over default 10 minutes to unlimited 0?
If you have a front end query that's taking longer...
--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)

October 7, 2020 at 4:37 pm

#3793715
Reply To: Read Committed Snapshot Isolation and Blocking

Johan Bijnens wrote:
Are you sure your data system really needs it all in actual columns? ( advocate of the devil, I know )
Have you considered putting those "free wheeling columns" into...
--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)

October 7, 2020 at 3:54 pm

#3793693
Reply To: Profiler and Tuning Advisor Stats Recommendation

Even though I'm a fan of SQL Profiler, I don't use it to find queries that may be an issue. I've also found that "long running queries" are not usually...
--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)

October 7, 2020 at 1:32 pm

#3793629
Reply To: Profiler and Tuning Advisor Stats Recommendation

Grant Fritchey wrote:
... but take everything it recommends with a grain of salt the size of a Buick.
BWAAAA-HAAAA-HAAAAA!!!! Man, am I ever glad I didn't have a mouthful of coffee when...
--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)

October 6, 2020 at 5:33 pm

#3793324
Reply To: Nolock hint

DesNorton wrote:
Using NOLOCK is the SQL version of Russian Roulette.
Heh... with 5 of 6 chambers loaded and the really bad part is that you won't know that your report has...
--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)

October 6, 2020 at 5:11 pm

#3793295
Reply To: Are the posted questions getting worse?

Neil Burton wrote:
Well this is awkward.
Wow. Just WOW!

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

October 6, 2020 at 3:45 pm

#3793266
Reply To: DBA progress/career development/ path

Scott Arendt wrote:
I have been reading that DBAs are going to go away as well. The first time that I read that was probably 20 years ago.
Don't worry about the career...
--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)

October 6, 2020 at 3:40 pm

#3793265
Reply To: Create string from broken hierarchy

Ok, try these out with the data you posted above. The "IsCyclic" column should be a big help for you. Like you said, the first one does a whole lot...
--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)

October 6, 2020 at 4:22 am

#3793083
Reply To: Email CSV file

Mike01 wrote:
Not sure what the question is. If these files are saved from the end user, and they probably will be, then if they receive more than 1 day, they...
--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)

October 6, 2020 at 1:38 am

#3793070
Reply To: How to select data based dynamically based on start and end of AffectedProduct ?

I'll give you the same answer that I posted to you over on SQLTeams about a half hour ago...
Assuming that each "*" in your search data is supposed to represent...
--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)

October 6, 2020 at 1:16 am

#3793068

Viewing 15 posts - 6,256 through 6,270 (of 59,072 total)