With few execptions (bulk inserts in the bulk-logged recovery model), all database changes are written to the log first.  Later, another process captures those changes that have been committed and...

Using it for what purpose?  Reading in XML?  Producing results as XML?  Using the SQLXML ISAPI framework with template queries?  Updategrams & diffgrams created with XSLT transformations of inbound XML...

Eight years ago, answering this question spawned an entire industry.

You could put something together with a derived table, by adding a column to your original query, wrapping at all up...

> What do you mean by foreign key column?

In an enforced relationship, there are two sides to the equation:  The parent table (such as a list of customers), and the...

Create a nonclustered index on the foreign key column(s).  Then the relationship-checking will use the indexes instead of running through the entire table.  SQL Server automatically creates an index on...

If I were an internal admin, and it would be my butt on the line or me getting the midnight call when there was a problem with the server, then...

It's stored in sysindexes, although that number isn't always up to date.  Take a look in BOL for the system stored procedure sp_spaceused for the recommended way to retreive that...

> Running the declare before executing the stored procedure worked in Query Analyzer, but I don't know if that can be done from a .NET application. 

When you are building...

I've had the same problem in the past when I forgot to create any of the CHECK constraints on the partition columns using the WITH CHECK clause.  That's very important. ...

For your error in the first case:

   Server: Msg 137, Level 15, State 2, Line 1 Must declare the variable '@outparam'

Did you get this message when creating...

Take a look at GROUPING and ROLLUP in BOL:

SELECT CASE WHEN GROUPING(IVAN8) = 1 THEN 'All' ELSE IVAN8 END AS [IVAN8],
       CASE WHEN...

Views and stored procedures serve different purposes, it is difficult to compare the two.

The primary purposes of views is to simplify data access (by hiding the details of joining several...

If you see that you will often join the document table to the client table to look up client information using a DocumentID, when you have no need to also...

You need to include an ORDER BY:

ORDER BY [Header!1!Id], [Child1!2!Child1Id], [Child2!3!Child2ID], [blah!blah!blahId]

-Eddie

I rolled the following procedure a few years back for the same thing.  I place it in the master database and use the sp_prefix so I can call it from...