To grant access to SQL Agent - you are not going to be able to use an AD group. You need to add each individuals login and it is...

If everything worked fine in test - what are the differences between test and prod? Creating a linked server is not very difficult, but installing the Oracle software to...

I just posted the same link on SQLTeam.com for the same question :w00t:

Format it in your C# code, see: http://msdn.microsoft.com/en-us/library/8kb3ddd4(v=VS.100).aspx#Y480

There are standard date/time formats available, but this should give you a good idea on how to accomplish this in your code.

Just wanted to add a couple of things to this. First, whether you build a script yourself or use one that someone else has provided - make sure you...

ChrisM@Work (8/3/2011)

---

pwalter83 (8/3/2011)

---

... display data where the ARRIVAL_SCHEDULE_DT is three months preceding current date when the ship first arrived at PORT_CD = 'BEZEE' (I work for a shipping company). I...

Can you run @@version for this instance?

Since you are running the Standard Edition - you will not have the option to lock pages in memory unless you are on the...

What I haven't seen yet is the memory and CPU specs for the server. That will also have an effect on performance here.

For a database that large, I would...

YSLGuru (8/3/2011)

---

The frequency will vary but it will be at least once a week I'd say but possibly more. Its used as our testing DB , something the developers,...

Just curious - how often are you going to be refreshing this environment? If it is going to be a regular scheduled activity I wouldn't bother with shrinking. ...

Be aware that this is only...

sree-879715 (8/3/2011)

---

No nothing is waiting on this spid..also blocked by and blocking is 0.

Thank you again for your reply.

Now, could you help me in the linked server setup to Oracle.

The...

Gail, I...

Another advantage to either option 3 or 4 is that you can test the whole process up to either renaming SQL Server or creating a DNS record to point the...

Ninja's_RGR'us (8/2/2011)

---

Bottom line is this. Don't use MP to do index maintenance. Steve pointed to an awesome, extremelly efficient way to do it.

Check out my full results with...