If you have a maintenance window, the optimization maintenance plan is the simplest way to manage fragmentation.  It may be overkill, but it is the easiest to set up.  Downsides...

"Where can I learn about dependencies?" 

Create a database diagram and add the tables in question.  There is an option to add related tables.  Select all the tables and use "Add...

If the duplicate rows can be ignored, you could replace your primary key with a unique index with the IGNORE_DUP_KEY attribute (and same clustering as existing primary key).

If you need...

Char vs varchar - There is more to it than just the extra 4 bytes of overhead for each varchar, fixed-length fields can be handled more efficiently than variable-length.  Especially...

Assuming your two big tables are being joined by an integer key, you could try something like this:

declare @n1 int, @n2 int

select @n1 = min(pk), @n2 = max(pk) from bigtable1

while @n1...

You can rarely get away with saying "No can do" to an external client.  You can try to tell them the data cleaning will make the schedule slip and cost...

By "indexes are analyzed with a 13% sampling rate" I assume you mean updating statistics.  The only thing you can say for sure is that doing this during a heavy...

Re-read the question.  The trans log backups are hourly at 15 minutes after the hour, so the 12:15PM log backup is needed to cover the 11:15AM - 11:55AM range.  The...

The answer said to use "from device" to load the backup history with the details for all the log files.  There is a missing step in the description, but it...

If you have SELECT permissions for the function, it must be a table-valued function.  Then the correct syntax would be:

SELECT * FROM ::dbo.fn_GetClosestZip(98052)

I don't think you can get at extended (like column descriptions) directly through the object model.  You'll have to execute queries to find them.

See "Using Extended Properties on Database Objects"...

If you zipped the file using Winzip's proprietary maximum compression, you can't even open it on a Windows computer except with Winzip.  I would check for that first.  After eliminating other likely explantions,...

Comparing the cost of alternative solutions is not the same as saying you can't imagine how an alternative solution could possibly work.  And how you get the idea that Jo's...

There is no easy way to tell SQL Server to go off and execute commands in an arbitrary file, and probably for good reasons from a security perspective.

Find the person(s)...

I can't imagine why anyone capable of coming up with your overengineered, impenetrable solution couldn't figure out how to use a simpler solution.  The Candidate_Evaluation table in my solution could...