Statistics are stored in the system tables, not on a file group. They're stored in sysindexes which is always in PRIMARY, so groupid = 0.

JohnnyDBA (3/4/2010)

---

As far as using the GUI, it says online that if I update the location in the designer it'll recreate / swap the tables under the hood for me....

No way to say. Depends completely on your IO subsystem and, if you've got a SAN, that...

JohnnyDBA (3/4/2010)

---

That's strange... when I do a select from sysobjects where i specify the groupid all it's showing now are textimage indexes and statistics. Do you think these could...

Google SSIS Best Practices

I wouldn't necessarily say that's a best practice. Common practice, yes,...

The stats blobs are stored within the system tables, hence they will always be on PRIMARY and cannot be moved.

Why do you want to move them?

Clustered?

Easy enough.

There was no table partitioning in SQL 2000. It's a new feature in 2005, available in Enterprise edition.

What SQL 2000 had was partitioned views, views whose source query unioned...

I don't think there are right or wrong questions for most of those. They look like questions designed to explore what you know, how you've worked in the past, what...

river1 (3/4/2010)

---

This is a new database. I have created the database and then i have made a backup ,so, how can i LOSE transactions if a full backups as all...

river1 (3/4/2010)

---

When i make a backup of a database that is in full recovery model, when i try to restore it, through the GUI , the GUI does not let...

Moved here: http://www.sqlservercentral.com/Forums/Topic876858-338-1.aspx

That's why backups are important (one of the reasons)

If you drop a table within a transaction, the drop can be rolled back, just like any other change. Once the transaction...

r5d4 (3/4/2010)

---

The base table is access for the primary key by an 'Index Seek' too.

These Index seeks cost 4% , 4% and 1% respectively.

The columns returned from the base table...

For sec/read and sec/write, under 10ms is good. 10-20ms is average. Over 50ms is bad.