Use xp_logininfo:

exec xp_logininfo '<groupname>','members'

you can get fancy and cursor loop through all the groups on the server with the output going to a table so you can query all groups...

I was a sysadmin on multiple operating system prior to starting my life as a DBA. The standard practice is to run each application or serivce under its own authoriy...

You can also do it with a script task

using System;

using System.Data;

using Microsoft.SqlServer.Dts.Runtime;

using System.Windows.Forms;

using System.IO;

using System.Security;

namespace ST_2da1df7a40444805b38756f999ec1765.csproj

{

[System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]

...

Did you modify any settings in SSMS? The default execution time-out is 0, which is unlimited.

Yes, SSIS does not have any requirements as far as what tasks you use. We have a few packages that do nothing but call stored procedures and run VB script...

It sounds like other queries are foring the object of memory. SQL will have to pull from disk next time you run. Repeat the query a second later and it...

update Orders

set O.address = V.address,

etc

from Orders O

join Vendor V

on =

where O.Status = pending

As always... It depends

If you have an OLTP like a sales web site, RI is critical to avoid loosing customers information.

On the analytical side, is is common to drop...

I can't say for sure without looking at the exact statement it is running, but SSMS will initiate background checks for different operations. If you go to the index rebuild,...

WheelsGuy (2/25/2014)

---

EricEyster (2/25/2014)

---

close.

the statement from variable would be used if you have a script task that assembles the full query text. That is not the case here. Use "Direct Input"...

sometimes this comes down to being able to maintain the code in the future, as it sounds like your will be finding new issues as time goes on. If you...

close.

the statement from variable would be used if you have a script task that assembles the full query text. That is not the case here. Use "Direct Input" and paste...

qew420 (2/25/2014)

---

Please see below my answers:

Do all the tables have the same columns? NO

Do all the tables have a single column for filtering the last quarters? yes there is...

When you say "700k times in a relatively short period", how many selects per second do you estimate they are running? SQL is fast, but I can kill a box...

WHEELS,

I hve BIDS open to refresh my memory on this. On task 1, the select from the source, look for ResultSet and select "single row". This will enable the Result...