Lately I have found that more posters actually have a problem with their expected result sets because they forgot (or didn't know) what they should be expecting. That it's not...

kbnyny (10/6/2010)

---

I have a query that is not pull all the data that it should be pulling. It should return 170 records. Before i added on Table SOP30300 I was...

Stefan Krzywicki (10/6/2010)

---

The main reason I want to shove him off onto his own instance of his own database on his own server is that we already have performance problems...

Stefan Krzywicki (10/6/2010)

---

Brandie Tarvin (10/6/2010)

---

Really? I haven't had any problems with it. What's your issue?

EDIT:...

Post for the sake of bumping the post #. @=)

Really? I haven't had any problems with it. What's your issue?

EDIT: Sorry. Thought you were...

Numeric instead of Integar? Bad cowboy! Doesn't he know that extra byte...

...And thou shalt count to three. Not to four, which is greater...

Best piece of advice on this thread yet.

GilaMonster (10/6/2010)

---

Brandie Tarvin (10/6/2010)

---

I do have to ask this. You have full database backups scheduled, but it's not backing up the MDF file?

How do you know it's not backing...

liewsb (10/6/2010)

---

We have a schedule job to do a full backup on the database, but not these two file, i.e. MDF and LDF files. How to create a transaction log...

Definitely follow Gail's advice. She's rescued more databases than the Humane Society has rescued pets.

FYI: If you're not doing transaction log backups and you're in FULL or Bulk-Logged recovery model,...

No. I find it professional and well-reasoned. It is the correct and necessary response to the question.

In regards to another post / thread:

Here's the latest SQL Server version list, including 2k8 R2.

And for those who don't like clicky links: http://www.sqlteam.com/article/sql-server-versions

Sinus infection

...maybe.