Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,096 through 7,110 (of 59,072 total)

Reply To: User Forum is Terrible

p.s. I'm probably a minority here but I hate the look of StackOverflow and similar sites. Everyone has gone that way to support mobile (i.e. smart phones) and so don't...
--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)

May 13, 2020 at 8:20 pm

#3751320
Reply To: Support removing a RID lookup | Different execution plan between environments

Understood on not changing the data in the existing column. It could really screw up a lot of code that's depending on the bloody NULLs.
If you can add a persisted...
--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)

May 13, 2020 at 8:13 pm

#3751318
Reply To: Looking for the cmd to Recompile ALL procs across ALL DBs on a single SQL Server

Express12 wrote:
thx for the suggestin Jeff. I'd really prefer NOT to free the cache.. Looking for the command to mark the procs for RECOMPILE -- across all DB's..
Like Jeffrey Williams...
--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)

May 13, 2020 at 7:53 pm

#3751305
Reply To: User Forum is Terrible

Correct... it doesn't look much different. It's when you try to use the forum and related functionality. Their stuff works better than ours do. Sometimes, ours doesn't work at 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)

May 13, 2020 at 4:35 pm

#3751242
Reply To: Support removing a RID lookup | Different execution plan between environments

From my personal observations, "OR" in criteria is more often a problem than not and, with that, I tell people to make their EndDate column NOT NULL and have 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)

May 13, 2020 at 4:24 pm

#3751234
Reply To: nvarchar - int comparisions
Here's a simplification of Jonas' method above.
```
--===== Create the test table and populate it.
     -- This is NOT a part of the solution.
DECLARE...
```
--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)
May 13, 2020 at 4:06 pm

#3751229
Reply To: Smarter Design

That show at the end is absolutely awesome. Thanks, Steve.
--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)

May 13, 2020 at 2:42 pm

#3751193
Reply To: Looking for the cmd to Recompile ALL procs across ALL DBs on a single SQL Server

DBCC FREEPROCCACHE;
Understand that there could be a period of some pretty high activity and some slowness until all the procs being used are recompiled on their first runs.

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

May 13, 2020 at 1:55 pm

#3751161
Reply To: Number of TempDB Files over 8

BrainDonor beat me to the link he provided. I'll also add that if you're having serious problems with TempDB, there's usually some code in desperate need of a fix.
--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)

May 13, 2020 at 1:53 pm

#3751160
Reply To: What does the Future DBA Do?

Aubrey Love wrote:
Thanks for the info and link.
It looks like the on-premise DBA is going to be met with a few challenges in the future. I know there are a 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)

May 13, 2020 at 1:14 pm

#3751146
Reply To: User Forum is Terrible

@steve-2...
No... this is not like stack overflow especially not when it comes to publishing code nor in rendering previous published code (how hard would it be to overcome the quadruple...
--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)

May 13, 2020 at 12:34 pm

#3751120
Reply To: Are the posted questions getting worse?
x wrote:
jonathan.crawford wrote:
I feel like I'm missing something. An inner join is necessarily an existence check, why not:
```
SELECT u.UserId
  FROM UserTable u
  JOIN TableA 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)
May 13, 2020 at 12:23 pm

#3751110
Reply To: Lack Of User Options

You've yet to make the realization that the "upgrade" they did wasn't really user oriented, although I'm sure that Steve will argue with that. It was to increase the looks...
--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)

May 12, 2020 at 9:53 pm

#3750989
Reply To: Choosing Sequences Over Identity

jcelko212 32090 wrote:
>> In 99.9% of all cases, all most people need is an automatically assigned value incremented by 1. <<
No, I would say that in the majority of cases people...
--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)

May 12, 2020 at 9:47 pm

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

What percentage of the rows of each table are less than 12 months 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)

May 12, 2020 at 6:39 pm

#3750924

Viewing 15 posts - 7,096 through 7,110 (of 59,072 total)