I'll have to take a look. Not sure what this is. If someone includes a link, it should be to the post, not the forum + post, so moves shouldn't...

Thanks, I'll add this to the list.

It seems to close the "pages" of posts that I have. Not sure why.

I'll look and see, but it's a good idea.

Keep in mind that most threads die in a few days, so you won't get a lot of emails over time from...

I'm nervous about having anything on my SQL Servers that might be"touching" the database files. I think it's a gamble that something in Diskkeeper or any similar product, including anti-virus,...

It doesn't sound like there is anything you are doing that's strange. Almost everyone connects to a central SQL Server database in some way with their application.

If you're unsure, it...

I'd only run this on particular objects if things were out of whack and I had very bad query plans, or if my distribution of data changed substantially.

Walk through some logic. How do you figure out what the last Sunday is? (besides looking at the calendar).

There's a skill you need to build here to examine what determines...

Nope. Nothing like this in SQL Server.

There is a power button, however. 😉

You'd have to convert things to numerics,stripping out the hyphens,for sorting purposes. Don't change the data, but extract the numbers (using CAST(SUBSTRING(CHARINDEX())) functions to get this.

It's somewhat legacy, and it's good practice since in a DR situation, you need the CREATE. If you redeploy permissions, you're ok. If not, this is bad and you need...

Code has been added to the article.

The NEWID() and RAND() will get you random, or psuedo-random, numbers. You can use that to generate random characters (combine or convert as aSCII values) or dates (add to some...

datepart will get you sundays, check BOL for the parameters.

The idea is that you want to develop an algorithm that can determine what the last Sunday is by examining various...

What is the "identity" password? sp_password, run against the virtual server, will change the password for the login.