Ravi,

It might be the DBA doesn't want to give that kind of access. But just in case the DBA really can't figure it out, tell him/her to grant you...

Alberto,

Unfortunately, without more details on what you're trying to pull from the table, I can't assist you further. You need to give more details on what you're trying to...

Yes, there are changes on the DB. Both when you create the index and when you drop it.

Additionally, if you create a clustered index, you're changing the whole structure...

Intereeestiinnngg.

I'll have to keep this one in mind. Thanks, Grant!

Grant,

What does the "End = 1" do? I understand the "END" keyword. I'm just trying to figure out the rest of it.

Are you sure you don't have a typo on the email address in the subscription?

That explanation doesn't help me figure out how to help you, unfortunately. What information are you trying to check?

Also, if this DB isn't yours, you need to talk to...

Look up books written by the Kimball Group for a start. This has been an excellent reference for me.

Also, look into books about database design. Most...

It's not a question of which is better in general. It's a question of which is better for your particular circumstances.

Or in common DBA parlance, "It Depends." @=)

What language(s)...

What are you trying to achieve with this temporary index? And why do you want it to only be temporary?

And look up "JOIN" in Books Online. That should help you figure it out.

It's not about the size of the database. It's usually about the number of physical disks you have (or SAN LUNs) available.

Splitting a DB into multiple files...

There's no comprehensive list, but ISTR that I had to change compatibility before I could use PIVOT / UNPIVOT.

I can't tell for sure now because all the DBs...

I go with Ian's suggestion. I always try various combinations then run through a Query Execution plan to see which one works best for my current needs. I...

Are you talking user databases or System databases?

Because System Databases cannot be detached while SQL Server Service is running. You'll have to use the Alter Database command...