A view can only contain a single select statement, no other statements are allowed.

Try an in-line table-valued function with those two variables as parameters to the function.

Sequences have the same gap-causing properties as identities (identities in SQL 2012 use the...

Maybe take a read through these?

http://www.sqlservercentral.com/articles/Indexing/68439/

http://www.sqlservercentral.com/articles/Indexing/68563/

http://www.sqlservercentral.com/articles/Indexing/68636/

Steve Jones - SSC Editor (7/22/2013)

---

Some people do this. It can help, but it depends. Also, if you recover the database partially, you may have really poor performance if you...

No simple answer here, you'd need to analyse usage patterns, whether the tables get read often from disk, whether the system is even IO bottlenecked, whether those are partitions on...

mohan.bndr (7/22/2013)

---

As i understand that , it is not possible in bulk logged recovery mode for point in time restoration. But here i would like to know that ....what will...

p.s. Ditch the nolocks

See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

Make sure it's not your connection using the database. Change database context to master before you run the restore.

wolfkillj (7/22/2013)

---

So strictly speaking, the data for rows in a clustered index will not always be physically stored in key order, although the data can only be out of order...

Take a read through this: http://www.sqlservercentral.com/articles/Recovery+Model/89664/

If you mean the page file, then 4GB is probably fine and 110...

george sibbald (7/22/2013)

---

GilaMonster (7/22/2013)

---

Optimise for ad-hoc...

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Please note: 9 year old thread.

No idea. You're the only one who can say if they're normal. Are they close to wait times that your benchmarks for that server recorded?