>>Apparently  you are running with ANSI_NULLS = OFF.<<

Which is the right thing to do!

I wouldn't recommend to change that setting

SELECT tblTicket.Id, 'PA' + Right('000000'+ cast(tblTicket.Id as varchar(6)),6) AS TicketId, tblTicket.OpenDate, tblTicket.Createdby, tblTicket.StartDate, tblTicket.EstCompletionDate, tblTicket.ActCompletionDate, tblTicket.SummaryOfWork, tblEquipment.Equipment, tblSubNetwork.SubNetwork, tblLocation.Location, tblRisk.Risk, tblStatus.Status, tblTicket.ClosedDate, tblAdmin.Admin, tblTicket.Notes, tblTicket.SwitchingActivity, tblLocation.Country,...

declare  @rolename sysname

set @rolename = 'YourRole'

if exists (select * from sysusers where name = @rolename and (issqlrole = 1 or isapprole = 1))

 begin

  exec sp_droprole  @rolename

 end

HTH

At least it should generate good consulting opportunities to fix the mess ...

Agreed! I liked that part ... a lot

Yep, This "feature" has been the Achilles heel of TSQL for ages

Just so you know, the most frantically awaited feature for me from SS 2005 has a name: STRUCTURED EXCEPTION HANDLING

There is nothing like making sure that if something missbehave you are...

I've had some instances of this and you are not going to like my answer: "it depends"

The best bet is to debug and...

you could check @@transcount in TSQL

That type of encription has to be performed on the application layer not on the DB. Be careful because sometimes it has some undesired effects

>>Public access is a business requirement<<

There is something that you are missing on that statement. Public access is to the DATA not to the Server

1. You should Firewall your server.

2. Allow...

CPU --> amount of CPU time in milliseconds

Duration --> Time elapsed for the event in milliseconds

And yes, THAT is costly.

Can you:

1. check the execution plan of that process

2. make sure table...

First One comment. Collation is a paramerer in the setup that must always be a conscious decision.

When you have a server with US locale SQL Setup does not bother to...

You can use Mapsids.exe for the conversion

HTH

Duration is the time in ms that took that event to occur. For SP is the Duration of the RPC. For Table Scans is the Duration of the table Scan.

Beware,...

Well, if you stop the update even if it runs for ages then all changes will be rolledback there for no updates.

Now, let's concentrate on the rest.

1. Does the...