Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,981 through 10,995 (of 59,102 total)

RE: Query slow. Help improve?

Heh... I just saw your other post on the monster wide table that violated every form of normalization there is and where every update was preserved without the benefit of proper historical...
--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 13, 2018 at 10:25 am

#2009490
RE: Are the posted questions getting worse?

Jeff Moden - Saturday, October 13, 2018 9:42 AM
Eirikur Eiriksson - Saturday, October 13, 2018 3:54 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)

October 13, 2018 at 10:16 am

#2009488
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Saturday, October 13, 2018 3:54 AM
frederico_fonseca - Saturday, October 13, 2018 3:12 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)

October 13, 2018 at 9:42 am

#2009482
RE: Query slow. Help improve?

SQLStud 74876 - Friday, October 12, 2018 5:08 PM
I'm pretty good with SQL, so no newbs please.
Do you always walk into 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)

October 13, 2018 at 9:33 am

#2009481
RE: Are Indexes Actually Changes to the System?

Paul Randal - Thursday, October 11, 2018 10:00 PM
We did a bunch of testing back in 1999 when the code was originally...
--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 11, 2018 at 10:06 pm

#2009278
RE: Barracuda backups, VMWare and Backup Device Type 7

So, have you tried a restore yet?
--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 11, 2018 at 9:59 pm

#2009276
RE: Are Indexes Actually Changes to the System?

Thanks for the feedback, Paul. I've admittedly got an environment that's quite a bit different than a synchronous AG/mirror environment and simply don't have access to such an environment. Do...
--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 11, 2018 at 9:33 pm

#2009275
RE: Init-cap the characters in SQL server

Lynn Pettis - Wednesday, October 10, 2018 2:01 PM
And if your server or database is using a case sensitive collation?
Run 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)

October 11, 2018 at 9:17 pm

#2009273
RE: Are the posted questions getting worse?

Shifting gears back to the SSMS 17 vs old SSIS problems... I learned my lesson way back in SS 2000 when it was DTS. I developed methods to do most...
--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 11, 2018 at 8:31 am

#2009139
RE: Are the posted questions getting worse?

jasona.work - Thursday, October 11, 2018 8:06 AM
But it keeps showing up in Unread posts, TAUNTING us!
(I've unsubscribed already.)
It's like an itch...
--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 11, 2018 at 8:24 am

#2009133
RE: What are some really dumb things you could write in a SQL Query

drew.allen - Thursday, October 11, 2018 7:49 AM
Hugo Kornelis - Thursday, October 11, 2018 7:16 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)

October 11, 2018 at 8:09 am

#2009126
RE: Are the posted questions getting worse?

Brandie Tarvin - Thursday, October 11, 2018 5:19 AM
Steve, there's no good way to add comments to Report Post anymore. Can 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)

October 11, 2018 at 8:02 am

#2009121
RE: Are Indexes Actually Changes to the System?

Ah crud. Somehow, I left out a couple of sections above and forgot to attach the index DNA proc and spreadsheet (now attached).
First, here's what "Low Threshold Rebuilds" do to...
--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 10, 2018 at 11:58 pm

#2008991
RE: Are Indexes Actually Changes to the System?

First, here’s a flowchart of the code that ran each test in each of the following charts. What’s NOT shown...
--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 10, 2018 at 10:49 pm

#2008987
RE: Are Indexes Actually Changes to the System?

Paul Randal - Wednesday, October 10, 2018 6:20 PM
But above you say "REORGANIZE (NEVER USE REORGANIZE!!!! IT DOESN'T WORK THE WAY...
--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 10, 2018 at 8:58 pm

#2008983

Viewing 15 posts - 10,981 through 10,995 (of 59,102 total)