Viewing 15 posts - 721 through 735 (of 1,179 total)
You can use some of the 3rd party tool to indentify the transaction details.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 6, 2010 at 4:59 am
MAX DOP will not affect anything it is still dynamic and intend to use max available processor; it may also use fewer processor depnding on system workload.
see the extract from...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 4, 2010 at 3:22 am
Andreea
I would like to drow your attention that when you restart the server tempdb will shrink and when the space is required it has to expand. Now expanding the tempdb...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 4, 2010 at 3:17 am
I do not see much issue with respect to the fragmentation of the index. If you consider the largest page count in your repot than it will be around 10000...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 4, 2010 at 1:57 am
If the database size is small than you can go with the 'Snapshot Replication' to achieve your goal. Which is also easy to maintain compare to other soultions.
Backup and restore...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 4, 2010 at 1:37 am
Window authentication is better option and should be in the same domain; if not trusted domain should be there.
However, if tursted domain is not there you can use certifactes as...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 4, 2010 at 12:56 am
Same question as QOD 9th July. Once more secure point 😉
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 16, 2010 at 1:22 am
IF YOUR DATABASE IS TEST THAN ONLY PROCEED.....
As this may have data loss.
Make sure you do have the backup of the database
You can simply do the following steps:
1. detach of...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 8, 2010 at 4:02 am
check this...
http://support.microsoft.com/kb/240867#appliesto
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 7, 2010 at 6:59 am
I guess you need to start from a scratch... Because
1. OS rebuild will not find any entry for the other server in cluster i.e. OS level clustering will not be...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 6, 2010 at 12:32 am
If you would like to capture all the actions on the instance refer "C2 Audit Mode Option".
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 1, 2010 at 11:34 pm
The DROP INDEX statement does not apply to indexes created by defining PRIMARY KEY or UNIQUE constraints. To remove the constraint and corresponding index, use "ALTER TABLE" with the DROP...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 1, 2010 at 7:03 am
search with AUTO_UPDATE_STATISTICS which is database property and can set by executing T-sql ALTER DATABASE command.
Also you can write a cursor for the same but sp_msforeachdb is good one.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 30, 2010 at 4:05 am
I would prefer to bring down the databases before the movement and also make sure to have system as well as user database backup.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 30, 2010 at 3:47 am
Me too getting "-1,0,1" but available answer is "-1,-0,1" :w00t:
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 29, 2010 at 1:23 am
Viewing 15 posts - 721 through 735 (of 1,179 total)