This issue has been solved this way: 1) Query engine has some problems dealing with CTE with many selects and groupings at different level. 2) Better...
Hello (first of all, the title is wrong, no "INSERT", i am just talking about a SELECT INTO...sry, i cant edit the title) I am facing a strange...
After a lot of tries I found the reason for this behaviour. I had set the property Disable of each SP to "False" instead of the default "True" and...
Thank You Shehap for your answer. The only task SP1 is executing is a Transaction Log BackUp. I don't even know how I could tell to SP1 to invoke SP2...
Hello I have a problem with scheduling a Maintenance Plan (MP) with 3 subplans (SP). SP1 is scheduled to run hourly, SP2 daily at 7.00 and SP3 on...
Thank You Shehap for your answer. I probably couldn't convey the exact meaning of my request. I'll try with another example. I have TableA with a...
Hello MSDN says: "Indexed views work best when the underlying data is infrequently updated. The maintenance of an indexed view can be greater than...
Separate names with a comma.
