and we could say the same in the UK for our national...

can you post the contents of an sp_who2  - we don't have much to go on

also is it sql that is using the CPU or another process - how are...

I've always found the following points be in favour of artificial keys

if my key is "firstname, surname, dateofbirth" then for every linked table I have to use 2 varchars and...

I made that same mistake - steve didn't...

hardware ?

SQL instance configuration ?

T-SQL code ?

Table design and 3NF?

you have to give us a little more about your problem so that someone can help you - I could go...

dammit - I pretty much only use persisted computed columns (we write once and read many)… so my version worked - I took out the persisted and it errored

Ian

unless i misread the original post (I've done that a lot) , they want a trailing zero not a leading zero

good shout sterling. It's got to be either network transfer or disk.

for network transfer, log onto the desktop and make sure your connection is using the shared memmory protocol (not...

one trick i use... Does it hang before the first row comes back, or start sending results and stall?

if you get nothing for 10 seconds I'd put money on compiles.

if...

the best I can suggest is reverse the string, do a charindex for the first colon :   then you know if there are only 2 digits for milliseconds

if it's...

check in the database settings if you have "legacy cardinality estimation" turned on - also if you can change the database compatability mode you may get some better results

i'd forget...

just make sure no-one tries to put a stored proc call inside the trigger making an assumption that it is single row only.

I've inherited triggers where they have put checks...

is the locking at the sql level (ie in sql monitor or sp_who2 you can see a blocked process)???

I know with 1000 reports it's not feasible to go through all...

Wow,

I just came off the back of speaking at data relay in Nottingham on this topic

we've been in business since 1851 (ok it was a bookshop back then) and most...

I can see you are using a string split function - the longer the string, the worse that function will perform.

although the number of UNION ALL statements in there will...