Jeff Moden

Forum Replies Created

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

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
RE: Migrating 300+ databases. Need a script to transfer user permissions for all the users across all the databases

Eirikur Eiriksson - Sunday, February 12, 2017 4:31 PM
Ed Wagner - Sunday, February 12, 2017 2:40 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 12, 2017 at 6:29 pm

#1928029
RE: Mixed page allocation

According to the official MS documentation you cited, you are incorrect. Here's the blurb from the first reference you cited...
"This setting is ON for all system databases. tempdbtempdb...
--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:11 pm

#1928028
RE: Is having a lookup table that is for multiple entities a common practice?

Also consider and test for the data integrity problems that Gail spoke of. She's absolutely correct there. From what your boss sounds like, though, he'd shrug that off and insist...
--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 5:24 pm

#1928025
RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

Luis Cazares - Friday, February 10, 2017 12:27 PM
Something baffles me. You're using 70GB of data between data and indexes.
Why is...
--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 11:01 am

#1928003

Viewing 15 posts - 15,646 through 15,660 (of 59,097 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