Reputation
1,059
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
7 15
Newest
 Good Answer
Impact
~17k people reached

2d
comment Is better to create a table for each room or make a single table that handles all the rooms in my case?
Separate table is faster and you are not creating a database for each room
Feb
2
comment SQL Server If statement assigning values
Answer is only as good as the question
Feb
2
revised SQL Server If statement assigning values
added 378 characters in body
Feb
2
answered SQL Server If statement assigning values
Feb
2
comment Getting a scan though I expect a seek
@ypercubeᵀᴹ Could have done a lot of things. I am not looking for simpler. Two Or are gone. Or is typically bad for query plans. I get there is kind of a club here and I am not part of the club. But I do this for a living and post what I know has worked. My answers are not affected by down votes.
Feb
1
comment Howto combine UNION with EXISTS?
Extra comma in FROM Note
Feb
1
comment Howto combine UNION with EXISTS?
Are sure it works fine? There is an extra comma.
Feb
1
comment CASE statement with IS NULL and NOT NULL
You are looking for something like the ?: operator in C# and there is no direct equivalent in tsql msdn.microsoft.com/en-us/library/ty67wk28.aspx I suspect you could write a function to do it msdn.microsoft.com/en-us/library/ms186755.aspx
Feb
1
awarded  Good Answer
Jan
31
comment Getting a scan though I expect a seek
@ypercubeᵀᴹ IsUserGotAnActiveDirectoryUser IS NOT NULL is removed. Those two unnecessary remove an OR and remove IsUserGotAnActiveDirectoryUser IS NULL. Are you sure this query will not run fast then the OP?
Jan
31
awarded  Enthusiast
Jan
29
comment Getting a scan though I expect a seek
@Erik Could we like maybe let the OP give it a try? Two OR went away. Do you know for sure this cannot help query performance?
Jan
29
revised Getting a scan though I expect a seek
deleted 8 characters in body
Jan
29
answered Getting a scan though I expect a seek
Jan
29
comment What is the choice - Big Int or Guid?
Kind of depend on what you are going to use it for.
Jan
29
comment Why does adding a TOP 1 dramatically worsen performance?
@usr It is a simple PK join that runs in less one second. Pretty safe bet here.
Jan
29
comment Query with join to a table on a different database need an index
Did you try it without SCHEMABINDING?
Jan
29
comment Unstructured to Structured Data
There are lot of tools for parsing data. But you typically would need to customize for the specific data. This might be a better fit on another SE site. You even have machine learning for classification and clustering.
Jan
29
awarded  Enlightened
Jan
29
awarded  Nice Answer