Is the ADO .NET destination a SQL Server DB? Do you get different results if you change it to an OLE DB destination? You can still redirect errored rows with...

You can also take a look at the below DMV for more information on how memory is granted for a particular query in your environment:

sys.dm_exec_query_memory_grants

There's a good article on the memory grant process here:

http://blogs.msdn.com/b/sqlqueryprocessing/archive/2010/02/16/understanding-sql-server-memory-grant.aspx

This article has about the best explanation of how the data is split across multiple data files in the same File Group:

Using Files and Filegroups

Effectively data is split ("striped") fairly...

Pretty simple:

select COUNT(DISTINCT u.userid) from users u inner join

status s on

(u.userid=s.mtid) or (u.userid=s.editorid)

Hi there. Glad you've had help on the forum and thanks for sharing.

So, is the purpose of this to highlight the UPDATE...FROM syntax?

That is a perfectly valid way of...

Nice solution Drew. I guess "it depends" on quite a lot of factors as to which would perform better (2 x Table scan + partial sort vs 1 x Table...

yubo1 (9/29/2011)

---

yubo1 (9/29/2011)

---

SELECT * ,

ROW_NUMBER() OVER ( ORDER BY ID ) RowNum

FROM #test where colC is not null

union

SELECT...

yubo1 (9/29/2011)

---

SELECT * ,

ROW_NUMBER() OVER ( ORDER BY ID ) RowNum

FROM #test where colC is not null

union

SELECT ...

You'll have to post some DDL and sample queries for us to help you further with this, otherwise we're wasting time guessing at what you want and getting it wrong.

As...

Or just a combination of case and Row_Number:

CASE WHEN Column IS NOT NULL THEN ROW_NUMBER() OVER (PARTITION BY Column ORDER BY blah) ELSE NULL END

But it's difficult to...

What T-SQL above?

Is this just to order NULL's last?:

ORDER BY ISNULL(CIT.Ind_Priority, DBO.MaxInt())

Could you at change it to something like:

ORDER BY case when CIT.Ind_Priority is null then 1 else 0 end, CIT.Ind_Priority

May...

I haven't used the WMI Event Watcher task specifically, but are you saying it's stuck on the event even when you create a brand new file in the target directory...

Ok, so these are COPY_ONLY snapshot backups.

COPY_ONLY means that it does not reset the differential base, so will not affect other backup sequences.

I've learnt something new here - I've...