Jeff Moden

Forum Replies Created

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

RE: update 2 tables at once

Always payments will have more records than pledges.
Gosh... that may be your requirement, but I really find it hard to believe that there will never be an instance where someone...
--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 26, 2010 at 12:39 am

#1125395
RE: 60GB DB Growth in 2 weeks

First, I'd change the autogrowth to a fixed number of mega-bytes. Do you really want your 20GB database to grow by 2GB when it needs to?
It sounds like you've...
--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 25, 2010 at 11:35 pm

#1125372
RE: queries slows down after installing sp4

I'm not sure what to tell you about this. Many people had the same problem. While it's true that sp4 made a lot of security updates, sp3A fixed...
--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 25, 2010 at 11:24 pm

#1125369
RE: High CPU

sandhyarao49 (2/25/2010)
Hi,
It is an update statement from one of the tool hosted on the server.
I've run into that once myself and many times for other people. Please post...
--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 25, 2010 at 11:07 pm

#1125365
RE: What does the "Reserved" column in the pre-supplied "Disk Usage by Table" report represent?

If the PK you've selected is the Clustered Index (and they are by default), and the clustered index order doesn't resemble the same order as any INSERTS that may occur,...
--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 25, 2010 at 11:04 pm

#1125364
RE: Calculating interest query

Nathan,
My recommendation would be for you to read the article at the first link in my signature line below. Following the recommendations for how to post in that 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 25, 2010 at 10:51 pm

#1125358
RE: Delete with inner join on another table with where clauses

Actually, you've used a form of DELETE that will usually work but can have some serious problems sometime in the future. My recommendation is that you must use both...
--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 25, 2010 at 10:45 pm

#1125357
RE: Need SQL Statement To Increment A Column Sequen. In A Group

GilaMonster (2/25/2010)
Actually, there's one more if this is a once-off update.
Run the update in master and use 3-part naming to reference the DB in question. Compat mode is controlled by...
--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 25, 2010 at 9:46 pm

#1125338
RE: Need SQL Statement To Increment A Column Sequen. In A Group

B. Hill (2/25/2010)
Good call. Running SQL Server 2005 but the database is in 2000 compatibility mode.
Ideas?
Unless you can do what Gail says and run the DB in the 90 compatible...
--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 25, 2010 at 1:28 pm

#1125195
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Mike M - DBA2B (2/25/2010)
Ha!
Well, you, a fellow named Tom(?), and I all used to try to help folks out on another SQL forum about 6 years ago. Tom was...
--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 25, 2010 at 1:05 pm

#1125179
RE: Need SQL Statement To Increment A Column Sequen. In A Group

B. Hill (2/25/2010)
Thanks for the response.
2 issues. First, I get the error: 'ROW_NUMBER' is not a recognized function name
second, I want to update the DeptSeq column to the incremented...
--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 25, 2010 at 11:41 am

#1125142
RE: Transform data: One column to many column

nguyennd (2/25/2010)
I have same problem but my data is:
create table A
(
H int,
D int
)
insert into...
--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 25, 2010 at 11:35 am

#1125138
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Mike M - DBA2B (2/25/2010)
I saw the title and author of the articles and it seemed like old times. 🙂
Jeff! It's been years since we last conversed, but it's good...
--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 25, 2010 at 11:20 am

#1125129
RE: using bcp format file to load data

There's actually some pretty good examples in Books Online under "BCP".
--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 25, 2010 at 6:31 am

#1124913
RE: Calculating total working hours exclude launch, smoking...and etc times

Most people like to test their solutions before posting. Please post the data in a readily consumable format. See the first link in my signature line below.
Also, people...
--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 25, 2010 at 6:25 am

#1124907

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