Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,901 through 27,915 (of 59,101 total)

RE: How to solve blocking issue

gantavasu (12/10/2012)
Here for blocking we need to kill the sp id.
how to solve the deadlock issue.
It's normally not a simple thing and it's far too complex to explain on a...
--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)

December 10, 2012 at 8:47 am

#1567081
RE: How to solve blocking issue

sgmunson (12/10/2012)
You can always kill one spid or the other, but you should know the impact of that first. As to what you meant by "deadlock and blocking...
--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)

December 10, 2012 at 8:45 am

#1567079
RE: Demanding and difficult logic qns. Sorry but i need help.

The reason why I use T-SQL for this is because it's frequently much better to do things there. So much so that a lot of people will build "Execute...
--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)

December 10, 2012 at 7:41 am

#1567044
RE: Demanding and difficult logic qns. Sorry but i need help.

10e5x (12/10/2012)
So now my first task will be go google research on how to write stored procedure in SSIS? Am I right?
Oh my. As you said, you really...
--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)

December 10, 2012 at 7:32 am

#1567036
RE: Type A, B, or C

davoscollective (12/9/2012)
Jeff Moden (12/7/2012)
Then, there are terms like "OCD" and, as someone pointed out on this thread, OCDs make good DBAs. So why then is it still labeled 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)

December 10, 2012 at 6:33 am

#1567004
RE: Memory usage

GilaMonster (12/10/2012)
Jeff Moden (12/9/2012)
GilaMonster (12/9/2012)
No.
Page reads != fragmentation.
Do you consider page splits to be a form of fragmentation?
Page splits may cause logical fragmentation (or may not, depending which pages...
--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)

December 10, 2012 at 6:08 am

#1566996
RE: Demanding and difficult logic qns. Sorry but i need help.

10e5x (12/9/2012)
Hi Jeff,
HOLY MAMA!!! Omg how did that even come about? Its my third time reading your method and i am still like circling around the forest. Thats way too...
--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)

December 10, 2012 at 5:56 am

#1566994
RE: Memory usage

GilaMonster (12/9/2012)
No.
Page reads != fragmentation.
Do you consider page splits to be a form of fragmentation?
--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)

December 9, 2012 at 4:33 pm

#1566894
RE: Memory usage

mah_j (12/9/2012)
Thanks a lot for your reply.
Due to the increases in page reads counter in performance monitor(during the time out) I think the problem is fragmentation.I will check the...
--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)

December 9, 2012 at 4:32 pm

#1566893
RE: Update Gaps

CELKO (12/9/2012)
Regarding your ANSI/ISO INSERT INTO comment, unless I'm mistaken, your suggestion only works on 2008 or higher. The DATE data type is also not a valid 2005...
--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)

December 9, 2012 at 4:16 pm

#1566892
RE: Demanding and difficult logic qns. Sorry but i need help.

Here's one possible answer...
Assuming the "ACCESS_SOURCE" is a table, we need to first combine the Event_D and Event_T columns into a single, sortable, calculable column. This should have been...
--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)

December 9, 2012 at 12:54 pm

#1566887
RE: Demanding and difficult logic qns. Sorry but i need help.

So what do you want to do if there's an access late in the day and no exit until the next day?
Also, what do you want CONSECUTIVE_D to be if...
--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)

December 9, 2012 at 10:06 am

#1566879
RE: sign of corrupt database?

As a side bar, I recommend adding SET NOCOUNT ON at the beginning of each trigger so that it suppresses all of that unnecessary IO. To wit, sometimes a...
--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)

December 8, 2012 at 11:00 pm

#1566864
RE: ORMs and Indexes with Included Columns

LightningFingers (12/1/2010)
I'm using LINQ to SQL, but I think this question may apply to any ORM tool.
Then, you have a much more insideous problem to watch for. If you...
--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)

December 8, 2012 at 10:52 pm

#1566862
RE: ORMs and Indexes with Included Columns

LightningFingers (12/2/2010)
I agree. You should never assume that any optimization has actually optimized anything until you test it. Testing L2S is a pain in the *** because you basically need...
--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)

December 8, 2012 at 10:48 pm

#1566861

Viewing 15 posts - 27,901 through 27,915 (of 59,101 total)