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

I think Chris has a real improvement there, but we're just guessing. Without seeing the execution plan, I'm not sure why your original query is running slow.

Regardless of the exact definition of Midwest states, I'm extremely adverse to nesting views within views, or functions within views or functions within functions.

I recognize that creating a view means...

Sounds like it's probably blocking from other resources accessing the table. Otherwise, it shouldn't take that long at all.

I'd use Jonathan's query to find the plans.

Also, yours only includes procedures. It doesn't include ad hoc queries. You'd need to hit sys.dm_exec_query_stats for that.

The core setup for a 2014 server isn't going to be any different than for a 2008 server. After that, it completely depends on if you're using functionality that wasn't...