Viewing 15 posts - 5,131 through 5,145 (of 49,552 total)
Alvin Ramard (7/31/2015)
I guess I've had enough of this forum for this week.http://www.sqlservercentral.com/Forums/Topic1707595-2799-1.aspx
That's one nice thing about working away from home and on site all week. I haven't had...
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
July 31, 2015 at 2:11 pm
For what it's worth, I'm doing a SQL upgrade tomorrow.
The client and I have spent the last 6 *months* on and off doing the planning, testing, more testing, still more...
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
July 31, 2015 at 2:10 pm
That's not a CTE, that's part of a merge statement.
Do you have 5 merge statements, or are there some CTEs that you haven't shown us?
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
July 31, 2015 at 2:06 pm
You do need to at least be aware of new stuff, even your current employer is stuck in the past. Few reasons:
Firstly, if you're looking for a new job. One...
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
July 31, 2015 at 11:32 am
A seek requires a predicate. A seek is a navigation of an index looking for a value or the start/end of a range. If there's no predicate (as in SELECT...
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
July 31, 2015 at 11:18 am
SQL Server doesn't use the page file. The only time SQL will end up in the page file is if the OS is under memory pressure and SQL doesn't release...
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
July 31, 2015 at 9:04 am
It won't lock the entire table, it'll lock the row being updated.
You can't do a select * with no where clause because there's a row locked. If the entire...
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
July 31, 2015 at 7:13 am
No.
You'll need to either change the procedures and explicitly set the collation on any varchar/char column, or change the procedures and change the temp tables to table variables (not generally...
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
July 31, 2015 at 4:55 am
Can anyone help out here http://www.sqlservercentral.com/Forums/FindPost1706606.aspx? I'm not going to have the chance to write up complex queries til I get home next week, and the nagging is a tad...
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
July 30, 2015 at 3:06 pm
ben.brugman (7/30/2015)
-- As I understood, Scans are full table (index or main).-- So a full scan on a large tables (index) should be prevented.
Not necessarily. If a query needs a...
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
July 30, 2015 at 10:17 am
Nope.
A key/rid lookup is done to fetch columns which are not present in the index used. It's not related to a seek, you can get index scans with key lookups...
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
July 30, 2015 at 9:47 am
Brandie Tarvin (7/30/2015)
And now I'm finding out our databases aren't set up to allow snapshot or read committed isolation. So do I take the overhead hit or not?
Up to you.
Do...
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
July 30, 2015 at 9:21 am
Lookups aren't related to seeks. Lookups will only be > 0 on a clustered index or heap. It's the number of key lookups/rid lookups done.
Updates are any modification. Insert, update,...
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
July 30, 2015 at 9:16 am
AND ((S.createdOn >='2015-06-30 00:00:00' and S.createdOn < '2015-07-31 00:00:00')
OR (SP.modifiedOn >='2015-06-30 00:00:00' and SP.modifiedOn <'2015-07-31 00:00:00'))
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
July 30, 2015 at 9:15 am
Grant Fritchey (7/30/2015)
Brandie Tarvin (7/30/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
July 30, 2015 at 8:08 am
Viewing 15 posts - 5,131 through 5,145 (of 49,552 total)