Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,436 through 48,450 (of 59,099 total)

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

Sorry... I overlooked the part about the "client's hosted app"... does that mean it's a 3rd party app that the client cannot change?
--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 5, 2008 at 8:46 pm

#868105
RE: State County City Problem

Hiearchy can be a good thing... but I don't believe the op can change the structure of the tables. 😉
CS... Please pardon me if I'm wrong, but this looks...
--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 5, 2008 at 8:25 pm

#868100
RE: using Datediff function between Rows

Phil Factor (9/25/2007)
Jeff Moden (9/25/2007)
Phil's method only works if the ID is contiguous and sequential.
Er.. The temporary table had an identity column in there that was intended to ensure precisely...
--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 5, 2008 at 7:17 pm

#868094
RE: SQL Performance with Aggregete Sum on LOTS of data

spiegdon (10/15/2007)
Thanks very much for the quick response, I am sorry for the long delay in ack.
We ended up going with the cursor approach as all we are...
--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 5, 2008 at 7:09 pm

#868092
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Thanks, Pam... I appreciate your feedback. And, cool Avatar! Welcome to SQLServerCentral.com! 🙂
--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 5, 2008 at 6:54 pm

#868091
RE: Cursor

Spot on, Gus. 🙂
--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 5, 2008 at 6:51 pm

#868090
RE: Importing CSV files without knowing destination schema

rohanverma (9/3/2008)
Hi,
Thank you for the above script, I used the above script and it worked just fine. My question is for the part:
--===== Query one of the files by using...
--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 5, 2008 at 6:34 pm

#868088
RE: Opendatasource problems with excel

I mean C:\temp on the SQL Server that's doing the reading.
--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 5, 2008 at 6:30 pm

#868086
RE: Porcess Range IDs

dsegalles80 (9/5/2008)
Jeff Moden
I gotta ask... why do you need to do this? What is the purpose of this?
This is used for update by batch as per requirement on our...
--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 5, 2008 at 6:25 pm

#868085
RE: Problem with DeadLock Transaction

jfbergeron (9/4/2008)
It is actually a requirement to try importing the data as is, because we want to know if errors occured. That update will happen in 100 stores, and we...
--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 5, 2008 at 6:12 pm

#868084
RE: Quick and dirty way to make a very large table

You still haven't answered the question though... why would anyone create such a table of 1 gig of almost nothing but NEWID()'s?
--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 5, 2008 at 6:08 pm

#868083
RE: Restore with no backup

Two way street here... 😉 What did you finally do to fix it?
--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 5, 2008 at 6:06 pm

#868082
RE: Understanding Index defragmentation

Heh... sorry Gail... couldn't believe my eyes at first. Now I get what you were trying to say.
--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 5, 2008 at 5:54 pm

#868081
RE: Auto update table with correlated subquery

Thanks Hans, I appreciate the feedback... I had a great weekend, too. Heh... "Honey-Do" list and other labors of love.:D
The reason I'm so adamant about testing this is 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)

September 4, 2008 at 10:32 pm

#867554
RE: Auto update table with correlated subquery

blom0344 (9/4/2008)
From my point of view the performance issue is secondary , since we're talking in the range of 5000 - 100000 records for a table. With SQL server 2005...
--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 4, 2008 at 8:38 pm

#867534

Viewing 15 posts - 48,436 through 48,450 (of 59,099 total)