Jeff Moden

Forum Replies Created

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

RE: Read multiple .sql files having issues with .cmd script :(

The next level of simplification exists in the following command... have a look.
https://technet.microsoft.com/en-us/library/cc753551(v=ws.11).aspx
--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 14, 2017 at 6:26 pm

#1928532
RE: Query fills tempdb after upgrade from 2005 to 2012

TheSQLGuru - Tuesday, February 14, 2017 5:16 PM
jamie_collins - Tuesday, February 14, 2017 2:46 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 14, 2017 at 5:49 pm

#1928529
RE: Performance improves after reboot

RVO - Tuesday, February 14, 2017 11:25 AM
Jeff,
Is Kevin G. Boles specialty - performance issues?
What is the best way to contact Kevin?
Send...
--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 14, 2017 at 5:45 pm

#1928528
RE: Reducing the size of a 500 Gb database on standard edition

ffarouqi - Tuesday, February 14, 2017 4:11 PM
GilaMonster - Tuesday, February 14, 2017 4:05 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 14, 2017 at 4:53 pm

#1928521
RE: Reducing the size of a 500 Gb database on standard edition

ffarouqi - Tuesday, February 14, 2017 11:52 AM
One of my clients has requested to find any options to reduce the size of...
--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 14, 2017 at 1:16 pm

#1928482
RE: Performance improves after reboot

The number you're looking for is the 360 that was returned.
--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 14, 2017 at 1:03 pm

#1928479
RE: Sql Server "Runbook" !

Are they simply talking about the "runs" that are done via scheduled jobs?
--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 14, 2017 at 1:01 pm

#1928478
RE: Running date update

So how long does the update through the CTE take for 1 million out of the 6.5 million rows now?
--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 14, 2017 at 9:12 am

#1928397
RE: Performance improves after reboot

RVO - Monday, February 13, 2017 8:09 PM
Jeff, as usually your response is the most thorough, detailed, to the point.
Thanks a lot.
Thank...
--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 13, 2017 at 10:56 pm

#1928268
RE: Problems With Database Problems

chrisn-585491 - Monday, February 13, 2017 6:21 AM
Jeff Moden - Sunday, February 12, 2017 7:45 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 13, 2017 at 8:13 pm

#1928258
RE: How to break down time span in Categories

Chris Harshman - Monday, February 13, 2017 10:05 AM
Jeff, yes I usually reference an article from a well respected person such as...
--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 13, 2017 at 1:16 pm

#1928198
RE: SQL Server DBA training.

Kevin3NF - Sunday, February 12, 2017 5:54 PM
Jeff Moden - Friday, February 10, 2017 4:49 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 13, 2017 at 7:58 am

#1928113
RE: CTE Recursive Query

robertopmorris - Thursday, February 9, 2017 1:34 AM
Here is an example data set:
ParentWO
2088/1.1 IssueQty
14 ChildWO
2088/1.1.1 Production_Qty
40 Qty_Complete
40
2088/1.1 25 2088/1.1.1 40 40
2088/1.1 1 2088/1.1.2 40 40
2088/1.1 14 2088/1.1.2 40 40
2088/1.1.1 40 2088/1.1.1.1 40 40
2088/1.1.2 40 2088/1.1.2.1 40 40
I have rewritten the CTE query...
--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 12, 2017 at 7:49 pm

#1928033
RE: Problems With Database Problems

Forgiveness is certainly divine but I wonder how may people's tone would be different if they were a part of the group that suffered data losses.
This brings up...
--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 12, 2017 at 7:45 pm

#1928032
RE: Non cluster index vs non cluster index include

89netanel - Sunday, February 12, 2017 2:31 PM
What is the difference between Non cluster index and non cluster index with includeAnd when...
--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 12, 2017 at 6:56 pm

#1928030

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

ParentWO 2088/1.1	IssueQty 14	ChildWO 2088/1.1.1	Production_Qty 40	Qty_Complete 40
2088/1.1	25	2088/1.1.1	40	40
2088/1.1	1	2088/1.1.2	40	40
2088/1.1	14	2088/1.1.2	40	40
2088/1.1.1	40	2088/1.1.1.1	40	40
2088/1.1.2	40	2088/1.1.2.1	40	40