drew.allen (3/20/2012)

---

It's easy to calculate the beginning of the month using the following function.

DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)

You can then use that in your CASE expression or WHERE clause as...

Unfortunately that hasn't been my experience in the past. As such, if the directory structure of the source database from the directory structure of the destination, I will always...

Here is a link to check out other options:

http://www.vieka.com/esqldoc/esqlref/htm/odbctime__date__and_interval_functions.htm

Try this ODBC date function: {fn CURRENT_DATE( )}

Migraine

To add to what Jeff said, cursors and while looks...

Okay, pretty sure you've had the opportunity to see and test the code posted. Curious what you have found out testing it.

Where I am now is using TortoiseSVN. If I remember, I let you know how well it works.

Possible some of the rebuilds of indexes (clustered/nonclustered) freed space in the database when pages were consolidated. The database itself will retain its size unless explicitly shrunk.

Depending on how...

SQL Backup is a third party tool for backups, correct? Is it configured to compress the backup files?

kevinsql7 (3/19/2012)

---

Lynn Pettis (3/19/2012)

---

If the production database, MyDB, resides in F:\SQLData on the production server and you restore the backup of this database to a test server without using the...

Can we say it any plainer than this:

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

njdevils39 (3/19/2012)

---

I apologize Sean,

but can you please give me an idea or code example how you would go about writing this stored procedure:

Note: Please include emp_name, emp_organization and emp_department from...

MarbryHardin (3/19/2012)

---

Tabs, all the way.

Saying that you want to use spaces because people will write improperly formatted code is a hack. Tabs have the same usefulness and purpose in...

I have not had a restore with replace put the data files in the original location of the database being restored. I have seen it delete the files from...