A proven way to tackle such kind of thing is to replicate the status in a separate table using triggers and fetch the status from there whenever...
Did you try creating clustered index on ID instead of SRID ...
Seems to be one of the reporting queries with joins depending on user selection. I have few suggestions for you:
Try to eliminate any function calls...
I guess this would cause mirroring session to fail.
Try using ROW_NUMBER() function as you are using SQL 2005.
"Its nice to be Important, But its more...
I guess dynamic sql is the best option to choose...
"Its nice to be Important, But its more important to be Nice"
Seems the second value : 1.1480 is being missed out in Reporting services report as this is exactly the difference if you take precision upto two...
It seems the output from Query analyzer is correct as far as arithmetic is concerned.
"Its nice to be Important, But its more important...
Good One[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />---<br />Sunil<br /><br />"Its nice to be Important, But its more...
Index hint should be used with utmost care, as the sql server itself uses an index optimally whenever it feels right. So, use index hint only when u...
Yup. try rebuilding it
Thanks FrankKalis, the link was useful.
After every batch try BACKUP LOG <> WITH TRUNCATE_ONLY followed by SHRINKFILE.
Also, use Bulk-Logged recovery model.
Registering a server means you have a dedicated connection to that server. However, linked server means you can access your local database alongwith...
Thats right, create an index on ID column of the dynamic table and then it would be faster
You can check following:
- DB Deployment (ldf preferably should be on separate exclusive disk)
- Check if all the files having sufficient free...
SET AUTO_UPDATE_STATISTICS ON
Yes, you can use DBCC DBREINDEX
Use perfmon Alerts.
- Create a new alert
- Add counter LogicalDisk->%Free Space
- Set the limit for sending alert
Try rebuilding the index.
Separate names with a comma.