You might find the following articles/whitepapers useful -

Analysis Services Query Performance Top 10 Best Practices

Top 10 SQL Server 2005 Performance Issues for Data Warehouse and Reporting Applications

Scaling Up Reporting...

PM me offline w/ your e-mail and I'll send it - the WYSWYG editor on SSC appears...

gk-411903 (1/25/2010)

---

Thanks for the script. When i cut and paste the first SQL

(SELECT @@ServerName AS ServerName, ...

...

...

WHERE DATEADD(SECOND,X.checkrun,A.next_run) < GETDATE()

...

sqlquery-101401 (1/24/2010)

---

One of our sql agent job is getting hung somtime and keep on running and taking up all the server resources , for temporary mitigation befor the code is...

Thank you Suresh

I believe this is available as part of the SQL Native Client x64 package -

http://www.microsoft.com/downloads/details.aspx?FamilyId=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en

Refer to Modifying Data Through a View in BOL -

http://technet.microsoft.com/en-us/library/ms180800.aspx

You can use 2005 as a witness -

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

NP 😀

cathy.baker (12/16/2009)

---

Is there a query that I can run to determine what filegroup a partition number resides on? I used the $Partition Function to find the partition number. ...

For the archival or removal of old data, horizontal partitioning w/ a sliding window should be considered as well -

Correct. If your looking to use a remote table as...

mulle-78 (12/16/2009)

---

thx for response

and if I forget to delete a datafile with an aborted " DBCC SHRINKFILE (PTODATA03, EMPTYFILE)" command, the existing pages will be used by the DB, but...

In short, you can safely stop and restart an...

Refer to this thread w/ Jonathan Kehayias and Prash Shirolkar -...