-If you have BIDS you can just create a new integration server project and compose the stuff you want to using the import/export wizard.

-You could also just use SQLCMD to...

have a look at this SSC article http://www.sqlservercentral.com/articles/Administration/65896/ and see if it fits your needs.

With the extra "exists" clause it checks for existance of _any_ data in the query within the brackets.

Because I'm using a Correlated Subquery (check Books Online (bol) for "Correlated Subqueries")

I...

Brandie Tarvin (9/15/2010)

---

All this talk about the "rankings" makes me want to know what they are and how many points or posts it requires for each one.

Is it posted somewhere...

If this is for homework, please mention the url as a ref 😀

use mfCarlRepos

SELECT crn

, admission

, admdate

...

Any partitioning involved ... search BOL for "sliding windows"

GilaMonster (9/14/2010)

---

And you're obviously one of those...

As traced, not all stuff is traceble ....

Select *

from sys.database_mirroring_witnesses

order by database_name, principal_server_name;

This dmv contains the witness info.

IMO it is fed behind the scenes.

You'll only see the dbmirroring...

I think the best way may be to trace the witness at mirroring setup time and during a normal witness removal operation.

This way you may be able to find out...

Steve Jones - Editor (9/13/2010)

---

I shut down the thread. There's no winning that one. I suspect that the last few positive comments were friends, or the same person, putting up...

are you creating the temp table(s) itself within an open transaction ? (avoid if possibible)

ricardo_chicas (9/13/2010)

---

Actually my concern is that we have several dbs and ost of users, so I really need to be careful with the use of temp db, I like the...

I guess you mean you want no2 and no3 ! (both startin with john)

btw what's the distribution of your value '???'. In what kind of percentage does it occur ?

If...

You may also want to have a look at the xml plan for your query.

( SET SHOWPLAN_XML ON)

Search for implicit conversions as they may cause an index not to be...

just my 2ct:

Bit is context driven !

If your column name doesn't declare it by nature, you should document it well !

e.g. a column named "AreLightsOn" would by nature have a...