kevriley (10/22/2009)

---

Steve,

liked your blog post and editorial today about this issue, and couldn't agree more that there should be more transparency.

As a DBA in the UK, I feel very, very...

talltop-969015 (10/21/2009)

---

repent_kog_is_near (10/21/2009)

---

talltop-969015

You asked some simple 'baby' questions.. here they are..

*Difference between delete and truncate

*What is identity column?

*Login vs User

*What are Collations

*CAST Vs CONVERT

*Union Vs Union All

*What is ANSI

*View vs...

su_kumar11 (10/22/2009)

---

Hi,

I have a full backup and transaction backup till 12.00pm

and if my database has been crashed at 12.30 pm .Then how i will recover...

I replied to your other post

anthu_soft (10/22/2009)

---

I have a doubt about moving the database from one server to another server without data in the table.

I have a database in developement server. I want to move...

GSquared (10/21/2009)

---

Well, that certainly gives a good interview question to ask. We've evolved it to, "You have a database with a corrupted or lost page, and the backup chain is...

GSquared (10/21/2009)

---

Grant Fritchey (10/20/2009)

---

No accountants here either... Nurses, Receptionists, Sales people... those I've seen try to be DBA's. Nurses weren't so bad, neither were the receptionists... keep the sales people...

Could be a number of reasons, including running out of disk space. Look at the job history for the job that is failing and post the results.

The example is calling an existing maintenance plan

Steve Jones - Editor (10/20/2009)

---

Your post was fine. I added this reply to a couple threads since a few comments were approaching the personal line. I just wanted to remind...

Roy Ernest (10/20/2009)

---

Has everyone here started using ask.sqlservercentral.com ? I still cannot login since our works firewall will not allow yahoo authentication that is used for OpenID

Too bad the site...

Elliott W (10/20/2009)

---

Steve Jones - Editor (10/20/2009)

---

I received a complaint from the user about some of the postings. While I told him/her that I disagreed with the tact they were...

Already replied to your other post

From BOL

In the following example, xp_sqlmaint...

Ian Scarlett (10/20/2009)

---

GSquared (10/20/2009)

---

And you might be shocked by how many people who call themselves DBAs or who even have jobs as DBAs can't answer that question. I've met...