Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,676 through 15,690 (of 59,097 total)

RE: Did you ever see a change of a collation change drastically a performance of a query?

FabricioLimaDBA - Thursday, February 9, 2017 4:58 AM
Hi Guys,
Did you ever see a change of a collation change drastically a performance...
--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 11, 2017 at 11:51 am

#1927951
RE: trouble wit a poor performing query

gvoshol 73146 - Thursday, February 9, 2017 5:21 AM
Jeff Moden - Tuesday, February 7, 2017 5:00 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 11, 2017 at 11:42 am

#1927950
RE: Best way to determine to Clustered index keys

JasonClark - Thursday, February 9, 2017 10:24 PM
Bulk recovery
--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 11, 2017 at 9:59 am

#1927946

RE: Query works until I use it in a stored procedure (contains forward slash)

Lynn Pettis - Thursday, February 9, 2017 4:42 PM

pharmkittie - Thursday, February 9, 2017 4:11 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 11, 2017 at 9:49 am

#1927945

RE: Performance improves after reboot

RVO - Wednesday, February 8, 2017 4:24 PM

I am an ETL Developer who was asked to
look at SQL Server performance problem.
We...

--Jeff Moden

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 11, 2017 at 8:52 am

#1927944

RE: Sync Prod to Non-Prod

Andy sql - Tuesday, February 7, 2017 2:20 AM

If your setup is very "strict" you first need to consider whether you can...

--Jeff Moden

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 10, 2017 at 7:11 pm

#1927926

RE: SQL Server DBA training.

Kevin3NF - Friday, February 10, 2017 11:33 AM

Jeff Moden - Friday, February 10, 2017 9:22 AM

--Jeff Moden

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 10, 2017 at 4:49 pm

#1927915

RE: Are the posted questions getting worse?

Luis Cazares - Friday, February 10, 2017 12:37 PM

Is a 200GB storage or less common for productive db servers? I know that...

--Jeff Moden

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 10, 2017 at 4:26 pm

#1927910

RE: Roll up of % and duration to Parent from Child

PSB - Wednesday, February 8, 2017 5:02 PM

Hi,

I need to roll up Completed and Duration from child to the respective parent tasks ....

--Jeff Moden

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 10, 2017 at 4:22 pm

#1927907

RE: Roll up of % and duration to Parent from Child

sgmunson - Friday, February 10, 2017 12:29 PM

PSB - Thursday, February 9, 2017 5:44 AM

--Jeff Moden

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 10, 2017 at 4:12 pm

#1927905

RE: t-sql 2012 update statement

wendy elizabeth - Friday, February 10, 2017 11:03 AM

John Mitchell-245523 - Friday, February 10, 2017 9:41 AM

--Jeff Moden

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 10, 2017 at 3:48 pm

#1927904

RE: How to break down time span in Categories

The good method that Chris posted above is called a "CROSSTAB". You can learn how it works at the following URL:
http://www.sqlservercentral.com/articles/T-SQL/63681/

--Jeff Moden

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 10, 2017 at 3:39 pm

#1927902

RE: Insert into linked server

adb2303 - Friday, February 10, 2017 3:01 AM

I have changed to SQL to pull, rather than push the records. That works fine....

--Jeff Moden

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 10, 2017 at 3:34 pm

#1927901

RE: Create CSV file using xp_cmdshell

Step one is to materialize the BCP command contained in the variable and try it from the command prompt to make sure that things are working correctly. Also be advised...

--Jeff Moden

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 10, 2017 at 3:06 pm

#1927899

RE: SQL Server DBA training.

Kevin3NF - Friday, February 10, 2017 8:09 AM

Jeff Moden - Friday, February 10, 2017 7:37 AM

--Jeff Moden

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 10, 2017 at 9:22 am

#1927822

Viewing 15 posts - 15,676 through 15,690 (of 59,097 total)