Viewing 15 posts - 316 through 330 (of 333 total)
I found this article at Microsoft which comes pretty close:
http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx
Wilfred
The best things in life are the simple things
May 27, 2008 at 4:25 am
I know this can be fixed by a clustered index, but I want to see what the situation is before I add this index (I'm struggeling with application administrators for...
Wilfred
The best things in life are the simple things
May 27, 2008 at 3:44 am
15TB is not a size to run a "regular" backup, or a fuzzy backuptool with build-in compression. That's impossible to do with that size. You need to change the concept...
Wilfred
The best things in life are the simple things
May 23, 2008 at 2:21 am
exec sp_detach_db ...
exec master.xp_cmdshell 'move ...'
exec sp_attach_db ...
Or do you need a more detailled answer?
Wilfred
The best things in life are the simple things
May 22, 2008 at 6:19 am
data is accessed directly
Wilfred
The best things in life are the simple things
May 22, 2008 at 4:31 am
run a dbcc updateusage({databasename}) to fix inaccuracies caused by sql 2000. This inaccuracy won't happen on 2005, but if you migrate a database to 2005, you have to run this...
Wilfred
The best things in life are the simple things
May 20, 2008 at 1:23 pm
do a dbcc updateusage() first
reindex
and finally update statistics
Wilfred
The best things in life are the simple things
May 18, 2008 at 2:12 pm
great work! thanks
Wilfred
The best things in life are the simple things
May 18, 2008 at 2:09 pm
The only thing what could happen is that an index is gone, no data corruption. Don't you have an test environment?
To be sure: to save your indexes, let Enterprise manager...
Wilfred
The best things in life are the simple things
May 18, 2008 at 4:07 am
Yes, that's the way I do it right now. But I think there must be a way to determine the procedurename. If SQL can tell you the name if...
Wilfred
The best things in life are the simple things
May 18, 2008 at 3:58 am
Here's a space saving tip for your backups: enable the compression flag on the directory where you put your backups (not your mdf/ndf/ldf). It will give some CPU overhead (compression),...
Wilfred
The best things in life are the simple things
May 17, 2008 at 12:36 pm
That's a good one! Is seems Microsoft onnly implemented the @resample option :hehe:
However, it's possible to create a modified sp_updatestats (with the fullscan option). The sourcecode for sp_updatestats is not...
Wilfred
The best things in life are the simple things
May 17, 2008 at 7:36 am
wait till MSSQL2008 🙂
(don't get angry on me, I think a lot of people had the same question)
Wilfred
The best things in life are the simple things
May 17, 2008 at 7:19 am
To my opinion, multiple instances are only useful if you want to prioritize databases. Each instance has it's own settings for memory and CPU usage. So if you're in the...
Wilfred
The best things in life are the simple things
May 17, 2008 at 7:06 am
Yes, use multiple files! It has some advantages, even on a SAN. Because Windows is using a thread for each file, IO management will better perform. Also restoring a database...
Wilfred
The best things in life are the simple things
May 17, 2008 at 7:00 am
Viewing 15 posts - 316 through 330 (of 333 total)