err...Understatement??:-P

Who pays for the trip. :-P:-D:-P:-D:-P

Being the multicentair that I am, it would seriously depend on time of year, who else is...

Roy Ernest (3/8/2010)

---

Thanks for giving me a count on the number of attendees for SQL Saturday.

A theoretical question....

If a SQL Saturday was arranged in our tiny island of Curacao,...

hmmm.

Jason must not be paying attention. I thought George...

george sibbald (3/8/2010)

---

You know, I was just thinking,

It really frustrates me when people post replies and repeat almost exactly what I said minutes or hours earlier

does anyone else feel that...

I suggest creating the maint plan first then. Once the maint plan is done, then I would either create a new SSIS package, or alter your maint plan from...

Here's another script. This uses the suggestion by Ron.

Declare @DBNamevarchar(50)

Set @DBName = 'YOURDBNAME'

Select Db_name(ps.database_id) as DBName,object_name(ps.object_id) as TableName,I.name as IndexName

,sum(isnull(ps.avg_record_size_in_bytes,0) * isnull(ps.record_count,0)) as IndexSizeBytes

,sum((isnull(ps.avg_record_size_in_bytes,0) * isnull(ps.record_count,0)) /1024/1024) as IndexSizeMB

From...

To create a Backup Plan

http://www.databasejournal.com/features/mssql/article.php/3665841/Microsoft-SQL-2005-Maintenance-Wizard-Part-3.htm

To manage the files on disk:

http://www.mssqltips.com/tip.asp?tip=1094

ramadesai108 (3/8/2010)

---

I Apologize. The reason why i started this thread is because the previous thread is under Administration. I have not received any solution from there so i thought a...

dbychen (3/8/2010)

---

The questions are very common and everything depends on your situation. There is a range of best practices white papers available for this topic.

"how do you come to the...

Does that mean you figured it out?

dohomebiz (3/8/2010)

---

Ok I am executing the following statement

select * from detail

and gettign the following error

Major Error 0x80040E37, Minor Error 0

> select * from detail

The specified table does not exist. [...

Do you receive any errors?

Good question.

I think this last one hit 1000.

I think a key...