Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,011 through 50,025 (of 59,099 total)

RE: Using VBA to pull SQL data into Excel?

rbarryyoung (6/16/2008)
Jeff Moden (6/15/2008)
rbarryyoung (6/15/2008)
On the other hand, if your sheets need to be resized based on the number of rows returned, then automated "Get External Data" refreshes can be...
--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)

June 16, 2008 at 1:36 pm

#829455
RE: Eliminating Cursors

Pierre Boucher (6/16/2008)
Just did some testing with a 300,000+ record table and following some advice from past post concerning cursor optimization, I was able to achieve the following stats:
CURSOR (LOCAL...
--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)

June 16, 2008 at 1:30 pm

#829451
RE: Parse delimited data in column to multiple columns

Thanks... now we're cooking... I'm on my way to work... I'll take a look at this tonight.
Hmmm... Glad this is SQL Server 2k5... makes it a lot easier to solve...
--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)

June 16, 2008 at 7:26 am

#829198
RE: Concatenate Results Into A Single Field

jcrawf02 (6/16/2008)
rbarryyoung (6/15/2008)
Jeff Moden (6/15/2008)
What's wrong with a good ol' concatenation function that works in 2k and 2k5?
Are we thinking of the same thing? I thought the concatenation 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)

June 16, 2008 at 7:22 am

#829193
RE: Do You Want to Be Right?

jcrawf02 (6/16/2008)
IMHO, if it's going to break in the first strong wind, then it's not completed.
That's more like it and that's part of what I'm talking about...
--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)

June 16, 2008 at 7:06 am

#829183
RE: Do You Want to Be Right?

george sibbald (6/16/2008)
This is how the 'cheap' outsourcers (and some expensive consultancies I cannot mention) work. They tell you they can write your apps quicker and cheaper and it will...
--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)

June 16, 2008 at 7:03 am

#829179
RE: Eliminating Cursors

Wilfred van Dijk (6/16/2008)
Why write some unreadable code in order to avoid cursors?
Why do you think it must be unreadable?
--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)

June 16, 2008 at 7:00 am

#829173
RE: Can any one help to tell the name of hard copy to cross the exam of 70-441 and 70-443 other than Microsoft.

Then, don't buy a book... start working problems posed on this forum. 😉
--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)

June 16, 2008 at 6:22 am

#829156
RE: Eliminating Cursors

Oh no... Correlated sub-queries and their equivelant of Cross Apply are nothing more than a form of hidden RBAR which is usually as slow as a cursor and sometimes slower...
--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)

June 16, 2008 at 6:15 am

#829149
RE: Do You Want to Be Right?

"If we let our employer know of the trade-off between delivery schedule and future-proofing/performance tweaking, they can make an informed decision."
I've found that that usually takes more time than just...
--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)

June 16, 2008 at 6:11 am

#829146
RE: Can I concat a varchar column on a group by clause

Please see the following to get the best performance out of a concatenation function...
http://www.sqlservercentral.com/articles/Test+Data/61572/
--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)

June 16, 2008 at 5:56 am

#829137
RE: How to find last accessed Date of a database ??? on sql server 2000

michaela (6/15/2008)
You would have to monitor your dbs access for a certain period; there is not a straight way to "select last transaction date" from a db.
What I would 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)

June 15, 2008 at 8:08 pm

#829044
RE: Parse delimited data in column to multiple columns

Sorry folks... I've repaired the link that BitBucket was talking about and I've also included it here...
http://www.sqlservercentral.com/articles/TSQL/62867/
--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)

June 15, 2008 at 7:28 pm

#829040
RE: How to find last accessed Date of a database ??? on sql server 2000

Ummm.... SysProcesses has a DBID column...
--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)

June 15, 2008 at 7:21 pm

#829038
RE: Read print output from within a stored procedure by calling another

kinnon_2000 (6/15/2008)
I dont know of a sql server query that could concatinate multiple fields from a tabe, as a join, into a single field. Can that be done?
Absolutely... see...
--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)

June 15, 2008 at 5:33 pm

#829033

Viewing 15 posts - 50,011 through 50,025 (of 59,099 total)