Viewing 15 posts - 166 through 180 (of 216 total)
Stewart "Arturius" Campbell (10/28/2011)
> reorganising on a daily basis;
> drop and create regularly?
also, do you have a clustered index on your table?...
October 28, 2011 at 7:41 am
I would have to do some testing, but I wonder if perhaps a clustered index would make these operations more efficient. Hmmm. Interesting question.
Here is what I am...
October 28, 2011 at 7:30 am
Hmmm, that example sounds rather familiar.... 😀
Yes, I attended both of your presentations at PASS. They were both very enlightening. 🙂
October 28, 2011 at 7:09 am
Lexa (10/27/2011)
Evil Kraig F (10/27/2011)
Estimated data volume and cost of traversing just the leaf level vs. running the tree repeatedly.One example cause: http://sqlskills.com/BLOGS/KIMBERLY/category/The-Tipping-Point.aspx
I don't think this is the case...
October 27, 2011 at 8:27 pm
Thank you! I have a very long script (that also takes a long time to run) with many blocks like this.
October 25, 2011 at 10:26 am
Good to hear.... then you should switch :w00t:
Hey, hey! No sales pitches! 😉
October 24, 2011 at 1:29 pm
dajonx (10/24/2011)
Also since you're using the EMC version of SAN-to-SAN replication, are you not doing full backups and just doing transaction log backups?
Actually, the SAN to SAN replication is completely...
October 24, 2011 at 1:25 pm
Actually, if you really want to impress, do the problem as assigned. Then show how much more efficient the non-recursive solution is. For bonus credit, do a little...
October 21, 2011 at 2:44 pm
How is your environment set up?
We use a solution from EMC which mirrors our SAN to an offsite duplicate SAN (which is attached to an offsite duplicate of our physical...
October 21, 2011 at 2:30 pm
If you need a full backup, and you need to transfer it off site like this, then there isn't much you can do.
How about log backups instead? They would...
October 21, 2011 at 2:00 pm
Well, you are right: it depends. However, here is one thought. Buy the beefiest server you can wrangle out of your employer's (hopefully) deep pockets, and then...
October 21, 2011 at 1:55 pm
Joel Spolsky has a good article on using Excel for scheduling work time. You can find it here:
http://www.joelonsoftware.com/articles/fog0000000245.html
He makes the (very interesting point) that Excel has a lot of...
October 21, 2011 at 1:45 pm
Paper_CB_table
BuildingIDMonthYearVendorIDPaperQuantityCardboardQuantity
949 January2011 3 26 ...
October 21, 2011 at 1:29 pm
sqlfriends (10/21/2011)
Processor: Intel(R)Xeon(TM) CPU 3.60GHz 3.60GHz(2 Processors)
Does this mean if I install SQL server on it, I need to buy two Processor licenses,...
October 21, 2011 at 1:18 pm
Viewing 15 posts - 166 through 180 (of 216 total)