Viewing 8 posts - 106 through 113 (of 113 total)
Login failed for user 'abc\mossadmin'. [CLIENT: 10.10.10.10]
how to find which to database the user abc\mossadmin trying to connect? Because, by running sp_who2, I'm sure that the user abc\mossadmin is NOT...
March 9, 2010 at 1:10 pm
Is that when you run it from your database or from master?
NO. It's against User database.
I ran the below query in User database & able to get all indexes
select i.*...
March 9, 2010 at 12:16 pm
Could you please tell me the list of services that need to be stooped on DR MOSS Server?
I executed SP_WHO2 on DR server and getting below results:
55 sleeping...
March 9, 2010 at 12:10 pm
Declare @DBName varchar(50)
Set @DBName = 'YOURDBNAME'
Select Db_name(ps.database_id) as DBName,object_name(ps.object_id) as TableName,I.name as IndexName
,sum(isnull(ps.avg_record_size_in_bytes,0) * isnull(ps.record_count,0)) as IndexSizeBytes
...
March 9, 2010 at 11:19 am
I think you may need to do some investigation as to why your indexes are fragmenting so fast. Are you doing database shrinks?
I'm NOT doing any database shrinks and after...
March 8, 2010 at 5:37 pm
Do you rebuild all indexes every time? If so you may want to implement a selective rebuilding script that only rebuild the indexes that really need rebuilding.
Yes, I'm using a...
March 8, 2010 at 11:25 am
we have log shipping for production database and we do index rebuild every 2 weeks and huge log of size 15 GB is generating and it's taking several hours to...
March 8, 2010 at 11:00 am
I figured out why index_id>0. Because, A heap has a row in sys.partitions with index_id = 0 and we cannot defrag a heap.
But why page_count>1000? what benefit,we will...
March 8, 2010 at 2:46 am
Viewing 8 posts - 106 through 113 (of 113 total)