In effect, yes, you could add a "signature" using extended properties. It could be anything you want, just an entry to show that you created the proc.

Roughly normal, yes. The rebuild process requires additional disk space.

But, after the rebuild, more of that 102G is unallocated and could, theoretically, be released to disk by shrinking the...

No, but you must alias it so SQL can recognize the difference between a scalar variable one a table. I think it's a parsing issue if you don't use...

Not automatically. When pages are freed from a table, they are basically as marked as "not in use" within that db, but they remain in that db and are...

You'd want the flag column(s) to key the index, not column1. Start with whichever flag is more selective. So, either: (flag1, flag2) or (flag2, flag1).

But, as Grant noted,...

Maybe it's a case-sensitive db and the literal's case doesn't match the case stored in the table??

I don't see a clustered index on the table (but maybe I just missed it).

If you most often / always query the table based on YrMo, cluster the table on...

Something like below I guess. I can't test it (and thus also can't review the query plan to check potential performance) because I don't have data with which to...

pwalter83 (3/25/2015)

---

ScottPletcher (3/25/2015)

---

You should get rid of the DISTINCT in the subquery; since you're GROUPing on BL_ID, you don't need it anyway.

Otherwise it's difficult to re-write because there are no...

If I understand the query correctly, I think this will do it:

DECLARE @SearchId INT = 100

SELECT Customer.*

FROM Customer

WHERE

NOT EXISTS(

...

You should get rid of the DISTINCT in the subquery; since you're GROUPing on BL_ID, you don't need it anyway.

Otherwise it's difficult to re-write because there are no aliases on...

You can specify a longer length on the SUBSTRING and it won't hurt anything, so you skip calculating the length; for example:

SELECT SUBSTRING(string_value, CHARINDEX('-', string_value) + 1, 100)

CA ERwin has a free tool now, although that version does limit the number of objects. The full ERwin is a fantastic modeling tool (my favorite of the many...

The READPAST hint is very helpful in those types of situations. I believed it was designed to help handle these types of "queue assignment" queries.

Detach can get messy, esp. with the file security changes that occur.

I'd just restore the backup 20 times. You could bundle the entire process into a master job and...