Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,646 through 15,660 (of 59,063 total)

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

#1927822
RE: How to Group By day and get a total from the Amount column per day?

Lots of the code posted is great. The problem that I see with most of it is the omission of "zero" days that will occur. You need a reference that...
--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 10, 2017 at 9:21 am

#1927821
RE: Conditionally execute SHRINKFILE "only" if the file / DB exists

Express12 - Friday, February 10, 2017 8:26 AM
John and Lowell - thx a million.. Your combined solution worked perfectly:
DECLARE @SHRINK_DBS NVARCHAR(4000)
SELECT @SHRINK_DBS...
--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 10, 2017 at 8:59 am

#1927816
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Friday, February 10, 2017 7:05 AM
I'm waiting for the pork chop trebuchet.
You can educate your kids...
--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 10, 2017 at 7:51 am

#1927785
RE: SQL Server DBA training.

Kevin3NF - Friday, February 10, 2017 5:42 AM
Jeff Moden - Thursday, February 9, 2017 8:50 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 10, 2017 at 7:37 am

#1927778

Viewing 15 posts - 15,646 through 15,660 (of 59,063 total)