Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,421 through 48,435 (of 59,099 total)

RE: sqlquery

sandhyarao49 (9/6/2008)
Hi Folks,
I have a small doubt.
suppose in a table there are 100 rows.
I want to retrieve only 40 th row.Could any one help me out.
Thanks,
Sandhya
Just how do you identify...
--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)

September 7, 2008 at 11:07 am

#868236
RE: I know this should be simple - update hacked table with good data from a copy

It would be easier to simply delete the hacked rows and insert the repaired rows. If the ID column is important for identification of the row, you can use...
--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)

September 7, 2008 at 11:02 am

#868234
RE: tempdb reporting Error: 9002 log full

p.s.
We have some fairly large systems... in my last job, we booted TempDB at 9GB and in my current job, we boot it at 6GB. TempDB is an important...
--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)

September 7, 2008 at 10:49 am

#868232
RE: tempdb reporting Error: 9002 log full

The default settings for TempDB are to start at 1MB with 10% growth. If you do the math, it'll take 73 growths to get to 1GB... 73 growths also...
--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)

September 7, 2008 at 10:40 am

#868231
RE: Need help re-organizing query - if possible - so it is more efficient

Can't tell from your last post if your serious or not so I'll assume you're serious. 🙂
It's a clever bit of code that Peso wrote. Use...
--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)

September 7, 2008 at 9:46 am

#868228
RE: Need help re-organizing query - if possible - so it is more efficient

Heh... if YOU had a question on what it does, others will to. Time to break out the grossly underused "dash dash" function. 😉
--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)

September 6, 2008 at 6:08 pm

#868185
RE: Computed column formula with join

Like Carl said... can't be done by a computed column... but, you could use a view for this. Carl also suggested that you could use a trigger and that...
--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)

September 6, 2008 at 6:04 pm

#868184
RE: Pass file name as variable

Once the text server (linked server) has been established, you don't need to make a trip to the CmdShell to get a listing of files in the directory....
...
--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)

September 6, 2008 at 6:01 pm

#868183
RE: Auto update table with correlated subquery

Ok... sorry for the delay.
Here's the test data I used... Just to keep things consistent, I made sure there were no duplicates on the GebID/Load_Dts combination of columns...
--===== Create 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)

September 6, 2008 at 5:05 pm

#868181
RE: How are records sorted without an order by clause?

Michael Valentine Jones (9/6/2008)
There is nothing preventing them from making a change in the next version or even service pack that changes how it works.
Heck... that true even about stuff...
--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)

September 6, 2008 at 2:32 pm

#868180
RE: How are records sorted without an order by clause?

By the way... just to explain my embarrassing statements... here's why I said them. All I did was change the table name from #t to t and name 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)

September 6, 2008 at 10:20 am

#868161
RE: How are records sorted without an order by clause?

Michael Valentine Jones (9/6/2008)
I have posted examples like this on SQLTeam several times that shows a select from a table with a clustered index that returns results not in cluster...
--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)

September 6, 2008 at 10:10 am

#868159
RE: How are records sorted without an order by clause?

Hey guys... I put some bum dope out about the clustered index method and I've edited out the post I made about it. My fault, I didn't test well...
--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)

September 6, 2008 at 9:58 am

#868158
RE: How are records sorted without an order by clause?

timothyawiseman (9/5/2008)
Jeff, I must be missing something. Why would you want to do the sort in the gui instead of letting the server do that?
I do understand why...
--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)

September 6, 2008 at 9:29 am

#868154
RE: How are records sorted without an order by clause?

Sorry... I put some bum dope out :blush: and deleted this entry.
--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)

September 6, 2008 at 8:11 am

#868143

Viewing 15 posts - 48,421 through 48,435 (of 59,099 total)