Drop does exactly what it says. It's going to drop the existing index and then rebuild it. No, it won't leave the existing index available while it does the rebuild......

And make sure your backups have been running for the last several days. Make a copy of the backups. If you have log backups prior to the error, make sure...

Index intersection might work with the 2 indexes, but it might not. If not, you could try the same two indexes and then use a UNION ALL query to put...

asranantha (8/16/2012)

---

how can u gues it is interview question? and in case of its interview question why ur not help?ok if u know answer tell me answers its help other...

This isn't something I've set up in my Availability Group work so far, but here's a blog post where someone ran into a similar issue.

You're still attempting to stuff multiple files into a single location. You can't do that this:

MOVE N'TELE_1_Log' TO

N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVERMSSQL\DATA\TELE_log.ldf',

Needs to be changed to something else, maybe...

These questions really sound like either an interview or homework. If I answer the questions, do I get the pay or the grade?

Itzik Ben Gan has a number of examples on how to find islands and gaps in sets of numbers in his book Inside T-SQL Querying. I'd suggest picking up a...

This is administrator information. Either you need to get view server state permissions or you need to work with someone who does.

I've mostly used SQL and it works great on 2012. You can even use the Availability Groups to do log backups or COPY_ONLY backups in addition to the normal backup...

That number does seem high, but only because I've primarily worked on systems with stored procedures. If you're working with lots of dynamic or ad hoc SQL, then that number...

Also, if the NOLOCK hint is applied to any kind of data modification queries, SQL Server just ignores it. It has to do locks in order to modify data.

I'll try. I might be...

Oops. Missed the missing 'IO' & responded too quickly.

You might want to take a look at Central Management Servers. It's a way to control & report back on multiple servers from a single location. Here's the BOL entry:...