Viewing 15 posts - 3,091 through 3,105 (of 49,552 total)
BLOB_EATER (5/10/2016)
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
May 10, 2016 at 3:09 am
Datediff returns the number of whole intervals between the two dates, it will never return a fraction.
Try taking the difference in minutes instead of hours and then dividing by 60.0.
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
May 9, 2016 at 3:35 pm
Where's the join?
FROM <table> [LEFT|RIGHT|INNER] JOIN <table 2> ON <join condition>
[LEFT|RIGHT|INNER] JOIN <table 3> ON .... repeat for the rest of the tables in your query.
So,
FROM person...
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
May 9, 2016 at 6:55 am
support 37266 (5/9/2016)
Sorry, Error is "The multi-part identifier "busidentity.descritpion2" could not be bound."
Probably because it's spelt wrong.
From your earlier query:
JOIN Context ctx ON ctx.currentValue = bi.description2
but also because there's...
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
May 9, 2016 at 6:39 am
Try updating statistics on MyTable, with fullscan
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
May 9, 2016 at 4:46 am
Please don't post multiple threads for the same problem
No replies here please. Replies to http://www.sqlservercentral.com/Forums/Topic1784238-2799-1.aspx
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
May 9, 2016 at 4:35 am
Yes, you have to add all the table joins, but you've specified all of them as inner join (inner is implied if nothing else is specified), the join between timeperiod...
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
May 9, 2016 at 4:34 am
And the name? Or the pattern of the names?
On the basis of the extension, that's a profiler trace file, and that's about all that can be concluded.
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
May 9, 2016 at 2:58 am
Might be useful if you mention the file name, extension, or at least the pattern of the file names.
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
May 9, 2016 at 2:43 am
developerghana (5/9/2016)
the aggregate picture?
Yes, the approach that was suggested 4 days ago.
GilaMonster (5/5/2016)
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
May 9, 2016 at 2:40 am
You could look at DBCC OPENTRAN and the transaction-related DMVs, you know the normal way you diagnose long-running transaction. There's nothing special about the fact that it caused the backup...
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
May 8, 2016 at 5:49 am
Looks like there's a long-running transaction that's keeping the transaction log active (and making it grow).
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
May 8, 2016 at 5:23 am
Actual plans please. The estimated (which is what you posted) are lacking run-time information.
Could you also please post the definitions of the indexes on POLICY_DATA?
Is this a star-schema?
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
May 7, 2016 at 10:43 am
Can you post the execution plans of the queries (the one that's fast, and the slower plans with the added clauses)?
Actual plans please.
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
May 6, 2016 at 12:50 pm
Did you look at just expensive individual queries, or ones that, on aggregate, use a lot of resources? If the former, that's not going to get you very much, you...
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
May 6, 2016 at 12:45 pm
Viewing 15 posts - 3,091 through 3,105 (of 49,552 total)