Wednesday, August 14, 2013

[MS SQL Server] Analysis Manager in SQL 2000

[MS SQL Server] Analysis Manager in SQL 2000

Analysis Manager in SQL 2000

Posted: 14 Aug 2013 04:14 AM PDT

Hi,I am trying to Restore the Cube from .CAB file to Analayis manager on SQL 2000.When i Right Click on server name then it suppose to show Restore database option which i am not able to see on that server.I checked another SQL 2000 Box where i find this Option was available, so Can you please help me to find root cause os this issue in SQL 2000 Analysis Manager.Thanks!

Removing log information from log file by using DBCC SHRINK FILE

Posted: 14 Aug 2013 01:36 AM PDT

Hi All,Can we remove log information from log file using DBCC SHRINK FILE( 'Logicalname', EmptyFile). Can any body please advise !!!!

Fragmentation report

Posted: 13 Aug 2013 08:42 PM PDT

Expertrs,I need to give fragementation report for one of the database.I was executing the below query, however it takes lot of time to excecute.Will it cause any blocking when I execute this query ?SELECT OBJECT_NAME(i.OBJECT_ID) AS TableName,i.name AS IndexName,indexstats.avg_fragmentation_in_percentFROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED') indexstatsINNER JOIN sys.indexes i ON i.OBJECT_ID = indexstats.OBJECT_IDAND i.index_id = indexstats.index_idWHERE indexstats.avg_fragmentation_in_percent > 20Please guide.Thanks.

ASAP -Killed/Rollback - After killing my process in SQL erver its showing hung stage(Killed/Rollback) from 2hours

Posted: 13 Aug 2013 05:40 PM PDT

Hi All,Today I got a request to kill SSIS process which SID is XXX.After killing my process in SQL erver its showing hung stage(Killed/Rollback) from 2hours. When i tryed to kill the process from Windows its showing 2 process with same name. Please let us know how to identify which process need to be kill.Please reply ASAP
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog