Thanks for suggestion, at the end i came out simply using 1807 flag....
Hi everyone, I have a new dev machine with Windows 7 x64; to work on projects still using SQL Server 2000, i've setup a virtual machine with...
Thank you very much!
Thanks for help! I simply had performance issue with correlate subqueries in the past and so if possible i try to avoid them... it's not a so remote...
Hi, I'd need help on how to write a select query. We have an Orders tables (simplifying): Orders: OrderID UserID OrderTotal I should get the first...
Now is all clear... Many thanks againg!
Thanks for your suggestion. The messageType stored value can be only one; can't be a combination of the flags (i.e. each Row is of a unique...
Thank you for the advice!
Hi, I have to decide the way to perform a where on a field of a table using bitwise operation. I'll try to explain: I have a table with an indexed...
Did you already include that part in the code so far? You're executing dynamic SQL through sp_ExecuteSQL - which is a wise decision in itself, but...
I agree with you, I thought that the filtering subquery should be more performant in the inner query... But trying it on our actual server it's...
I've checked again the indexes, all the fields included in JOINS and in WHERE clauses are indexed... I've looked at Actual Execution Plan of the...
Hi, after some test on production server, unexpectedly the first one (with the subquery that filters the users in the inner query) is faster then...
Ok, I'll try and then I'll let you know which is the best solution... Thank you!
Hi, the query works great, but I have a performance problem... I have to restrict the users to get the most recent orders from. I've adjusted the...
Thank you very much, it works perfectly!
Hi everyone, I have a problem in writing a SELECT query for a stored procedure... I have two tables, Users and Orders which fileds are (simplifying):...
Separate names with a comma.
