Viewing 15 posts - 1,621 through 1,635 (of 11,678 total)
Luis Cazares (10/15/2014)
Grant, Congratulations on being elected as a member of the PASS board!
+1
Congrats. Now go kick *ss in that board 🙂
October 15, 2014 at 1:24 pm
ranimsql (10/15/2014)
I have the same problem.. when I moved the package from my local to Test server and specified the job to look at the XML configuration it is still...
October 15, 2014 at 1:21 pm
TheSQLGuru (10/15/2014)
It may just be a butterfly flapping his wings in China, but I am getting routine crashes on SSC.com forums using IE10.0.9200.17054.
Yeah, performance hasn't been to great lately.
October 15, 2014 at 1:19 pm
paul.knibbs (10/15/2014)
October 15, 2014 at 4:21 am
Apparently it was not "none of the above".
I wonder if some of the QotD authors actually run their queries.
October 15, 2014 at 3:40 am
cbrammer1219 (10/14/2014)
October 14, 2014 at 10:49 am
Steve Jones - SSC Editor (10/14/2014)
Is quoting and general access slow for anyone else today?
It was slow a few days ago, now it is reasonable.
October 14, 2014 at 7:31 am
KoldCoffee (10/14/2014)
OK. The key here is you're telling me that indexing is how I solve this particular ETL problem.
Yes, because adding 1 index and tuning 6 other existing indexes by...
October 14, 2014 at 7:00 am
ganteng1 (10/14/2014)
Thank you so much. It fixed the problem. I really appreciate it.
No problem, glad to help.
October 14, 2014 at 5:57 am
roblew 15918 (10/14/2014)
partial re-writes of stored procedures on how the aggregations are done.
According to BOL, this should cause a recompile of the query plan.
Execution Plan Caching and Reuse
The conditions that...
October 14, 2014 at 4:45 am
After looking 5 seconds at your execution plan:
* you get a hint for a missing index. It's on a table that currently has a table scan with a cost of...
October 14, 2014 at 4:39 am
Viewing 15 posts - 1,621 through 1,635 (of 11,678 total)