Viewing 15 posts - 5,131 through 5,145 (of 49,571 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...
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...
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?
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...
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...
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...
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...
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...
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...
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...
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...
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...
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,...
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'))
July 30, 2015 at 9:15 am
Grant Fritchey (7/30/2015)
Brandie Tarvin (7/30/2015)
July 30, 2015 at 8:08 am
Viewing 15 posts - 5,131 through 5,145 (of 49,571 total)