Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,616 through 15,630 (of 59,063 total)

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
RE: Are the posted questions getting worse?

Hugo Kornelis - Sunday, February 12, 2017 3:41 AM
Jeff Moden - Saturday, February 11, 2017 5:17 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 10:54 am

#1928002
RE: Keeping Fact Tables Online while Loading via Partition Switching

shubhankarthatte - Saturday, February 11, 2017 10:19 PM
Jeff Moden - Thursday, January 19, 2017 5:01 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 12, 2017 at 10:42 am

#1927999
RE: What is perfect way to declare variable data type in asp.net to match SQL data type?

Understood but if you don't know that you shouldn't pass a "DOUBLE Word" to a "TinyInt", you're in deep Kimchi. 😉
--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 10:33 am

#1927997
RE: SQL Server DBA training.

Just to further support my position on having an in-depth knowledge of "SQL" (T-SQL in our world) regardless of what you decide to specialize on, please see the following article...
--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 10:31 am

#1927996

Viewing 15 posts - 15,616 through 15,630 (of 59,063 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