Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,966 through 37,980 (of 59,072 total)

RE: tablediff - incremental load data changes

I got this off a simple Google search...
http://weblogs.sqlteam.com/mladenp/archive/2007/03/03/60125.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)

June 13, 2010 at 6:09 pm

#1179650
RE: A new IDE for SQL Server?

Phil Factor (6/13/2010)
Yes, it is what we Irish call a 'Donkey's breakfast'. The individual ingredients are good, but all stirred up together into a strange mash from which it 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)

June 13, 2010 at 4:05 pm

#1179641
RE: understanding of data modeling, database design, capacity planning

I agree... it's a huge subject. My recommendation is to GOOGLE for "what is data model" and the other things you requested.
--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 4:01 pm

#1179640
RE: Setting up the Primary Key

David Portas (6/13/2010)
I get it. If Microsoft say that the world is flat or that 2 + 2 = 5 then we should all deny science and common sense and...
--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 3:15 pm

#1179638
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

Viewing 15 posts - 37,966 through 37,980 (of 59,072 total)