Viewing 15 posts - 36,001 through 36,015 (of 49,562 total)
It's part of the internals of SQL that controls query execution. You don't use it directly. SQL does.
Please download books online, read through it and then ask any questions that...
November 6, 2009 at 2:55 pm
ramadesai108 (11/6/2009)
What do i need to check/uncheck in Execution plan to set Full Table Scan OFF?
LOL. Performance tuning would be easy if one could do that.
What he's suggesting you to...
November 6, 2009 at 2:53 pm
Parameter sniffing?
Stale statistics?
November 6, 2009 at 2:50 pm
Steve Jones - Editor (11/6/2009)
Grant, see if someone will post an NDA summary in the newsgroups. Would be nice for those of us stuck in the trees.
Mail Ed and ask...
November 6, 2009 at 12:21 pm
jocampo (11/6/2009)
Why a composite and not three different Indexes?
Because a 3-column index means that SQL can do a seek on all three columns in one go. 3 individual index means...
November 6, 2009 at 10:22 am
jcrawf02 (11/6/2009)
Geek of the Week is too uppity to mingle in person, eh?:-P
His high eliteness is busy taking notes on the session content. 😉
It sounds from the blogging like there...
November 6, 2009 at 10:07 am
Excellent. Glad to hear it.
November 6, 2009 at 9:46 am
GSquared (11/6/2009)
If I'm not mistaken, PASS was Mon-Thu, right?
Mon-Fri. Main conference was Tues-Thurs, pre-con on monday, post-con on friday.
Grant says Hi.
November 6, 2009 at 9:45 am
Inner join, no. Left/right join, they're two different queries with two different results, so performance isn't the issue....
November 6, 2009 at 12:43 am
MANU-296622 (11/5/2009)
In 2005 also it doesnt allow you to attach database with more than one log file using sp_attach_single_file_db.
Which is deprecated anyway. Use CREATE DATABASE ... FOR ATTACH
November 6, 2009 at 12:38 am
I do, I think (wrote them a week ago and am currently brain-dead tired after PASS). Probably not in the detail hyou want. Any specific questions, ask them in the...
November 5, 2009 at 8:10 pm
Try this.
Create a new transactional publication. Run sp_repldone. Drop the publication
November 5, 2009 at 8:09 pm
Shark Energy (11/5/2009)
Would a query that sometimes takes 10 minutes, then other times takes 45 minutes actually need tuning?
Absolutely. In fact, I'd venture to say that eratic performance is...
November 5, 2009 at 8:05 pm
Just for your info, these errors are usually (not always but usually) the result of direct updates done to the system tables on SQL 2000. Is this an upgraded database?
November 5, 2009 at 11:00 am
Viewing 15 posts - 36,001 through 36,015 (of 49,562 total)