I'd use notepad to be honest

Then within the <Statements> element comment out using '<!--' and '-->' half of the child nodes.

Save that to a new file.

Do the same with...

Im not sure what your point now is..

1st post was about sqlserver not blocking , now you seem to take issue with it blocking.

The cause of the block is UPDLOCK...

Please post a query plan as detailed in the link in my sig below.

Is if for one statement ? or a batch ?

I think you should be able to manually remove out some of the StmtSimple blocks and you should still be able...

Try this link

http://www.sqlservercentral.com/articles/Development/recursivequeriesinsqlserver2005/1760/

Try this link

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

Why ? Not in , not exists or except can be more efficient.

Probably the rows in the dirty read wont be in the top 10 of your ordered...

You need to 'floor' out the time.

select distinct DATEDIFF(DAY,0,LoginTime) as date, [Applicationtype], [SystemUser] from DW.ServerLogonHistory

ORDER BY date

Try this

DECLARE @AA AS varchar(10)

SET @AA = convert(varchar(10), CONVERT(decimal(10,7),33.0000000/37.00000000))

PRINT @AA

Undoubtedly performance can be improved upon.

Your first port of call should be the users, are they complaining about speed ?

Note that most users will always complain that the system is...

Im no SSIS expert , but you can use variables inside it.

So i would suggest creating one as a rowid counter increment on each row, and another as a "groupid"...

alopeze (10/20/2009)

---

Now that you are talking something about the WLAN, when i execute this query in the local server the time is 1 second, but when i execute the query...

Can you not ask the expert that you have already hired ?

Hmm.. Dont see how that is true, as they effectively...