Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,871 through 9,885 (of 59,099 total)

RE: Tuning Query In Stored Procedure

You do realize that the index on Product_Name is going to have a wee bit of a problem if it ever exceeds the maximum number of bytes for an index,...
--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)

February 5, 2019 at 8:38 am

#2021169
RE: When does SQL decide to load all of an index in to memory?

Another thing that could affect this is stats that need to be updated. Distribution of data within the index could also be a factor and easily have a tipping point...
--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)

February 5, 2019 at 7:29 am

#2021151
RE: findeing matching names from one database to another

briancampbellmcad - Tuesday, February 5, 2019 7:14 AM
ScottPletcher - Monday, February 4, 2019 3:23 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)

February 5, 2019 at 7:24 am

#2021148
RE: A Tiny Trauma

Good article. I'm curious though. Should the number ever be negative in such a case? I'm thinking that the TINYINT actually caught an anomaly for 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)

February 5, 2019 at 7:18 am

#2021147
RE: Copy Backup File

VastSQL - Tuesday, February 5, 2019 12:19 AM
barsuk - Monday, February 4, 2019 11:21 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)

February 5, 2019 at 7:02 am

#2021143
RE: upgrade to 2016 causing performance problems

MJ-1115929 - Tuesday, February 5, 2019 12:56 AM
MJ-1115929 - Monday, February 4, 2019 12:27 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)

February 5, 2019 at 6:54 am

#2021141
RE: Versatile or Jack of all trades

Donna Kelly - Monday, February 4, 2019 3:46 PM
Jeff Moden - Tuesday, January 29, 2019 7:53 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)

February 4, 2019 at 7:24 pm

#2021098
RE: auto-generate-sql-server-restore-script-from-backup-files (bak + trn) -in-a-directory for multi databases

The real key is... why do you need to "generate a restoration script for hundreds of databases with their backup Full and log file"??? What's the end game here??? And,...
--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)

February 4, 2019 at 6:54 pm

#2021095
RE: auto-generate-sql-server-restore-script-from-backup-files (bak + trn) -in-a-directory for multi databases

abdalah.mehdoini - Monday, February 4, 2019 9:31 AM
Jeff Moden - Monday, February 4, 2019 6:31 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)

February 4, 2019 at 6:43 pm

#2021094
RE: Sort already comma separated list

jcelko212 32090 - Monday, February 4, 2019 11:16 AM
Jeff Moden - Sunday, February 3, 2019 8:08 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)

February 4, 2019 at 2:28 pm

#2021090
RE: Why Change?

Rod at work - Monday, February 4, 2019 8:55 AM
Oh, this topic is near and dear to my heart. I've seen resistance...
--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)

February 4, 2019 at 9:04 am

#2021041
RE: split data in equal halves

Papil - Monday, February 4, 2019 7:10 AM
Thanks .It works.
To be sure, do you understand how and why it works?
--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)

February 4, 2019 at 8:01 am

#2021032
RE: auto-generate-sql-server-restore-script-from-backup-files (bak + trn) -in-a-directory for multi databases

abdalah.mehdoini - Monday, February 4, 2019 6:27 AM
Who has an idea or feedback on the sp_RestoreGene function
What's the link for it? (I'm...
--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)

February 4, 2019 at 6:31 am

#2021020
RE: Creating Your First Stored Procedure

Great article, Steve.
My only quandary is where does the idea of it being preferable to include BEGIN/END come from? Oracle? Portability? To be sure, I never include BEGIN/END...
--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)

February 4, 2019 at 6:00 am

#2021017
RE: Fill Factor for OLTP database

equipe9 - Thursday, January 31, 2019 4:55 PM
I am setting up a new OLTP database and expect to write to the database...
--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)

February 3, 2019 at 8:31 pm

#2020993

Viewing 15 posts - 9,871 through 9,885 (of 59,099 total)