Viewing 15 posts - 20,161 through 20,175 (of 39,936 total)
There are a couple articles, but the two that caught my eye were in the paper editions over the last few weeks. For some reason, they're not on the web.
I'm...
April 20, 2010 at 10:44 am
I can commit some time to help review things. Not sure it's a steady per day, but time every week is doable.
If we can outline a structure and build some...
April 20, 2010 at 10:34 am
Thanks for the update, and I am surprised at the difference in the log with the clustered index removal. I would tend to agree that it doesn't necessarily make sense.
I'm...
April 20, 2010 at 9:32 am
I think the silence from PASS is a lack of resources. They are working on transitioning SQL Saturday, which is a higher priority than most other things. Plus they have...
April 20, 2010 at 9:29 am
Tom Brown (4/20/2010)
Tom.Thomson (4/20/2010)
Gianluca Sartori (4/20/2010)
April 20, 2010 at 9:27 am
In terms of confusion, is this just because of restores? Or is there something else?
You ought to be copying all these to another location. You can use the RESTORE HEADERONLY...
April 20, 2010 at 9:24 am
Glad you liked it. I thought it was pretty funny when I saw it as well. I wonder if it worked at all, or if they ran down the street...
April 20, 2010 at 9:18 am
I agree that you need Windows Auth here for good auditing. If you allow people, including sysadmins, to use SQL Auth, all you will get is the login they used...
April 20, 2010 at 9:10 am
Ray K (4/19/2010)
As the proud owner of a Toyota Highlander Hybrid, I resemble these remarks! 😛
How do you like the Highlander hybrid? Good mileage for you?
April 19, 2010 at 9:08 pm
Ray,
It was a good question, and I think the answers are pretty well qualified as to what people do.
How do you qualify "mostly with SQL Server" if you're a...
April 19, 2010 at 9:07 pm
I added some levels to the count. Didn't announce it since they really only applied to me for now. Jeff/Lynn/Gal soon.
April 19, 2010 at 2:54 pm
No effect here, but I know a few people that have cancelled trips to PASS Europe because they can't get flights.
April 19, 2010 at 1:59 pm
I'm not sure it will cause problems if you have the time and resources to do it, but there's no need for rebuilding all indexes.
Michelle's script, Hot linked: http://sqlfool.com/2009/06/index-defrag-script-v30/, works...
April 19, 2010 at 1:39 pm
George has the best advice. Use the configuration manager to assign the account. It will assign the permissions needed.
April 19, 2010 at 1:37 pm
I don't think BCP/Bulk Import would help here.
If space is at a premium, I would look to resolve that issue. Isn't data likely to grow? Meaning more log space needed?
You...
April 19, 2010 at 12:39 pm
Viewing 15 posts - 20,161 through 20,175 (of 39,936 total)