Gail could you please clarify:-

If a second update statistics should be added even if auto updates statistics is on?

He didn't want to use the GUI tool 😉

Use:-

Select ServerProperty('ComputerNamePhysicalNetBIOS')

Have a quick google for FIFO (first in first out) and LIFO (last in first out) which are the 2 main options for stock control.

We get these when a user changes their password and then try to connect to SQL server.

A simple user reboot and all is OK again.

Many thanks for the link.

Thanks for the replies.

We are trying to get a handle on who is using Office applications to connect to our databases.

Users have an application that connects to several databases using...

Keep it old school and use tablediff.exe that comes with SQL Server.

A lot of large production shops probably have 24 hour cover or are monitored remotely.

They would then call the on call DBA directly as you can't always guarantee hearing an...

Glad to be able to help.

They are a frequently over looked feature. We have also used them for archiving when we have a vendors database - the application has no idea the data no longer...

Hi,

You could have a database that holds your code which uses Synonyms to the 'real' tables. We have done this several times and it works great. That way you just...

Just a quick follow up question:-

How would it handle a mirrored database which is obviosuly FULL recovery model?

We have a requirement for faster backups / restores but still need our...

Thanks all for the excellent replies.

Developers have been locked back in their cupboard for the rest of the year.

Starting to make a bit more sense but even with "set statistics time, io on" the output is identical.

Unfortunately having to explain to developers that I cannot explain the difference...

Ah thanks - they are identical i'm afraid 🙁

(1 row(s) affected)- MAX only query

Table 'T_BIR_RUN'. Scan count 1, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads...