Viewing 15 posts - 1 through 15 (of 42 total)
i got about 60 indexes in this table
DMVs ?
what is it ?
kindly guide me. pls
November 23, 2015 at 4:10 am
thenx for help,
but dear i can't run exec sp_whoisactive.
i am using SS2k8
November 23, 2015 at 4:04 am
its a live server so i can't wait for more then a minute.
when i run 'select * from sys.dm_exec_requests '
one of row is
Status = suspended
command = INSERT
wait resource...
November 23, 2015 at 3:51 am
Yes, Source server and destination servers are linked.
And i give full path in query eg. delete from [192.168.x.x].database.dbo.table.
Is there any other way to execute such query at specific schedule time...
September 9, 2015 at 4:51 am
Dear PravB4u,
i was not disconnected from database before completing restore process.
As i mentioned in my first post there was a message saying 'process is completed successfully'.
December 2, 2013 at 4:23 am
yes, i think (99%) didn't checked this option.
December 2, 2013 at 4:19 am
Yes, i tried 'Refresh'. nothing happened.
December 2, 2013 at 2:17 am
HI here my restore process.
- I just selected 'Restore Database' from 'database' from MSSMS.
- then i entered name of new database and defined a path...
December 2, 2013 at 2:16 am
done.
thanks man, you are always a life saver....:-)
November 18, 2013 at 3:31 am
thanks man, for giving me such a wonderful code.
I didn't try yet but i think this is the solution of my problem. (in working hours i can't run this...
January 7, 2013 at 2:08 am
there is no query to see fragmentation.
i used to see it in index --> rebuild or index -- > reorganize options.
January 7, 2013 at 1:50 am
Here sp,
ALTER Procedure [dbo].[DBA_DBCC_DBREINDEX_UPDATESTAT]
As
BEGIN
---- Set Recovery Mode SIMPLE
Begin
ALTER DATABASE...
January 5, 2013 at 12:01 am
First of all thanks for reply.
What is the size of some of these tables?
- some of tables are having...
January 4, 2013 at 11:44 pm
sorry,
i don't get you mean by 'did you check for (b)locking in your sqlinstance ?'
🙁
January 3, 2013 at 12:59 am
Viewing 15 posts - 1 through 15 (of 42 total)