ALTER INDEX [IX_Employee_ManagerID] ON HumanResources.Employee
REBUILD WITH ( SORT_IN_TEMPDB = ON )
modify table design and set the properties of empcode computed column
the computed formula is: ('e0000'+CONVERT([varchar](max),[empid],0))
use the index option sort_in_tempdb =true to maintain all indexes in tempdb not in the database.
increase the size of tempdb
Use DATALENGTH function to get length of column of any data type
select DATALENGTH (DepartmentID )+ DATALENGTH(...
Thank you Elisabeth for your greet advice and details
I think i should use Merge replication bez it match my case.
Thank you satya for your...
thank all for reply
The remote sites use 256 Kbps , so which replication is less overhead for WAN.
Is ther a reasonable speed for link between...
I have OLTP central database sql standard 2005 that is currently working within LAN.
It is required that new three remote branch sites will connect...
rest the domain user account that run the services , not expired
use sql server configuration manager to change the account ( not from services...
in foreach loop editor , select collection -> select fully qualified in the "reterive file name"
Run the shell command from dos , for testing....
use the command: bcp database1..file1 in "c:abc.txt" -c -T
-T caps letter
for heavily insert tables , let fill factor <90 , say 60-70 to avoide defragementation.
check the security of the directory used for file enumeration. Be sure that user has permission on that directory.
Try to ping the two servers from any client
if ok ,check firewall and enable ping service.
from server 10.9.30.14 run command: tracert...
two process acces wf_queue in the same time
proc 160: SELECT COUNT(*) FROM WF_QUEUE WHERE PROCESSID = 2 an....
proc 159: SELECT COUNT(*) FROM...
catch values in variables , rollback then insert
IF EXISTS (SELECT * FROM sys.triggers WHERE name = N'log' AND parent_class=0)
DROP TRIGGER [log]...
Thanks all for reply
i used the copy/move wizard in sql 2005 , using deattch method.
I discovered the reason. It is a file security.
There are set of maintainance plan that can be generated by the wizard in sql server:
Back up Database full
Back up Database differential
modify the registry key:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServerBackupDirectory
the default of that entry is:...
Is delete task commited successfully or not. Is there errors related to the delete transactions.?
you can , but why not to be non clustered index.
you have only one cluster index for the table, and it is best to be used for PK
Separate names with a comma.