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...

In addition to Red Gate's tool, and if you get that, really, what else do you need, Mladen Prajdic's SSMS Toolpack [/url]also has the ability to recover tabs. Plus, it...

If you follow Perry's suggestion of setting up mirroring or log shipping for the duration of the migration, you can offload all the long running processes and do them all...

If you're not reorganizing, it's because there is storage towards the end of the file preventing the shrink from occurring.

A single shrink with a reorganize because you've just had a...

Ignore all the other stuff you were attempting to install. The Upgrade Advisor is just to check your databases to ensure they can be upgraded. The pack is just some...

When...