Viewing 15 posts - 286 through 300 (of 360 total)
Paul DB (11/18/2008)
Petition
I wish there was a collection of these articles we could give to newbies. I'm sure that most are already written and just waiting to...
November 18, 2008 at 8:59 am
This is a Kerberos delegation issue because you don't have the appropriate SPN's set in Active Directory for MS SQL Service on both or either servers.
It's a frustrating thing.
It's most...
November 11, 2008 at 8:38 pm
Our windows team patched thousands of systems with no troubles that I know of on MSSQL.
~BOT
November 11, 2008 at 8:32 pm
My advice:
Forget building a cluster out of a standalone.
Build the new 2 node cluster and make it SQL 2005 (since you posted in the 2005 forum). Set up...
November 11, 2008 at 8:17 pm
I don't have a magic number, but it really does depend on where your bottleneck shows up.
Here are a few bottlenecks to watch out for, some are deal-breakers, some are...
November 11, 2008 at 8:05 pm
Besides not doing that at all... my only advice would be that if you did... take a full backup afterward to start a new recovery chain.
I'm shocked at the number...
November 11, 2008 at 7:42 pm
In these cases, rather than grant any sort of elevated access, I write a wrapper stored procedure 'with execute as' a priviliged account. This way they can only see...
November 8, 2008 at 8:13 am
LOL,
yes, yes... touche
In those cases when I'm strapped for extra 208k of disk, I usually drop the clustered index.
~BOT
November 8, 2008 at 8:05 am
Matt Miller (11/7/2008)
create table fragtable (gid uniqueidentifier default newid() primary key clustered, fun int)
create index bob on fragtable(fun)
go
insert fragtable(fun)
select rand(checksum(newid()))*75
from sys.all_columns
go 30
dbcc showcontig('fragtable')
ALTER INDEX bob...
November 8, 2008 at 7:18 am
I do know from extensive testing, that reorging an index of less than 1000 pages is pointless, but rebuilding will show reduced fragmentation
I'm curious.
From the DMV, what's the value of...
November 7, 2008 at 1:33 pm
Gaby A. (11/7/2008)
November 7, 2008 at 10:19 am
SQL Books online is a great tool you should consider using.
http://msdn.microsoft.com/en-us/library/aa174541(SQL.80).aspx
This is a SQL 2005 forum, btw.
~BOT
November 7, 2008 at 10:08 am
It looks to me like you'll be dropping and recreating indexes.
I can't see a way to avoid it.... test it first.
~BOT
November 7, 2008 at 10:02 am
using that DMV you can get some more information that is useful such as the page length of the index, , partitioning, and you can look in syscolumns and...
November 4, 2008 at 8:03 pm
Viewing 15 posts - 286 through 300 (of 360 total)