Jeff Moden

Forum Replies Created

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

RE: sql time attendance queries from access control db

markrj89 - Monday, February 4, 2019 1:04 PM
Good Day
I am very new to SQL and am looking for some help to get me...
--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:55 am

#2021173
RE: Backup and log

mdube 62615 - Tuesday, February 5, 2019 5:51 AM
OK I have found what makes the log grow; it's our weekly index optimization...
--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:50 am

#2021171
RE: MySQL

ben.brugman - Tuesday, February 5, 2019 1:49 AM
Hello Community,
It is my opinion that I have some SQL and SQLserver skills. Apart from...
--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:48 am

#2021170
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

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