Yes the inserts takes 6 hours to complete.

Basically I want to know how to use more than 1 dialog to make use of parallel processing.

The same query will work with two rows. The actual scenario has 100’s of data.

I have used order by Len(name) desc so that AA will come first, but since order by will apply atlast, it will not work.

One option I have in mind is...

Thanks 🙂

Sure 🙂 But can you explain this as we are having problem with some developers arguing that physical reads are the one to be looked for and we can safely...

Try the If condition

IF Boolean_expression

{ sql_statement | statement_block }

[ ELSE

{ sql_statement | statement_block } ]

Can you please elaborate on this ?

Thanks guys for the very valuable inputs.

Checked Memory, CPU, I/O etc.. and finally came to the conclusion that there is no issue with the hardware and the problem is in...

Updated statistics on all tables in the database and still not much improvement in performance. Any other suggestions ?

No. let me just try updating statistics on all tables.

I'm looking for a script to clone each login with server and database permissions.

Gathering object level permission(using sp_helpprotect) on each database is not practical in our case, as there...

All these logins are SQL logins. The script you referred to is exactly what I needed. (a script that will query a login and generate all server and database permissions...

So what you are saying is after scripting the Logins, I have to change username/password manually(to clone the login). After doing this I will have to run the above script...

The login has db_datareader permission on all databases.

Thanks a lot guys for your support. I can see the permission for...

Strange ! GRANT VIEW ANY DEFINITION was run against a Login and it was run in master. Still the permission does not reflect in other db's. Am I missing a...