You can simply add files to existing file groups and you can specify storage of an object to a file. However, management is a lot easier through filegroups, so yeah,...

And therein lies a philosophical debate.

After reading a lot of what Jeff Moden has to say on fragmentation, some testing, some research, I lean heavily towards setting an...

Don't run the query twice. Run it one time. SELECT whatever FROM wherever WHERE somesetofrestrictivefilteringthatusesanindexanddoesnthavecalculationsandfunctionsonit is the right way to do something like this. Trying to determine if there is...

Think of the IF EXISTS command like the WHERE clause in a query. Yes, your WHERE clause may eliminate all the data in a table/index, but the table/index was still...

If it's some type of SAN, work with the admins there to get more space on the drives as Chris already suggested. Otherwise, yeah, you'll need to move some stuff...

Piling on.

Focus on gathering metrics right now. What are your wait statistics like? Is the server waiting on memory? Which queries are waiting? What is making those...