Reputation
37,121
Next tag badge:
542/400 score
74/80 answers
Badges
8 97 156
Newest
 Enlightened
Impact
~1.4m people reached

Dec
4
comment calculating the total number of rows in a table - fails when it is a heap - is there any fix?
@AaronBertrand the OP seems concerned about a difference of 7. If that's a problem then this isn't the thing to use. Might as well just use count. As the only way of knowing if it is inaccurate would be to count it anyway and fixing it with updateusage presumably just counts it anyway.
Dec
4
comment calculating the total number of rows in a table - fails when it is a heap - is there any fix?
If you care about 100% accuracy this is not the correct thing to use. (and heaps are tables too)
Dec
2
comment How to combine date and time to datetime2 in SQL Server?
@MikaelEriksson and it has now been implemented msdn.microsoft.com/en-GB/library/mt628058.aspx
Nov
30
awarded  Good Answer
Nov
28
comment SQL Server transferring results slowly in table result set, but instantly with XML
2033 I would guess rather than 2034?
Nov
25
comment OLTP In-memory (Hekaton) in SQL Server Standard edition
They just mean the non in memory technology AFAIK. The way OLTP applications were done in versions before SQL Server 2014.
Nov
24
comment Force Sql server to use index seek in merge join
And even if the clustered index was changed to get a seek the plan still wouldn't have a merge join as it then just becomes a cross join of the two seeked results.
Nov
21
comment Is there any way to tell which derived column failed?
This is what the ErrorColumn property is for. Though mapping that back to a column name seems harder work than it should be...
Nov
20
comment List of Object properties
@MaxVernon Those properties only have any meaning for functions not tables.
Nov
20
comment List of Object properties
@MaxVernon - Works fine for me i.stack.imgur.com/7XL6p.png
Nov
20
answered List of Object properties
Nov
20
comment Datetime Clustered Index Keeps getting fragmented
@Mohfath how have you determined that? To get 70% fragmentation there must be some activity touching old pages and you have also ruled out the other possibilities.
Nov
20
answered Datetime Clustered Index Keeps getting fragmented
Nov
20
comment How can I shred this Extended Events XML as fast as possible?
@MaxVernon - And regarding the OPTION (Optimize FOR (@xml = Null)) you can also use OPTION (QUERYTRACEON 4130 stackoverflow.com/a/3979266/73226
Nov
18
comment How can I shred this Extended Events XML as fast as possible?
Related dba.stackexchange.com/q/30862/3690
Nov
17
comment Order By DateTime With 00:00:00 Last
How do you differentiate between them "not specifying a time" and them specifying a time of midnight?
Nov
14
answered Why does ORDER BY not belong in a View?
Nov
11
answered Can I find out which database is queried on the most?
Nov
11
comment Concatenate with SELECT *
Not really clear what your desired results are here but stackoverflow.com/a/32549568/73226
Nov
9
comment Why is the optimizer doing a table scan vs Index Seek
100 Rid lookups will certainly be a lot quicker than scanning an entire 100 million row table though. Looks like in the OP's case it probably ends up scanning a much greater proportion of the table than it estimated it would before finding 100 rows that qualify. Perhaps as the value is statistically quite common but the qualifying rows are clumped together towards the end of the scan.