Chris Morris-439714 (4/14/2010)

Tom.Thomson (4/13/2010)

Mimsy.

Anyone...

You're welcome.

That would sure be nice. Maybe the IPad would qualify?

Yes - check your SQL that is running. Check your Oracle tables and check your Oracle indexes.

Have you looked at the TSQL to optimize the code? The problem you are encountering seems to be a problem in a poorly written query. You need to...

WayneS (4/13/2010)

The entity known as "The Thread" randomly...

I didn't see this - until after the deadline for TSQL Tuesday.

Is this something you will be doing each month? It might be good to get it out there...

You can try connection_id which is a uniqueidentifier. The login_time is not technically the same as start_time since a request can contain spawned processes that start at different times.

Caution...

I agree with Elliott. Yes - learn SSIS. .Net is useful in many ways, and SSIS is useful for dataflow type tasks.

Oddity in the forums. I just noticed that I lost 27 points today. Am curious where they could have gone.

Did this thread disappear from the forum listing? I couldn't find it without having done a search.

You're welcome.

I hope it helps.

I agree with Wayne. I am fine with development being a sandbox for the developers - so long as proper checks and constraints are in place to pass code...

Yes, the permission can be granted to all in a single statement. However, the preferred method is on a proc by proc basis.

You should speak with the administrator that...

T¦«