In a typical disaster (Is there such a thing as a typical disaster?) you would rename the new server the same as the old server, so that you wouldn't have...

Assuming that you are testing the database after restore, then yes, you should feel pretty comfortable. At the last company that I was at, we did full disaster recovery...

I don't think you need to simulate a hardware failure. You just need to simulate your restore process. That could be just restoring the database from backup or...

Recommended reading:

Transaction Log Truncation

Shrinking the Transaction Log

It sounds like you're talking about two different things. Like GSquared said, truncating occurs automatically after you backup the log file. Shrinking the size of the log file...

It's much better to look for a job when you already have one, than when you're unemployed. It allows you to be much more selective and find the best...

I used to work at an insurance company and we had a similar requirement. We used two columns, an effective date and an end date. So when querying,...

I reread your post above. Sounds like a rather strange requirement. I'm not sure why you wouldn't just want everything that is a month older. That would...

It sounds like you need to evaluate the individual date parts instead of the whole date. Something like this might work.

SELECT *

FROM #Month

WHERE DATEPART(dd, DateCreated) = DATEPART(dd, GetDate()) AND...

Srikanth,

Visio determines the relationships based on the primary/foreign key relationships that are in the database. Does the database that you are reverse engineering have those relationships? If...

In Visio, there is an option to reverse engineer a database. It works pretty well. I've never been a fan of the built-in database diagrams.

Greg

Another option is to pull those distinct values into their own table, basically a subset table, where the UNIQUEIDENTIFIER can be your primary key. Then you would have a...

The username needs to be in [brackets] like this:

GRANT EXEC ON dbo.plcStoredProc to [Domain\rptsqluser1]

Hope this helps,

Greg

You're right. CTEs are limited in that they are meant to be a one-time view that gets used immediately and then destroyed. To do what you intend, you...

CTEs can be used to replace derived tables, temporary tables or table variables. They tend to be more readable than using nested subqueries. In fact, they're very good...