doveb (5/20/2009)

---

What a great idea. Thank you for the tip. I did have one question. Are there any additional considerations for items that are schema bound or...

Interesting article and great concept. I've always relied on backups if an object gets dropped accidentally but this would be an interesting concept. I'm wondering why you...

Check your statistics. Your IF EXISTS is showing an estimated # of rows for your "permanent" table as under 4 and the select as over 800K. Using the larger...

But it isn't faster when your proc "hangs" at the IF EXISTS. Plus you are using more resources because you have to scan tmptbl1 twice no matter what your...

You just need to be careful when using BETWEEN since SQL Server stores the Date with a time so you need to take the time into account. For example

Delete...

I send email to my gmail account on a regular basis. You can also set up database mail to use an external smtp server like hotmail or gmail.

Why do the check at all. Your second insert statement does exactly what you need done, insert new rows. If there are no new rows you won't get...

I have always had local admin rights on my SQL Server boxes, but I can see where I would not need it, and it places I have worked I could...

Looks like you are going the right direction.

As far as I know you can make LocationID the child portion of a FK even though it is part of the composite...

Yes you could disable it that way, or you can go to that point and go into the rule's properties and add DatabaseMail90.exe to the exception list. As I...

You would need to test that situation. It appears that there can be a performance benefit by using EXISTS/NOT EXISTS, but you should test both before you make a...

Okay, I did not know that you were crossing databases with the view. By default cross database ownership chaining is disabled so in order for a view to cross...

If you are...

First I suggest you read this article[/url] (disclaimer, I wrote it).

Then I suggest you read the first article in my signature line if you want code examples. The best...

Check out this article[/url] which contains a set-based split methodology. You can replace the numbers table with a CTE.