Jeff Moden

Forum Replies Created

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

RE: Sql Query to Concatenate Rows Group by id

Achiever-785539 (2/25/2010)
Hi All,
I have a requirement that i need to concate rows based on the id. with out using cursors
Can any one help me in this??
In Advance Thanks!!
Regards
Siva
Some 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 26, 2010 at 1:09 am

#1125410
RE: Data Dashboards

As a sidebar, I think it should be against the law to associate searches with the humans that made them.
--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:58 am

#1125408
RE: Cant shrink log file

To add to what Jason stated...
Not that I recommend it, but if you're only going to backup the log once a day, then there's almost no sense in having 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)

February 26, 2010 at 12:51 am

#1125403
RE: Identity field on each table

miss.delinda (2/26/2010)
I understood each table must have a Identity Field called trnxid (transaction id)
Consider as follow,
CREATE TABLE [dbo].[tCounter](
[trnxid] [int] IDENTITY(1,1) NOT NULL primary key clustered,
[cd] [varchar](20) NOT NULL,
[desn] [varchar](50) 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)

February 26, 2010 at 12:45 am

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

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