Reputation
39,369
Next tag badge:
572/400 score
77/80 answers
Badges
8 104 164
Newest
 Nice Answer
Impact
~1.6m people reached

Apr
27
comment Where can I find the SQL Server to download?
blogs.technet.microsoft.com/dataplatforminsider/2016/03/31/…
Apr
27
comment LOB_DATA, slow table scans and some I/O questions
@SeanGallardy yep, seems like it then :-)
Apr
27
awarded  Enlightened
Apr
27
comment LOB_DATA, slow table scans and some I/O questions
@sean where do you get 10 from? The question States 1000. Each Lob can be split over multiple pages. So presumably in this case on average 13. Select * means all columns will be returned of course but if some aren't needed just use an explicit column list and don't select them (better practice anyway). I don't see partitioning the table as relevant.
Apr
27
awarded  Nice Answer
Apr
27
comment Trying to find a MIN() workaround for an indexed view
You're probably better off just posting your whole query and asking for ways to optimise it given that your solution isn't possible.
Apr
27
comment LOB_DATA, slow table scans and some I/O questions
@SeanGallardy I don't see how that would help. The Lob data is already stored off row in a different allocation unit and only brought back when that value is needed so it is already partitioned much as you suggest.
Apr
27
comment Trying to find a MIN() workaround for an indexed view
This isn't possible for the reasons described here stackoverflow.com/q/2134461/73226. How many rows do you have in the base table per GUID on average? I.e. What is a typical count value from your grouped query?
Apr
27
comment Implicit conversion warning despite persisted computed column vs. performance hit from UDF in persisted computed column definition
This doesn't look like an answer to your question.
Apr
27
comment When are computed columns computed?
What about if they are persisted but the query plan uses an index that does not cover that column? I'm not sure whether you would get a lookup or if it would just compute it on the fly and can't currently test it.
Apr
26
revised LOB_DATA, slow table scans and some I/O questions
added 8 characters in body
Apr
26
answered Is there a list what datatype corresponds to the system_type_id in Sys.columns
Apr
26
comment I do not see much performance between implicit & explicit transactions
On what basis did you expect to find any difference?
Apr
26
revised I do not see much performance between implicit & explicit transactions
added 946 characters in body
Apr
26
revised SQL Simple Question
added 63 characters in body
Apr
26
comment Identity column jump in sql server restart
@AliRazeghi I haven't had much call to use it. Conceptually I don't see why running a startup procedure would be any different from any running any other code that is external but designed to run at server startup though. Permissions should prevent anyone unauthorised from creating procs in master and setting this option. But in any event the rest of my answer indicates that the OP doesn't need to do this anyway.
Apr
26
answered Identity column jump in sql server restart
Apr
26
comment What is the best way to import this non-standard text file into SQL Server?
I'd use a script component as a source and just loop through the lines in the file in C#. The code to parse the columns out of each line should be pretty straightforward.
Apr
25
revised Need help with null field values
edited tags
Apr
25
revised The index columns in sys.index_columns different from what are in the index
added 11 characters in body