Viewing 15 posts - 5,506 through 5,520 (of 49,552 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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2015 at 2:09 pm
WayneS (6/23/2015)
Brandie Tarvin (6/23/2015)
Click it and you'll see...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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'...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2015 at 7:20 am
jasona.work (6/23/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2015 at 3:41 am
Viewing 15 posts - 5,506 through 5,520 (of 49,552 total)