Did you assign those permissions to the SQL service account?

Please have a look at those 2 articles I posted earlier - That should...

Have...

Have a look at these articles

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

It's worth noting that ALTER INDEX........WITH (ONLINE = ON) while it's not a magic button, it is an excellent option though.

When rebuilding indexes online, short lived, shared locks are...

SQL Geek (6/5/2013)

---

I am using SQL Server 2008 R2 on Windows Server 2008 R2 machine and the SQL is sending too much data from the network causing the website to...

Have a look at Itzik Ben-Gan's T-SQL...

TheSQLGuru (6/4/2013)

---

I didn't even reads your post honestly. All I saw was the title. Never, EVER use maintenance plans in SQL Server for ANYTHING that is covered by...

Can you confirm that you can access the drive with the transaction log is located?

You might be able to get to location of the log from this

select physical_name from sys.master_files

where...

If you're looking for queries that have previously executed with parallelism, have a look here

http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/01/19/tuning-cost-threshold-of-parallelism-from-the-plan-cache.aspx

Rauf Miah (6/3/2013)

---

I have a table with fields and data type like

companycode [nchar(4)] actcode [nchar(12)] vounum [nchar(14)] trnam [decimel (18,6)]

I like to build...

Do you have any FK's referencing that PK?

1. Install SQL 2005

2. Install SQL 2008

3. Take notes

I'm not trying to be hard with you but this...

My immediate thought would be to check the wait statistics on the server - It's not the most definitive way of checking performance issues but could possibly point you in...

This is something you can...