Hi Antonio,

I thought the comparison in Inside Microsoft SQL Server 2005: T-SQL Querying (p.241) that shows a benchmark between some different methods was interesting. In each case the ROW_NUMBER...

Based on the original post it's unlikely that IO would have much impact on performance; 250 rows in one table that has 3 columns would likely fit on 2 or...

As long as you're using SQL 2005 there are two things that could solve this: Common Table Expressions and the ROW_NUMBER function.

ALTER PROC usp_ShowPreviousNext( @myid INT)

AS

WITH myResults AS...

If the default trace is running you may be able to track that down since one of the event classes it captures is Object : Deleted. To find out...

I'm not aware of any functionality built-in to SSMS to let you do that. But with very little code you can use the functionality built-in to a web browser...

Setup a Flat File source to read into a single column. Connect that to a Script Component which will split the single column into multiple columns. Connect that to...

On the Control Flow canvas add a Script Task and connect that to the Data Flow task.

In the following example the Script Task loops until the file becomes available or...

Based on actual execution plans, the cost for this one is 30% compared to the original, but only if there is no index defined on ITEM.ITEM_ID.

If there is an index...

Try using @file_attachments = 'file_attachments' parameter instead.

When you want the results from an @query parameter attached as a file you'd use @attach_query_result_as_file = 1 along with @query_attachment_filename.

Yes, it's possible. In fact it's no less important to perform backups the same as if mirroring weren't enabled since the database is in the FULL recovery model. ...

My apology H.S. That last option has no relevance to your problem.

You say it's listening on port 1433? Does the PID from a NETSTAT -o -a -n command...

Is it showing as enabled when you run this?

exec sp_configure 'remote access'

A log recovery tool such as SQL Log Rescue might be something you'd find useful in situations like this. It's not a replacement for managing transactions but it can...

The reason it's taking so long is that the for loop is executed on each file and only returns after the last file from the collection has been looked at.

Exiting...

One way to defragment a heap is to create a clustered index on the table and then drop it.