Put indexes on the FK-columns of your dependant tables (if multi-column, provide exact order and sorting !). (1 index per FK !)

If you have cascading deletes enabled, you can delete...

- 1) the sum of both "Min server memory" ( 5092 *2 ) > (8Gb - 1 Gb)

        (the -1Gb is the space for the OS to run and manage the...

Multiprocessor box ? try adding with MAXDOP  = 1 (ckeck BOL)

(there is an issue with count(*) with sql2ksp3a)

As always the straight way has some curves.

Indeed, ms-office / vbs / ... are often not taken into account when considering security.

IMO...

The advantage of using group-by is that it can use an index if available and suitable. 

distinct is done by adding a sort-step before...

- Which sqlserver version is this being run on ?

- Can you post ddl with some data ?

- Can you post some (small) "correct" and "false" result sets ?

- Does...

take a look at :

 http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q220/1/63.asp&NoWebContent=1

 http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=107508

"C:\Program Files\Microsoft SQL Server\MSSQL\Upgrade\scptxfr.exe" /s yourserver /d yourdatabase /I /F c:\yourfile

rem SCPTXFR  /?  -  Command line help.

rem...

What's the goal of your function ?

- returning the "highest" membership ?

- returning the "last in sequence" membership ?

   (your current function)

- returning the "first in sequence" membership ?

maybe...

is the xp_cmdshell still open ?

exec xp_cmdshell 'net stop sqlagent' might be your weak spot.

Like Derrick Leggett mentioned, figure it out !

If your investigation points the symantics are OK, then you might use a case statement .

declare @col1 ...

- do you  have autoupdate-stats on (at db level) ? just run it once in a while.

We just run it once in a while (4 times a year) because autoupdatestats...

As you did find out, @@identity <> primary-key-info

afaik there is no way to have the "just inserted" primary key info returned, unless you write a query,... This however is...

I haven't used that combination yet.

We only use linked servers to non-sqlserver for problem solving. Only then the definitions are added and removed asap.

This is because we don't want...

Don't store concatenated stuff. It's not as adaptable as you might think.

Composite keys, don't have that huge downside.

If you want to have your newly inserted key returned by sqlserver...

not through sqlserver itself.

stop sqlserver service .

delete the mdf/ldf file

now someone is in deep sh..

Restore ?

follow the rebuildmaster procedure (see bol or ms-website)