just to confirm, from inside a trigger, you cannot always get the whole SQL statement; you can use DBCC inputbuffer, but that returns only the first 255 chars; a lot...

Colleen nailed it, I'll just try to explain:

There are several threads here on SSC on Linked Sserver performance;one thread which stated that openquery against a linked server was faster for...

As an FYI, i bought a recent Win7 HP laptop with 19" wide screen and full keyboard.

While i love the OS and layout, I get more Blue Screens Of Death...

well... start with the basics....if you want real help, you'll have to give real details.show us the exact code you are using.

comment out 99% fo the code , run the...

the section you pasted looks like it came from a .net config file. i think you're having trouble directly related to that....are you doing ASP classic or ASP.NET?

the connection string...

Mr Magoo I'd love to hear the back story on this...might be very educational for us....

what happened that made you start thinking something was flooding the server...after looking at the...

i realize this is probably a smippet, and not the whole page, but bear with me.

I do not see the connectionstring being assigned to the connection object, nor do i...

Khades (2/16/2011)

---

Oh Thanks, awesome!

What about question 2 though? Will having Child procs for the code to run parallel to each other improve performance?

And can 1 proc run parallel to itself...

not what I asked for , my friend sorry. Let me clarify.

I wanted to see the actual TSQL statement you are using.

show me something like this:

SELECT dbo.shift(somecolumn) as AValue, *...

if the temp table is declared in the parent procedure, the temp table exists for any processes or child procedure all as well.

each instance of the parent proc would create...

can you show the query that is using the shift function now? basically we are talking about joining that query to the shifts table directly, instead of using the function.

the default directory can be different on every machine.

take a look at the filepaths from this view:

select * from master.sys.sysaltfiles

TSQL does not have any ability to raise a prompt. technically,...

you'll really want to read the article; the master key is a prerequisite; once you have that, my snippet examples will work.

i *think* this will work no matter what?:

select...

remember a TOP without order by doesn't make sense...

to do the top 20 of the top 90%, it's just nested selects....

select TOP 20 * FROM

(

SELECT TOP 90 PERCENT * ...

these were my previous avatars:

favorite comic inspired 7 plus years ago

my dawg debbie was my avatar for years..

for the star wars period Gail mentioned.

reading on uglyoverload, time for a n...