Superb Idea

Gianluca Sartori (4/2/2010)

---

I have found in some cases that taking off a copy to...

Paul White NZ (4/2/2010)

---

Yes. Compatibility levels are...

Paul White NZ (4/2/2010)

---

chrismat (4/1/2010)[hrApparently the entire query window becomes the SP and doesn't stop at the END; statement at the end of the CREATE PROCEDURE... I didn't realize...

gmamata7 (4/1/2010)

---

I have created the procedure that given in the link and executing as below

exec sp_import_errorlog

@log_name =errorlog,

@log_number = 0,

@overwrite = 0

but getting the below error:

Msg 213, Level 16, State 7,...

GilaMonster (4/2/2010)

---

Absolutely. CheckDB reads every allocated page in the entire database, hence you're going to have a...

Thanks - I will look into more of his stuff.

Since a CHeckDB also performs a checktable (which checks all of the pages in the database), it would seem that it should drop the PLE very low. Somebody else...

See how this really isn't just a simple question?

Lynn Pettis (4/1/2010)

---

CirquedeSQLeil (4/1/2010)

---

Correct. As a SQL Server Database professional. It shouldn't matter that you are a developer, BI Specialist, or Admin. Working with SQL Server is...

Definitely add logging to the package.

http://msdn.microsoft.com/en-us/library/ms167456.aspx

This package ends and terminates properly when run from bids?

My blog and twitter handle.

Which means you would have to update to SQL 2008. Steve recommended that you...

Leon, I would recommend you follow the advice by Toby. Though User connections will take a nominal amount of memory, you need to scale for the application and...

This means that a database is working correctly on SQL 2008.

You should do this in a dev environment first, then a UAT environment and test all of your applications.

Once you...