You should keep track on SQL Server storage and performance to avoid this type of problem

If the capacity management of sql server is up to the mark then sql...

Check out the below threads to find out the poor performing query

http://stackoverflow.com/questions/2499910/how-to-find-the-worst-performing-queries-in-sql-server-2008

http://msdn.microsoft.com/en-us/magazine/cc135978.aspx

First you should check few things before moving a table

1. You cannot change the data type of the partitioning column once the table is partitioned.

2. You can move...

You can set some alert through an utility like after the successful completion of job you will receive a mail

Use some monitoring software like this

http://www.windowseventlogmonitor.com/

Here is an excellent difference between rebuilding the indexes & reorganising the indexes

Eg.

Index Rebuild : This process drops the existing Index and Recreates the index.

USE AdventureWorks;

GO

ALTER INDEX ALL ON...

Also you need to check your disk space and the future growth of your disk size & memory utilisation by query

Its may be a performance related issue ...

check you CPU usage and memory usage for the sql server

If its taking much percentage as expected ..you should reorganize the indexes...

if you have too many indexes, the insert and update performance of your application suffers.

You have to find a balance between the indexing needs of the writes and reads that...

I will suggest to use a third party tool it will monitor the performance of SQL Server, the future growth of your database size,

which in turn improve the performance...

1.what is the difference between DB server and Report Server?

Answer:

The report server is the central component of a Reporting Services installation. It consists of a...

Simplest solution is to use a WITH. e.g.

WITH results ( <select> ) DELETE FROM results –

For shrinking,fragmentation and forecast the future database space growth u should use a dedicated tool that will fulfill your requirements regarding SQL SERVER STORAGE .....there are many tool fall in...

Scalability shows the dependency of performance on factors like the data volume i.e. data stored in a database

The response time of an SQL query depends on many factors. The data...

Its not a certification topic , it is related to troubleshooting of SQL SERVER reporting service as askesd by umashankar

in that case u should follow this link ..

http://msdn.microsoft.com/en-us/library/ms156468(v=sql.100).aspx