There is no raw performance gain from having multiple filegroups on the same physical array.

  However, you can manage backups on different schedules to shrink backup times by placing tables that...

  To log in to SQL Server as another NT-authenticated user:

  1.  Find EM, Query Analyzer, etc. shortcut icon.

  2.  Shift+right-click the icon

  3.  Select 'Run as...'

  4.  Provide user/pass/domain info

  The...

  sp_OAStop will stop the COM execution layer, which should release all open references to your library - and every other active in-proc COM call as well.  See BOL for...

http://msdn.microsoft.com/sql/

Look for 'CTP' (right side of page).

It's not something built in to the current Reporting Services.  It's still possible, though.  In order to use a multivalued parameter, you have to do some extra work, and it's...

Instead of a 'report control', Reporting Services reports may be opened using the application designed for the report type - a web browser (or web browser control) for HTML reports,...

Ask the developer to look up "ADO.NET" on MSDN. 

Normally, when a solution involves xp_cmdshell, it's time to look at the solution.  There's often...

I think a better way of approaching this is to remove the HTML creation from the stored procedure completely.  HTML is usually display-tier stuff.

If you created the email engine, then...

I've been part of 2 separate SAN purchases at different companies.

Went with the HP (Compaq at the time) MSA 1000 at the first place.  It was loads cheaper than the...

If you're matching the sample code from the wesite you referred to, then line 12 should look something like this:

Set objXMLDoc = Server.CreateObject("MSXML2.DOMDocument.4.0")

The MSXML2.DOMDocument.4.0 object is part of MSXML 4,...

  So near, but yet so far away

  The only thing you need to do to get your statement working is to extend...

Take a look at 'Partitioned Views' in SQL Server Books OnLine.

Basically, you'll horizontally split your big table up into smaller tables, and then build a view that selects all the...

One of your params is off (just a typo)... try changing:

[....]

<IV00101

[....]

ALTITEM2="#ALTITEM2"

to:

ALTITEM2="$ALTITEM2"

We were getting the exact same access violation error/service restart several times over the last few weeks.

We were able to trace it to some large one-shot ad-hoc OPENQUERYs...

I admit this answer doesn't directly answer your question - how to add a sequence number directly into a SELECT statement, but it does provide that result.

This may not be...