Viewing 15 posts - 226 through 240 (of 341 total)
Great article. And nice example use of bitmask for searching.
If you approach the bitmask column for the purpose of high frequency searching, really for "reporting" then it does...
The more you are prepared, the less you need it.
May 22, 2009 at 7:20 pm
...Mirroring is one of those features.
Sure you might have known about it, but until you get it going, and realize, how little effort it really takes, and the comfort...
The more you are prepared, the less you need it.
May 17, 2009 at 11:37 am
That's why you need an automated script. in a 24/7 shop, it does not make sense to do manual checks. Automate the process, that includes checking the level of defrag....
The more you are prepared, the less you need it.
May 12, 2009 at 7:27 pm
Are you saying that for the same product, it is different depending on the year?
if so, then you might want to look into how to manage slowly changing dimensions.
If...
The more you are prepared, the less you need it.
May 11, 2009 at 10:14 am
For 24/7 systems, I highly recommend running a defrag at least daily. And I've had some databases that really needed it done more frequently.
If you have a solid procedure,...
The more you are prepared, the less you need it.
May 11, 2009 at 10:00 am
Great article. Looks like for now, TDE is a one way process. Select wisely!
The more you are prepared, the less you need it.
May 4, 2009 at 10:20 am
Thanks for a great review. For those of us who have been using sysprocesses as well as sp-who, sp_who2 for along time, it never hurts to have a review....
The more you are prepared, the less you need it.
May 1, 2009 at 7:20 am
Great write up. Thanks for taking the time. Your Organizational Culture comment really caught my eye, such as:
This was so contrary to the corporate culture and belief system...
The more you are prepared, the less you need it.
April 27, 2009 at 2:57 pm
Have to agree, set based should be the required standard, with using server side cursor requiring an explaination as to why a set based approach is not warranted.
Folk legend has...
The more you are prepared, the less you need it.
April 27, 2009 at 2:35 pm
It's great! the next great villian... Plunderpal.
What started as a science experiment, PlunderPal soon realized its own AI, and broke free from human control. It then began...
The more you are prepared, the less you need it.
April 22, 2009 at 7:10 am
Alex,
Nice article and thanks for taking the time to write this up.
And while SSRS's multi-valued approach is a bit laking, I think we all would choose having this option over...
The more you are prepared, the less you need it.
April 21, 2009 at 10:14 am
Follow up:
Let's all thank Drew for the contribution. Monitoring is a necessary, but a neglected topic.
Getting a centralized monitoring server is a real must, even for smaller shops.
For those...
The more you are prepared, the less you need it.
April 20, 2009 at 8:41 am
Step One - get a server.
Most people need to see it to believe it. No matter what the topic.
So, rather than spend time justifying a new server, I take the...
The more you are prepared, the less you need it.
April 20, 2009 at 8:31 am
A big thanks to Brian, and all the others that give back and contribute. Contributing to make society a better place takes many forms. And thankfully, I see signs that...
The more you are prepared, the less you need it.
April 20, 2009 at 7:34 am
This sounds like it could have many uses. Thanks for the contribution.
The more you are prepared, the less you need it.
April 8, 2009 at 7:44 am
Viewing 15 posts - 226 through 240 (of 341 total)