Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,996 through 38,010 (of 59,098 total)

RE: Setting up the Primary Key

David Portas (6/12/2010)
Jeff Moden (6/12/2010)
Indexes are not just about performance... they're a part of DRI.
Are you familiar with the SQL standard? It most certainly includes DRI and certainly does not...
--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)

June 13, 2010 at 11:33 am

#1179622
RE: procedure works without end CPU 100%

Ah.... another possibly very serious problem... you're updating the Numer_rachunku column. That column is used in joins in two of the sub queries including the one that I think...
--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)

June 13, 2010 at 11:04 am

#1179618
RE: procedure works without end CPU 100%

The UPDATE appears to be properly formed in that the target of the update is in the FROM clause so no problem there. I can't really tell because I...
--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)

June 13, 2010 at 10:51 am

#1179615
RE: Concurrent users on SQL Server

niladri.sirkar (6/12/2010)
Hi,
I have a question. In one of my applications, I am getting a Deadlock situation of there are more users using the site at the same time. Is there...
--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)

June 12, 2010 at 12:48 pm

#1179559
RE: Concurrent users on SQL Server

lugang (8/17/2005)
3) use with (nolock) in all queries possible
That's actually some pretty terrible advice and is usually indicative of some really bad code if it's actually needed to realize performance....
--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)

June 12, 2010 at 12:41 pm

#1179558
RE: Setting up the Primary Key

Heh... it's simple. Just reverse almost everything that David said.
Keys and indexes do need to be considered together... that's part of what DRI is all about.
Indexes are not just...
--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)

June 12, 2010 at 12:36 pm

#1179557
RE: Setting up the Primary Key

David Portas (6/12/2010)
Maybe you are getting confused because you are asking the wrong questions. First determine what keys make sense from a business perspective. If you are thinking purely in...
--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)

June 12, 2010 at 11:45 am

#1179551
RE: procedure works without end CPU 100%

You have an "accidental cross join" (ie... many-to-many) in the query due to either insufficient criteria or improper use of the UPDATE statement. Take a look in the estimated...
--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)

June 12, 2010 at 11:24 am

#1179548
RE: Get Month Name

trishdiep (6/12/2010)
Awesome, thanks so much to Jeff and Karthik!
I want to say thank you to Jeff for helping so many of us, Much appreciated!:-)
Thank you very much for the feedback....
--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)

June 12, 2010 at 10:26 am

#1179545
RE: Is there a way to use "select for xml" to pass data between sql2000 servers?

In fact, Randy, here's the SQL Server 2000 compatible general purpose string splitter function that I used (took me a bit to find it) before I started using SQL Server...
--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)

June 12, 2010 at 10:16 am

#1179544
RE: Is there a way to use "select for xml" to pass data between sql2000 servers?

randy rice (6/12/2010)
Matt - yes, that would work, and now that I think about it, for what I'm doing may be a more appropriate way than RPCs. Thanks.
Jeff -...
--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)

June 12, 2010 at 8:33 am

#1179539
RE: Executing a stored procedure issue

tosscrosby (6/11/2010)
:blush: It was the "Go". What a dope - I couldn't see the forest for the trees!!! I should've walked away, cleared my head and figured it...
--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)

June 11, 2010 at 10:28 pm

#1179510
RE: Is there a way to use "select for xml" to pass data between sql2000 servers?

randy rice (6/11/2010)
I have two sql 2000 servers. On server1 I need to be able to call a remote stored procedure on server2 to fetch some data and insert...
--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)

June 11, 2010 at 10:23 pm

#1179509
RE: Mentor

scott.pletcher (6/11/2010)
A studentgrade table has one row per student and test. Each student may have taken anywhere from 0 to 3 (never more) tests.
studentgrade --> (studid int, test# int,...
--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)

June 11, 2010 at 5:47 pm

#1179490
RE: Help with a weird query

Chris Morris-439714 (6/11/2010)
lart.expert (6/11/2010)
Is it me, or does this look like a homework question?
Unlikely as OP has been a forum member for over two years.
Heh... maybe a 4 year school?...
--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)

June 11, 2010 at 5:29 pm

#1179487

Viewing 15 posts - 37,996 through 38,010 (of 59,098 total)