Viewing 15 posts - 256 through 270 (of 405 total)
Restore latest full backup and subsequent log backups.
April 9, 2010 at 4:15 am
Why are you running sp_updatestats on the database? why these cant be done off peak hours. If you really require more complex index maintenance (if the size is big) try...
April 9, 2010 at 3:09 am
I think this is the intended behavior. It is recommended you use set for assignment. Select = will leave the variable untouched if the statement returns no rows.
April 9, 2010 at 2:57 am
Try enabling 'include execution trace' in agent properties. You will get more information in the agent log.
April 9, 2010 at 1:57 am
Do you have many bulk operations? if so you can try changing recovery model to Bulk logged (After some reading on the topic).
April 9, 2010 at 1:29 am
Have you tried using port number in the connection string?
March 23, 2010 at 8:35 am
Forcing an index may not be good always.
It says for the plan to use the index even if the optimizer thinks otherwise.
Nolock hint may seem faster since the query...
February 5, 2010 at 5:59 am
Sorry my earlier post gives you the instance nam
to get hostname,
select serverproperty('ComputerNamePhysicalNetBIOS')
December 11, 2009 at 5:13 am
EXEC master..xp_getnetname
December 11, 2009 at 4:29 am
Check the service. does the instance use the default port? How do you connect using ip/hostname. Some times if you have issues with dns the hostname may not work. Ping...
December 11, 2009 at 4:24 am
can you post the execution plan?
December 11, 2009 at 4:20 am
Also CPACKET denotes parallelism waits. You might want to expiriment with MAXDOP settings
December 10, 2009 at 3:06 am
You can also query this counter
select * from sys.dm_os_performance_counters where counter_name like '%user connections%'
December 9, 2009 at 4:51 am
Viewing 15 posts - 256 through 270 (of 405 total)