Viewing 15 posts - 5,506 through 5,520 (of 49,571 total)
John Mitchell-245523 (6/24/2015)
Might be worth referring to Gail's article[/url] on catch-all queries.
The one on multiple execution paths[/url] may be more relevant.
June 24, 2015 at 3:46 am
TheSQLGuru (5/18/2015)
GilaMonster (5/18/2015)
TheSQLGuru (5/18/2015)
And I agree, what about the SORT makes it so bad you want to get rid of it?
Personally I can't even see where a merge join would...
June 24, 2015 at 2:44 am
Shouldn't be. Access violations are related to illegal memory reads.
Make sure your patches are up to date and if the problem continues consider calling Microsoft Customer Support, though since 2008...
June 24, 2015 at 2:43 am
ken.trock (6/23/2015)
So my question is how often do we have to do this?
As often as necessary. I've heard of a case where that was every hour.
Nothing wrong with having...
June 23, 2015 at 2:53 pm
I'll probably be looking to get new kittens/cats later this year. My Siamese died late May, completely unexpected, out of the blue. One day she was fine, next day very...
June 23, 2015 at 2:09 pm
WayneS (6/23/2015)
Brandie Tarvin (6/23/2015)
Click it and you'll see...
June 23, 2015 at 2:00 pm
Alvin Ramard (6/23/2015)
leetrueman (6/23/2015)
CREATE NONCLUSTERED INDEX idx_Transactions_TransTime
ON dbo.transactions (trans_time, SiteID)
INCLUDE (transactionID,siteID,areacode,gamename,sitename)
GO
is reporting
Msg 1909, Level 16, State 2, Line 1
Cannot use duplicate column names in index. Column name 'SiteID'...
June 23, 2015 at 1:13 pm
Haven't forgotten. Just in the middle of a large one for Tony, and a couple presentations to write up.
June 23, 2015 at 1:12 pm
Nope, they're extra indexes, they won't mangle, change or otherwise affect the data.
They may take some time to run, so make sure that you run them during a maintenance window...
June 23, 2015 at 8:15 am
Cool, thank you.
Ok, definitely index-related. You just don't have the indexes needed to support this query. With so few indexes, I'm not too concerned about adding more.
Add these indexes and...
June 23, 2015 at 7:27 am
Dataset parent latch is taken when SQL's doing a parallel table scan. you're probably either missing indexes or have queries which are written so that they can't use indexes.
To be...
June 23, 2015 at 7:20 am
jasona.work (6/23/2015)
June 23, 2015 at 6:36 am
sault (6/23/2015)
If the transaction logs are never part of the database then what is in them that brings the database up to date when they are restored?
I didn't...
June 23, 2015 at 6:21 am
Management Studio is what you must have used to get the execution plan. There's a window called Object Explorer (open by default). It's a tree-structure of your database.
Navigate the tree...
June 23, 2015 at 4:12 am
I need to know what indexes exist on the tables involved in this query.
Open up Management Studio, navigate in Object Explorer to the tables and script out the indexes.
June 23, 2015 at 3:41 am
Viewing 15 posts - 5,506 through 5,520 (of 49,571 total)