In theory doing a TOP N without an Order By could pull different results every time regardless of using nolock.

I just did a quick test on my version of AdventureWorks...

Thanks, now you got me sucked in. I agree with the others,...

forumdog (11/18/2009)

---

Alot of very rude and what appears to be blatant disrespect and rudeness so far. Okay you arrogant and unhelpful people. May life and God show as much caring,...

You can use VSS with SSIS. I have done it.

It depends on what events you are tracing. If you are tracing RPC:Completed, TSQL:BatchCompleted then you have textdata which shows the query that they are running.

You could do that by doing an DBCC CHECKIDENT() (See BOL for details), but it is really not the best way to do it. I'd be more likely to...

I would add a second step within the 4 each file enumerator and move the processed files to an archive folder.

You should be successful with the data conversion transform by converting the column from unicode to non-unicode.

Switching to 2008 and using Filestream may help.

You could also create a new filegroup and move your single table with the BLOB data to a file in that filegroup. ...

I'd agree with the posts thus far. Cursors are often necessary for administrative tasks (backups, index maintenance, etc...), but rarely if ever needed for data retrieval and modification. ...

You could query it out of msdb using a linked server. Something like:

SELECT

B3.physical_device_name

FROM

linked_server.msdb.dbo.backupset AS B JOIN

linked_server.msdb.dbo.backupmediafamily AS...

This is a duplicate post and there are other answers here.

You did not include the foreign key definitions with your table scripts. Based on what you did share, I would guess that the problem is that the CapturedDate you...

Great series Gail. Glad you mentioned the index intersection in this article, I've always had questions about that.

We still need the table definition and sample data like Gail (GilaMonster) asked? Your execution plan shows a clustered index scan, which essentially is a full table scan, so...