Reputation
972
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
3 10
Impact
~5k people reached

  • 0 posts edited
  • 0 helpful flags
  • 103 votes cast
12h
comment SQL Server: dm_exec_requests.wait_time vs. dm_exec_sessions.last_request_end_time
Books Online for sys.dm_exec_requests.wait_time says "If the request is currently blocked, this column returns the duration in milliseconds, of the current wait. Is not nullable." Therefore, you are seeing an elapsed time of 28 minutes, and the last wait (not sum of all waits) is 629ms. Paul Randal has a nice blog post on capturing wait stats over a period of time that may be useful: sqlskills.com/blogs/paul/capturing-wait-statistics-period-time
13h
comment Identity column in columnstore index
Is the identity column on the original table also your clustered index? If so, SQL Server will automatically include that column in any non-clustered columnstore index, even if you don't explicitly ask for it. This is somewhat similar to the way that clustered index columns will be included in a non-clustered b-tree index, but the data will be stored as actual compressed columnstore segments in this case. See dba.stackexchange.com/questions/103722/… for more info.
13h
comment Find data size of table for several identical databases on a instance
Cool, I hadn't used QUOTENAME before. Very useful here. And fun to see a different approach to the problem.
13h
revised Find data size of table for several identical databases on a instance
added 320 characters in body
13h
answered Find data size of table for several identical databases on a instance
2d
comment What does the FullAccess. infront of table mean in SQL Server query?
@JuanVelez Glad to hear that helped to resolve the mystery. There are two different objects, one under dbo and one under FullAccess. An object can only be in one schema (as you can tell by sys.objects having a unique object_id and a single schema_id column for the object)
2d
comment What does the FullAccess. infront of table mean in SQL Server query?
Can you post the results of the following query? SELECT name, OBJECT_SCHEMA_NAME(object_id) AS schema_name FROM sys.objects WHERE object_id = OBJECT_ID('FullAccess.ReceivedClaimFact') I think it's going to be difficult for us to help you without further info.
2d
answered What does the FullAccess. infront of table mean in SQL Server query?
Aug
30
awarded  Self-Learner
Aug
26
accepted Finding distinct rows across two tables: Full Outer Join more efficient than Union?
Aug
26
comment Finding distinct rows across two tables: Full Outer Join more efficient than Union?
Thanks for the reminder, Aaron. Each table already had distinct values in our specific case, but I had not explicitly recognized this assumption and I agree that it's important to consider.
Aug
26
comment Finding distinct rows across two tables: Full Outer Join more efficient than Union?
Great point Paul. In our specific case, the columns involved are non-nullable and there are no duplicates within each individual table. So the two approaches are logically equivalent in our specific case, but thanks for pointing out that they are not always the same more generally!
Aug
26
asked Finding distinct rows across two tables: Full Outer Join more efficient than Union?
Aug
12
answered Sum currencies excluding duplicatied records
Jul
29
comment Why is table variable forcing an index scan while temp table uses seek and bookmark lookup?
Great answer. A small tangential question: when would a loop join not be possible? I can easily think of an example where forcing a hash or merge join will result in "Query processor could not produce a query plan because of the hints defined in this query" (any join with no equality predicate), but it seems like a loop join could serve as the physical implementation for any logical join. (Obviously it might be a bad choice for performance in some cases though.)
Jul
29
revised Guidelines for full-text index maintenance
deleted 2 characters in body
Jul
29
revised Guidelines for full-text index maintenance
added 61 characters in body
Jul
29
accepted Guidelines for full-text index maintenance
Jul
29
answered Guidelines for full-text index maintenance
Jul
23
answered Category entity relationship / subtype relationships design