Stored procedures are stored in one of the system tables. The system tables are all on the primary filegroup and cannot be moved. You could create a second filegroup for...

Robert klimes (6/10/2009)

---

if you want to rename the log file to have ldf extension

alter database &lt database name&gt modify file(name = &lt logical filename &gt, filename = &lt physical file...

Yup.

Just looked at the plan. There are incorrect estimates (too high) in a few places so that may explain the cost. Also, if you look, the first plan has paralleled...

The percentages and costs are estimates. They may not be accurate.

If the new query has fewer reads and a lower exec time then I'd go with that and ignore the...

Naveen Kumar (6/10/2009)

---

I have performance issue in my application. This view contains more than 5 lakh records.

Please help me how to create unique clustered index on this view. So that...

You say you want to replace the 3 SQL Server boxes with MySQL for cost reasons. What cost is there in keeping the SQL Server boxes? Your licences for SQL...

mazzz (6/10/2009)

---

How do South Africans feel about hosting the World Cup?

While it's not quite at Olympics level, it's got to be a very costly enterprise - I remember a lot...

chadowens777 (6/10/2009)

---

Right now we're just doing low hanging fruit (using the info from dm_db_missing_index* to identify key tables that need indexes) to remove as much latency where (simply and easily)...

Alvin Ramard (6/10/2009)

---

I was going to make a comment to you Gail about crystal balls but then I remembered you're not in the US.

A reminder for crystal ball users in...

It's OK. I...

T2000 (6/10/2009)

---

With a long uptime, I checked the index use and would like to drop the indexes which have zero user_seeks/scans & lookups. Such indexes are not used and are...

Please post full table definitions, index definitions and the execution plan. To get the exec plan on SQL 2000 add the following before the query and run it.

SET STATISTICS PROFILE...

Sorry, crystal ball's on the fritz again.

Hmmm. Could be literally anything from the app to the client machine' hardware to the network to the database and beyond. Really, there's absolutly no way of telling what's wrong...