exampleUSE [AdventureWorks] GO ALTER INDEX [IX_Employee_ManagerID] ON HumanResources.Employee REBUILD WITH ( SORT_IN_TEMPDB = ON ) GO increase the...
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 for example: use adventureWorks 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. use command 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. The...
There are set of maintainance plan that can be generated by the wizard in sql server: Back up Database full Back up Database differential Back up...
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.
