I just remembered that you can't create an index on a view with a Union operator in it. I'll have to test with Union All (BOL wasn't expicit about...

Depending on how you count it, Dense_Rank might be better than Rank in a situation like this.

For example, if you have a tie for first place, the second highest number...

Per BOL:

All queries, including those with READUNCOMMITTED and NOLOCK hints, acquire Sch-S (schema stability) locks during compilation and execution. Because of this, queries are blocked when a concurrent transaction holds...

This is a duplicate post.

http://www.sqlservercentral.com/Forums/Topic472721-149-1.aspx

I haven't run into the file corruption issue, but I can see that separate files would make sense.

Since the point is to avoid accidentally getting rid of a backup when...

If the Parent/Child tags are meant to be significant, then storing two rows kind of defeats that purpose.

An indexed view might be your best bet.

create view Friends

with schemabinding

as

select parentid as...

It depends on what you need.

Your full backups and log backups should generally be apended. And the prior day's backups should be on tape (or some other separate medium),...

Really, it depends on what you're using them for. But it's often considered a good practice to use temp tables instead of table variables, because the advantages for table...

You can use sys.all_objects.

select name

from sys.all_objects

where type in (

'c', -- check constraints

'd', -- default constraints

'f' -- foreign keys

)

That will give you a list of all of those objects. Wrap...

No. You haven't missed anything. It's unneccessary to use the While loop on that. I do it as a practice, because there are times when I use...

This question makes no sense, and the answer doesn't clarify anything.

When moving system databases, I can't find any documentation that says it has to be in a particular order. ...

To catch those, put a Try/Catch in the called proc.

That makes sense.

"Don't forget... if you want to do full row auditing, then your database will be at least 2 times the original size you planned for. 500 gig db suddenly...

Perhaps I should be more clear on how often this data is used.

Today's updates are rarely needed for anything. The occassional, "I updated the wrong account, and now I...