It might be. Can you post the query, the table definition and the index that you tried?

Why must it be a filtered index?

Delete all the objects in that filegroup. Delete all...

You can't make a different filegroup primary, the primary filegroup is the first one in the database and the one that contains the primary file. You can't delete the primary...

See https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

Have you considered using MERGE rather than an insert/update pair?

I'd be a little more concerned about this more than the exam quality http://www.techexams.net/forums/mcdst/11848-passed-70-271-easy.html, plus read through their FAQ, there's mention of 'scouring the web for questions' rather than then...

patrickmcginnis59 10839 (5/6/2013)

---

The one exception I seem to notice that if in SSMS I set my DEFAULT database (as speced in SSMS properties for my "login") to the same database...

You would be able to.

If someone has [grabbed the sole connection], identify who,...

suneet.mlvy (5/6/2013)

---

Thanks for the response, now I understand the timeout concept, but can u explain me how sql server kill sleeped session is there any setting available to kill them...

Timeout is a client concept, not one the server deals with. It's the client that decides that a query has been running too long and the client that tells SQL...

masoudk1990 (5/6/2013)

---

Thank you, hence this statement is not allowed:

INSERT INTO TableName (Value1,value2)

values(

select value1 from table1,

select value2 from table2

)

Instead you must...

INSERT INTO TableName (ID,Value)

SELECT coalesce(MAX(ID),0) + 1, 'something' FROM TableName;

If you have Enterprise Edition, you can rebuild the indexes online, they'll probably take longer but don't hold long-duration locks.

200 executions of a query taking 6 seconds means that each execution takes 30ms to execute and return results, ignoring the parse and compile time (and SSMS is often slow...

Red Gate's SQL Prompt. 30 day, full-featured trial.