If the stats are updated and the index contains all the columns that are selected and the column in the where clause is the leading column in the index then...

The check integrity maintenance task is indeed the same one.

Wherever possible I try to run the check integrity task then take full backup and only after that I delete...

If you want to execute multiple queries against all databases then check the following solution

http://saveadba.blogspot.com/2011/10/sql-server-execute-same-query-against.html

Firstly when you say you set the TEMPDB size to very large, can you tell us the exact size in GBs?

Run the following two queries and determine what are the...

I had opened a ticket with Microsoft and this point came up in the discussion. I wasn't able to shrink a data file and they asked me to check if...

Look at the task manager and identify the process that is causing paging. If it is SQL Server then there might two reason that is happening.

1) Check the memory on...

It would help if you can show us the execution plan. But your guess if half right and Grant as explained the other potential problem. If column1 is not the...

As I expected you can not rebuild the particular index in ONLINE mode because of the column 'field_value'.

Check the number of pages in the index and if it...

There is not much information in the job history.

Each maintenance plan will save the output in a text file which is usually located in the LOG directory of your MSSQL...

Checking for memory utilization on SQL Server can be quiet tedious. But I would start with running a perfmon counter for 24 hours for the following counters.

Memory Available MBs

Pagin/sec

SQL Server...

For SQL Server 2005 download from

http://www.microsoft.com/download/en/details.aspx?id=184

For SQL Server 2008 download from

http://www.microsoft.com/download/en/details.aspx?id=27597

For SQL Server 2008 R2 download from

http://www.microsoft.com/download/en/details.aspx?id=26729

If you want the 64 bit...

Check the job schedule in the job properties and make sure that it is enabled. I have seen sometimes you will have a job enabled but not its scheduled. You...

Can you please post what is the instance name you are connecting to in the management studio? Also check in the instance name in the services and confirm that you...

Can you check what is the wait type when the INSERT query is running? If the application guys can not change the code then you need to figure out...

SQL Server management studio express does not install the SQL Server instance. That is why there are no SQL Server services.

Download the appropriate version of express edition that you want...