Those are going to run directly in sequence, not in parallel.

You need to set up a service on a separate server to monitor your servers. That service can then send emails. You can do this through SQL Server, code, or...

Then, basic understanding of concepts. JOINs, WHERE criteria, fundamentals on relational storage. Nothing hard really. Primarily, I'd explore his knowledge set, not actually test it. He's not in a position...

It sounds like you have to processes trying to do the same thing. You can't rebuild multiple indexes simultaneously on the same table.

To see other processes as they're running use...

I'm with everyone else. I wouldn't suggest waiting for SPs at this point. There have just been fewer and fewer of them. I suspect they may be going the way...

For you to have a lot of one thing that relates to one or more other things, you have to have a way to map between in them that allows...

Are there two different servers involved? Are you in a failover situation or something along those lines? It could be that it was failed over during that period.

In the overriding majority of cases, no, this is a serious waste of resources. Most queries will only ever reference the clustered index, especially if they need to get any...

Did you follow the link to the query I posted? It shows how to query the Dynamic Management Views that give you access to the plans in cache such as...

Oh, and one other idea, you might be able to retrieve a query you were working on from cache. I did this once and blogged about it here[/url]. There were...

That's usually an indication of one of two things, the login running the job, whatever it might be, doesn't have access to the server, or, it has the server connection...

It really depends on what kind of DBA we're talking about. I'd suggest getting a copy of Craig Mullins book, "Database Administration." It's one of the best overviews of just...

So, other than just the size of the index, what's different about these two:

CREATE INDEX [IX_New_index_AddressLink1] ON [dbo].[AddressLink] ([AddressID], [DefaultAddress]) INCLUDE ([CustomerID])

CREATE INDEX [IX_New_index_AddressLink2] ON [dbo].[AddressLink] ([AddressID], [DefaultAddress]) INCLUDE ([VendorID])

And...

You just have to use sp_configure:

EXEC sp_configure 'show advanced option', '1';

RECONFIGURE;

EXEC sys.sp_configure;

That will show you all the advanced options to just see the affinity mask for I/O you do this:

EXEC...

You should be nervous.

You're talking about taking responsibility for what, in this modern age, is arguably the most valuable asset of many organizations, the data. If that doesn't scare the...