If SQL or you suspect that a new index would be benefical then you have to assess it performance impact, both positive and negative.

For example adding an index to TableA...

Hi,

Not sure I exactly understand the question, but how have you discovered these missing indexes, via the DMV's or any other method.

If you suspect an index is needed, then you...

Hi,

This will work in SQL 2005 for getting the db properties;

SELECT * FROM Sys.databases

Hope this helps.

Hi,

This is just SQL checking the db at start up for transactions that need rolling back or forward etc. It should do this for each db on the instance....

I think it really depends on what your updating, certain hot fixes can be uninstalled via the control panel;

see http://support.microsoft.com/kb/933097 for an example.

However as Manu rightly points out service packs...

Hi,

It depends on what you really want to do, I was just having a look through the Microsoft support site and update I looked at had instructions on uninstalling, however...

Hi,

The solution really depends on the security set up you apply.

If the object is new and all logins (or groups) only have the permissions they need then you can just...

If you could that would be great.

I'd be surprised if the processor was causing the issue, it's an AMD and i've never heard of any issue with that.

The failed to...

Hi,

Does the event log list an thing in relation to the service being unable to start?

Thanks.

Hi,

You could query the Sys.databases table, this should give you all the information you need regarding your database.

Hope this helps,

Jackal

Hi,

Check out this article.

http://www.mssqltips.com/tip.asp?tip=1363

It may also be a good approach to get a profiler session running, this will give you all the session information you may require, you can leave...

Hi,

I may have mis-understood the question, but could you not run a profiler session and then catch the executed code from there?

Jackal

Hi,

I may have mis-understood the question, but could you not run a profiler session and then catch the executed code from there?

Jackal

Hi,

An instance, refers to an instance (installation) of SQL Server.

If you had 2 instances of SQL Server installed on a server then you could for example run a development and...

its a strange one this, i've just tried Gails SQL on both a 2005 and 2008 instance, without the ALTER statement it does not run on master, however with the...