Reputation
1,197
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
2 11 30
Impact
~87k people reached

  • 0 posts edited
  • 2 helpful flags
  • 81 votes cast
Aug
29
comment Strange behaviour with Computed Columns in SQL-Server
And do you know why the QO would use the non-persisted column in my example above?
Aug
29
comment Strange behaviour with Computed Columns in SQL-Server
Thanks for the answer Jack. If it persisted in the index, then how does the index know if the underlying value is changed?
Aug
29
comment Strange behaviour with Computed Columns in SQL-Server
For those that have the 70-433 book, the quoted text is at the top of page 111.
Aug
29
asked Strange behaviour with Computed Columns in SQL-Server
Aug
26
comment What are the performance implications of running multiple smaller DBs instead of a single larger DB on a server?
How big are the databases? How many concurrent users of the system are there?
Aug
25
comment SQL Server Join/where processing order
Thanks for the links. Once I get it clear how it work's I hope I will write better queries etc :)
Aug
25
comment SQL Server Join/where processing order
Thanks for the link. Once I get it clear how it work's I hope I will write better queries etc :)
Aug
25
comment SQL Server Join/where processing order
Why is distinct..join bad? Links would be great, thanks (googling myself at the mo)
Aug
25
accepted SQL Server Join/where processing order
Aug
25
comment SQL Server Join/where processing order
Actually @Gbn has got it below :)
Aug
25
comment SQL Server Join/where processing order
That's what I was thinking of. I couldn't remember the exact details of it though, thanks. In the case of the SO question I mentioned in the original post (no indexes and not allowed to create them) then would something like my approach work do you think?
Aug
25
comment SQL Server Join/where processing order
Are you sure? I could swear that the processing of tables comes before anything else (eg. where), so in theory the two would generate two different query plans (although not always) At book i'm thinking of is at work so i'll edit the above tomorrow morning when I have had chance to double check my facts
Aug
25
asked SQL Server Join/where processing order
Aug
22
accepted SQL Server Service Broker and Deadlocks
Aug
22
comment SQL Server Service Broker and Deadlocks
thanks @gbn :).
Aug
22
comment SQL Server Service Broker and Deadlocks
thanks for this :) I thought as much, but it was a long session earlier and my brain is quiet functioning as it should ha!
Aug
22
comment SQL Server Service Broker and Deadlocks
Oh and could someone with enough rep create a "service-broker" tag please :) Quote from: msdn.microsoft.com/en-us/library/ms166071.aspx
Aug
22
asked SQL Server Service Broker and Deadlocks
Aug
21
accepted Health checking via Database Mail in SQL Server
Aug
20
accepted SQL Server Checklists