Another very good reference of the differences between temp tables and table variables is at:

http://dba.stackexchange.com/questions/16385/whats-the-difference-between-a-temp-table-and-table-variable-in-sql-server

Knowing which to use will depend upon knowing the differences between each.

A good place to start is at:

http://beyondrelational.com/modules/2/blogs/28/posts/10279/xquery-labs-a-collection-of-xquery-sample-scripts.aspx

and also

http://www.simple-talk.com/sql/t-sql-programming/xml-jumpstart-workbench/

anthony.green (4/24/2012)

---

two ways

your right, it wont speed anything up but if you backup twice the first backup is worthless as you cant apply any tx logs to it after you...

Following an upgrade from SQL Server 2000 you also need to run

DBCC UPDATEUSAGE on all upgraded databases.

For reference look at Best Practices on:

http://technet.microsoft.com/en-us/library/ms188414(v=sql.105).aspx

This may not be related directly...

If all you are doing is Physically moving the Server but retaining the Same FQDN and IP address then this will work.

The possible issues are

(a) Enough space on log...

Hi _UB

In order to get information on total memory used then there are two sources of information

(a) DBCC MEMORYSTATUS (see http://support.microsoft.com/kb/271624)

(b) sys.dm_os_process_memory ( see

Have a look at the following article from Jonathan Kehayias

http://www.sqlservercentral.com/articles/Security/68873/

This sets out the possible methods for using sp_send_dbmail

Hi Vamsy

If you need to understand/set up clustering then some of the best places to start are:

Allan Hirt's Website - http://www.sqlha.com

Allan Hirt's Book - Pro SQL Server...

Hi PhilipC

You set Max Memory based around leaving sufficient Memory for OS (eg if OS needs 8gb then set MaxMemory = 56GB)

You then set MinMemory to allow for case...

If the intention is to reduce or remove the use of extended stored procedures then replacing the xp_cmdshell with xp_DirTree is not really gaining much. However the xp_DirTree will have...

If you are on SQL Server 2005/2008 then you can consider using SQL CLR procedures to replace the XP_Cmdshell functionality.

The book "Professional SQL Server 2005 CLR Programming" has...

The Security buletin MS08-040 adds a number of additional builds

For SQL Server 2000 we have build 8.00.2050

for SQL Server 2005 we have build 9.00.3233

See http://www.microsoft.com/technet/security/bulletin/ms08-040.mspx

Regards

Patrick Flynn

I had already paid this year before the discount code came out so that was of no use :).

However I would be happy to pay via Paypal, if only as...