Viewing 15 posts - 181 through 195 (of 1,335 total)
Let your tempdb on RAID 0 or RAID 10. And the other files on RAID 5 or RAID 10. Then make sure that yuo give sufficient memory for SQL Server...
February 13, 2008 at 9:05 am
You can identify database blocking by query the SQL server system table sysprocesses. Once you find the SPID then that can be used to see what the query is using...
February 13, 2008 at 9:04 am
SQL Server is not interactive in nature means that you can't try to trigger a program from that. You will find that yor query executing without end result or you...
February 13, 2008 at 9:01 am
I would suggest doing other integrity, optimization taks in the week end rather than doin that every day. So that you never out your server under constant pressure.
February 13, 2008 at 8:55 am
This site snia.org is good i learnt a few from here now, thanks guys.
February 13, 2008 at 8:52 am
You can send the report as a web based report to your mail and read the report so that you can get that in your browser. SQL server supports web...
February 13, 2008 at 8:49 am
Do you have a second standby server if so try implementing log shipping there.
February 13, 2008 at 8:48 am
Do you need to send out a mail everytime there is a wrong entry or is it ok if its once a day. Then i suggest you to create a...
February 13, 2008 at 8:43 am
Can't you go with the readcommited isolation level. Did you find out what is the level of lock being held. Also try using READPAST hint in the query. so that...
February 13, 2008 at 8:41 am
For checking security related issues you can use MBSA. also first try with evaluation pack of any quest tools if you find that the evaluation pack has given what you...
February 13, 2008 at 8:38 am
You can create a DTS package to tell SQL Server to import data from excel to sql server, then do the data changes and then export it to access. This...
February 13, 2008 at 8:27 am
refer link http://www.sqlservercentral.com/articles/Disaster+Recovery/sqlserver2005highavailability/2421
February 8, 2008 at 4:31 pm
You can refer the link below.
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2461969&SiteID=17
February 8, 2008 at 4:24 pm
Check if this link helps to solve your problem.
http://www.sqlservercentral.com/Forums/Topic372527-146-1.aspx
February 8, 2008 at 4:23 pm
Do you use linked servers to access the history table in the other server if so your new sql server should be having its service account to access network resources.
February 8, 2008 at 4:21 pm
Viewing 15 posts - 181 through 195 (of 1,335 total)