the row counts are already materialized in one of the system tables, so if you query that, it will be boatloads faster than querying each table individually:

Select

...

there's no need for a cursor on this, but I think youa re right, you will need to pivot the rows to columns;

is there a fixed number of answers for...

here's the script I mentioned that blindly builds the SQL statements to create indexes on any foreign keys that do not have indexes on them yet;

any peer review would be...

i like all the examples so rar, but make sure you search for <table without the ending > tag.

if the table has a class, a css style or even older...

Steve Hendricks (9/28/2012)

---

In re: "it's the selectivity of the data that is what the SQL engine uses to determine whether to use an index or not."

For SELECTs that would be...

I'm pretty sure the settings are stored in the

%appdata%\Microsoft\SQL Server Management Studio\11.0 folder in the SQLStudio.bin file.

If you use any applications that clear out temporary files to recover some...

ouch, there is seriously no "easy" way on this then.

to the best...

blindly adding an index on all the columns that foreign keys are involved with might not help much;

it's the selectivity of the data that is what the SQL engine uses...

well, like Ron/bitbucket said; there's many formats to an EDI file; somewhere someone on your side should have put together a document mapping out each element;

once you have that...

why to a text file, and not a table in say, the msdb database, which can contain a suite of commands for you to run during you rmaintenance window?

why must...

wedgemail (9/28/2012)

---

I dont think Im being clear

I know how to get it to run(add a linked server) but my question is how can

this code run successfully:

SELECT 1

FROM EWH_Staging.dbo.STAGE_REMP_VCC_Distinct vcc

It...

formatted a bit for readability;

similar to some EDI files I handle, it looks like the tilde(~) is the delimiter for message segments;

the ISA segment is a control header for "who...

tauseef.jan (9/28/2012)

---

Thanks guys, especially Lowell for the code snippet.

Actually I need, when a user creates/restores a database on the server

he should be automatically be assigned to db_owner role.

...

in that case, being on a remote server, you need a linked server so you can get to it.

and the...

tauseef.jan (9/27/2012)

---

hi friends,

I need to create a server trigger to automatically map a login to a new database and make it a member of the db_owner database role.

I was trying...