No idea, Gian! As i said above, i am just a junior dev, so not much into hardware/network related things!...

sql_lock (5/13/2010)

---

Gianluca Sartori (5/13/2010)

---

Heh, Mr. Coffee, virtual machines are horribly slower than physical machines.

There's a virtualization layer between your system and the physical resources: CPU, disks and memory must...

Jaffer, no while loops/cursors :-).. didn't my code work for you??

Thanks Gian for a fast reply! 🙂

My guess is right then, i was on a debate that this is not a code mistake, but rather the network/hardware limitation. Hmmm.....

wow, thanks for that! You're welcome! 😉

C'est Pras :cool:!

You're welcome, apat!

Deepak, here is piece that might get you what you want:

This code will produce the heirarchical output when IsFolder column is not taken into account

;WITH HierarchyCTE (ID, AssetName , ParentID)

AS

...

Deepak, the desired output image is not visible.. can u put the image as attachment?

You have to make use of Trigger for auditing purpose:

A sample trigger code:

Create an audit Table:

CREATE TABLE dbo.Audit

(

ID INT,

[Login Name] VARCHAR(1000),

[SESSION USER] VARCHAR(1000),

[User Name] VARCHAR(1000),

[APP_NAM]...

Also please take a cue from my post on how i presented the problem with the necessary sample, te table structures! This wil help the volunteers here immensely so that...

Hi there,

As Mike said, without any information of your system , it is very hard to work on your requirement! But still, i have coded a piece for you here....

Hi,, this is short but still performs your request

;WITH CTE as

(

SELECT MAX(TickID) AskSideRWsizeTickID

FROM #TABLE WHERE AskSideRWsize IS NOT NULL

UNION ALL

...

Friend, here is something of gift for you! From what i understood, this would help you

First the tables and sample data: (Please look how i post data so that it...

Friend, you have not provided the sample data for us to work on. I have created the sample data, the sample DDLs and have coded a piece. Please revert back...

I second George here.. Control the DELETE to be done in chunks! This will help you better!

Cheers!