Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,046 through 45,060 (of 59,095 total)

RE: Question executing a Store Procedure

GilaMonster (2/21/2009)
You can't select from a stored procedure.
Actually, you can...
SELECT *
FROM OPENROWSET('SQLOLEDB','Server=yourserverinstancehere;Trusted_Connection=Yes;Database=Master',
...
--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 21, 2009 at 4:19 pm

#948233
RE: Huge Log File

Do you have any ETL processes on that server?
--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 21, 2009 at 4:06 pm

#948232
RE: Multi thousan insert

What you call a "normal" table structure may be the best or the worst or somewhere in between. You asked a question with no real information to go on...
--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 21, 2009 at 4:03 pm

#948230
RE: OpenRowSet Error

KT8177 (2/20/2009)
I am having some trouble with the following query in one of our production databases:
select *
from openrowset('Microsoft.Jet.OLEDB.4.0'
...
--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 21, 2009 at 3:42 pm

#948229
RE: OpenRowSet Error

Make sure you read this fully
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926
Heh... right... read 19 pages of posts... some with some pretty bad information (not yours). Can you summarize, please?
--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 21, 2009 at 3:41 pm

#948228
RE: How can i split my input variable string and compare?

Edward Boyle (2/21/2009)
Unfortunately, the MaxRecursion Option cannot be applied inside the function, it has to be applied in the Select statement using the function.
That said, I use both Tally...
--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 21, 2009 at 3:28 pm

#948227
RE: Do You Verify Your Database Backups?

I absolutely agree... It's not what you can backup... it's what you can restore. I do at least one "practice" recovery a week and I'm not the System DBA....
--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 21, 2009 at 3:20 pm

#948225
RE: Instrumenting Code

It's a "Catch 22". Only Developers that actually concern themselves with things like performance, scalability, and documented code would ever take the time to add such instrumentation to 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 21, 2009 at 3:17 pm

#948224
RE: Question on pivot tables

Please see the following article... for performance reasons, you may want to reconsider and use simple cross-tabs, instead.
http://www.sqlservercentral.com/articles/T-SQL/63681/
Also, if you'd like a tested answer to your good question, please 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)

February 21, 2009 at 3:06 pm

#948223
RE: "Select Where In" using a parameter?

Jeff Moden (3/31/2008)
GSquared (3/3/2008)
Just did some tests.
The XML version is faster, significantly so, than the Numbers table version, for parsing out a string.
Any bets? 😉 Post your test data...
--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 21, 2009 at 12:03 pm

#948194
RE: Are the posted questions getting worse?

BWAAS-HAA!!! Now you know why I like Tinker Toys... it's real easy to find the red sticks. 😛
--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 21, 2009 at 11:51 am

#948191
RE: Are the posted questions getting worse?

I agree with that... searchs on this forum, ummm... suck. (Sorry, no nicer way to say it). How can we tell the users to do a search when 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)

February 21, 2009 at 10:55 am

#948184
RE: Are the posted questions getting worse?

In high school and before, we'd play a bazillion different card games... mostly Poker, Spades, and HiLoJack. At home, it was Pinochle, graph paper battleship, graph paper road race,...
--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 21, 2009 at 9:53 am

#948176
RE: Are the posted questions getting worse?

GilaMonster (2/21/2009)
After yet another case of someone just posting a query and asking why it was slow (If I could tell, I'd have some really, really happy clients), I'm contemplating...
--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 21, 2009 at 8:23 am

#948166
RE: comma seperated parameter

Ninja's_RGR'us (2/21/2009)
Credit is due and all good, but that still does not answer the question....
True enough... we were waiting on some test data so we could show some tested code.
[font="Arial...
--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 21, 2009 at 8:18 am

#948165

Viewing 15 posts - 45,046 through 45,060 (of 59,095 total)