Viewing 15 posts - 16 through 30 (of 75 total)
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...
Blog
http://saveadba.blogspot.com/
February 3, 2012 at 7:17 am
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...
Blog
http://saveadba.blogspot.com/
February 2, 2012 at 8:21 pm
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
Blog
http://saveadba.blogspot.com/
February 2, 2012 at 9:34 am
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...
Blog
http://saveadba.blogspot.com/
February 2, 2012 at 9:21 am
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...
Blog
http://saveadba.blogspot.com/
February 2, 2012 at 7:21 am
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...
Blog
http://saveadba.blogspot.com/
February 2, 2012 at 7:18 am
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...
Blog
http://saveadba.blogspot.com/
February 2, 2012 at 7:12 am
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...
Blog
http://saveadba.blogspot.com/
February 2, 2012 at 6:55 am
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...
Blog
http://saveadba.blogspot.com/
February 1, 2012 at 7:45 pm
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...
Blog
http://saveadba.blogspot.com/
January 31, 2012 at 1:13 pm
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...
Blog
http://saveadba.blogspot.com/
January 30, 2012 at 2:24 pm
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...
Blog
http://saveadba.blogspot.com/
January 30, 2012 at 11:21 am
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...
Blog
http://saveadba.blogspot.com/
January 30, 2012 at 10:09 am
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...
Blog
http://saveadba.blogspot.com/
January 30, 2012 at 10:06 am
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...
Blog
http://saveadba.blogspot.com/
January 30, 2012 at 10:04 am
Viewing 15 posts - 16 through 30 (of 75 total)