If you have a backup - you can restore to get the mdf file. If you don't have a backup (why not?) - then you no longer have a...

CirquedeSQLeil (4/2/2010)did you say Red-gate have bought Hyperbac? Don't Red-Gate already have their own backup compression tool?

Do hope this will not reduce competition and the number of options on the...

Jeff Moden (3/21/2010)Like Dave said, find the first of the month for the given date, then add one month and substract a day. Here's how to do it using...

SQL Server will take all of the memory up to the max memory setting. It does not guarantee that it will take all of it.

If that instance does not...

I wouldn't say a default of 80% is good - nor would I say one of 90% or any other value. There are definitely some tables in your system...

It is not required.

2.Three of the instances using Max of allocated memory. i.e...

No - more like I passed. Just confirms my own...

Paul White NZ (4/2/2010)

---

Synonyms were created to meet exactly the sort of need presented here.

They are easy to...

Paul White NZ (4/2/2010)

---

I would tend to prefer the synonym approach - assuming the database in question...

Using views is one approach - another approach is to use synonyms. For example:

-- First, create a schema for your synonyms. Not necessary, but organizes them for you

CREATE...

liteswitch (3/30/2010)

---

I had to do something similar a while back as part of an audit review, and I ended up writing a VB.Net application to monitor disk space usage (as...

Paul White NZ (3/30/2010)

---

My attempt:

A view is the definition of a single (restricted) SELECT statement. The definition of the view is expanded into any query it is referenced by...

Perry Whittle (3/30/2010)

---

as Jeffrey said DBCC LOGINFO and check for anything with a status of 2 near the bottom of the output. SQL server will not truncate or shrink (they...

It is very hard to tell - because the file extension does not tell us what kind of file that is. Is it a SQL Server backup file? ...

David Portas (3/30/2010)

---

A view is a derived table defined in declarative code. Think of it as being a variable with a name and a value (the value is the data).

A...