Why dont you save them as .sqlplan files and upload them again ?

Also - upload plans for both. The faster plan and the slower one.

idk about Jeff, but it seems to be a 30 KB xml file that when I open up using management studio, just brings up a blank page. I do have...

kapil_kk (11/22/2012)

---

I treid to install the Adventure Works sample database in my system but am not able to install that..

databse is creating with blank tables but no data is getting...

You could create the new group in Windows AD or you could add the two logins to a database role and assign the permissions to the role.

arkiboys (11/23/2012)

---

Hi,

How do I make the users group i.e. domainname\users to be able to only select from tableA but user1 and user2 to have full control on it?

Note that user1...

sp_spaceused

Not sure what you mean by "no longer with the table"..? if the tables were dropped, the constraints would have gone with it, unless they were a default, created separately...

There is no doubt that the additional backup is occurring. Why dont you profile the backups and see the application name ? Is it possible that another job is kicked...

You can use sp_msforeachtable with a custom sql, something like this:

http://www.sqlservercentral.com/Forums/Topic1038522-146-1.aspx

Guru Nagabhushan (11/20/2012)

---

Some questions:

1. Is the backup occuring to a network share or local disk / SAN ?

2. Since this is a maintenance plan running on SQL Agent, did the...

Your file transfer speeds will never match SQL Server backup / restore speeds number for number. There is more work that SQL Server needs to do when doing the backup...

In my experience, I've had that happen when the SQL Agent service account was locked out.(Another DBA was using the service account for administrative work and typed in the wrong...

You can create an index, however, there are a lot of conditions that need to be satisfied before you can do that. Some of them are:

1. Underlying table and view...

Some questions:

1. Is the backup occuring to a network share or local disk / SAN ?

2. Since this is a maintenance plan running on SQL Agent, did the serviuce account...

Sean, From the initial problem description, it looks like the second table does not have the(or any) primary key, which was my assumption to start with. A direct update in...