Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,586 through 39,600 (of 59,098 total)

RE: capacity planning for SQL Server Dbs storage

sqlguy-549681 (2/28/2010)
Guys,
really appreciate the valuable info I have got.. But so far I didn't get a solid way or clear steps to calculate my database required storage. I have...
--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 28, 2010 at 8:59 am

#1126257
RE: restore a single table

I could certainly be incorrect here but I don't believe that you can restore a given table as a different name directly. I believe the only way to do...
--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 28, 2010 at 8:49 am

#1126255
RE: which query's exec. costs are better/more efficient

Heh... you posted a code example while I was writing a reply. Now that I've seen that, I'm sure this would make an excellent article. You should go...
--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 28, 2010 at 8:43 am

#1126254
RE: which query's exec. costs are better/more efficient

Ah... very cool, Barry. I was going to simply state that physical reads are disk reads and since disk reads are a lot slower than memory reads, when all...
--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 28, 2010 at 8:42 am

#1126253
RE: sp_executesql doesn't pass parameters, exec does

{Edit} Sorry... posted an incorrect observation.
--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 28, 2010 at 8:17 am

#1126246
RE: Please Help - I've gone cross eyed.

Paul White (2/27/2010)
GilaMonster (2/26/2010)
Seriously, there is no good way of getting an ID value from the database, then later putting the rest of the row in.
There is, and it's called...
--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 27, 2010 at 1:31 pm

#1126145
RE: Transform Data -- Sequential to 3 Groups of Columns

PhilM99 (2/27/2010)
Very cool. I'll investigate the meaning of the MAX( ... it's not obivous why it's used there.
Its only purpose is to allow the GROUP BY to work well enough...
--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 27, 2010 at 1:15 pm

#1126142
RE: need help in sql

tabrez.test (2/27/2010)
Hi
plzz help me in sql
in the following table
policy transaction
1234 new
1234 ...
--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 27, 2010 at 1:05 pm

#1126141
RE: Overusing Identities

I use identities for the same reason that people are issued SSN's... It makes life real simple as a unique identifier in the world of large batch programming. ...
--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 27, 2010 at 12:59 pm

#1126140
RE: Identity field on each table

Paul White (2/27/2010)
Jeff Moden (2/26/2010)
Heh... I've never actually met or heard of anyone who has actually done that.
Hello! Pleased to meet you.
Actually, I worked at a place which started...
--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 27, 2010 at 12:10 pm

#1126130
RE: Calculating interest query

nathan 7372 (2/27/2010)
I'm overwhelmed with all the help. When I first posted this problem I figured it might be quite some time if ever that someone came up with...
--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 27, 2010 at 10:06 am

#1126113
RE: Fast random row selector

ssc-574207 (2/25/2010)
Thanks. We had tried ORDER BY NEWID() and as Ron suggested it was definitely slower.
TABLESAMPLE didn't work because we need a sample of joined rows and you can...
--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 27, 2010 at 9:56 am

#1126109
RE: Calculating interest query

Paul White (2/27/2010)
Chris,
Turns out all that is needed to get rid of the index spool is to define the clustered index as UNIQUE. Given that information, a better plan...
--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 27, 2010 at 9:13 am

#1126103
RE: Calculating interest query

Paul White (2/27/2010)
This is a method called 'set-based iteration' by MVP Hugo Kornelis, which was first brought to my attention here in a discussion of one of Jeff's fine articles.
Heh......
--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 27, 2010 at 9:08 am

#1126101
RE: Avoid dynamic SQL

Kingston Dhasian (2/26/2010)
Paul White (2/26/2010)
--------------------------------------------------------------------------------
If you have a pain in your finger, chopping your hand off is not the solution.
In fairness, it is *a* solution, just probably not optimal...
--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 27, 2010 at 12:03 am

#1126015

Viewing 15 posts - 39,586 through 39,600 (of 59,098 total)