Viewing 15 posts - 3,661 through 3,675 (of 5,841 total)
I think Perry has the best recommendation here - snapshots on the mirrored databases.
January 31, 2011 at 7:46 am
Given that you have massive volumes of data to work with and yet are asking basic questions I really must encourage you to get a professional to help you with...
January 31, 2011 at 7:45 am
BrainDonor (1/27/2011)
January 28, 2011 at 10:14 am
1) In my experience 'search' type stored procedures are often best done as dynamic sql. Non-trivial to construct but WAAAAYYYYYYY more efficient. Beware SQL Injection if you go...
January 28, 2011 at 10:12 am
The BEST way to manage LINKED SERVERS is to never use them at all! They do LOTS of unfortunate things. The way to avoid them is to put...
January 28, 2011 at 10:10 am
It is usually best to let sql server handle using space. Why would you want to 'reclaim' unused space? Isn't it likely to just get requested by the...
January 28, 2011 at 10:08 am
shifty1981 (1/26/2011)
TheSQLGuru (1/26/2011)
shaun.stuart (1/26/2011)
January 28, 2011 at 6:55 am
Just gotta love the things you can do with a Numbers table!
January 28, 2011 at 6:44 am
LutzM (1/26/2011)
Would it be possible to post the actual execution plan?
Also, would you please post the actual execution of a query that...
January 26, 2011 at 2:19 pm
shaun.stuart (1/26/2011)
January 26, 2011 at 10:08 am
Assuming there is an index on street and cityzip fields on c, it would seem that an index seek and bookmark lookup would be the "really fast" plan. You...
January 26, 2011 at 10:03 am
ahh. I took "...manipution have done in sql..." to mean DML only. 🙂
BTW, I consider $1500 (list) VERY inexpensive when it comes to being able to find/unwind "holy...
January 25, 2011 at 9:15 am
1) perhaps you can use a plan guide to force a particular plan (i.e. the one that runs fast OUTSIDE of SSIS). the key is the sort - that...
January 25, 2011 at 9:10 am
moosamca (1/24/2011)
Thanks for your guidance, Let me hard code the query and see how the query plan is coming up. I have one more quick question here. I knew...
January 25, 2011 at 7:57 am
GilaMonster (1/24/2011)
Unless you had a trace or trigger present when the changes were made, you cannot go back and get details of what happened.
Not true. If you have all...
January 25, 2011 at 7:54 am
Viewing 15 posts - 3,661 through 3,675 (of 5,841 total)