Viewing 15 posts - 91 through 105 (of 575 total)
Brendt,
Excellent stuff! I now understand why.
So, obviously the query optimizer chooses a different execution plan & method between NOT EXISTS & NOT IN?
November 29, 2006 at 6:37 pm
Ok thanks for that RH. It looks like you can actually modify the SSIS Package via SSMS instead of doing it through BIDS.
I'm trying to understand SSIS as it is...
November 14, 2006 at 3:12 pm
Ok thanks for that.
So What if you are running SQL Server 2000 Standard Edition on Windows 2003 Standard Edition? How much RAM can SQL Server 2000 use with Standard Edition...
November 13, 2006 at 5:07 pm
I don't understand the @numDays input parameter!
For example if do this,
DECLARE
@Date SMALLDATETIME
SET
@Date = dbo
November 9, 2006 at 5:57 pm
Thanks for the reply.
I tried whta you said but I get the following error when I click on the MSDB folder.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for...
September 27, 2006 at 6:21 pm
Ok thanks. I thought that perhaps I could restrict the jobs that a user can use.
September 7, 2006 at 11:06 pm
PW. I'm going round in circles. Can you please give me an example as I'm confused as to how to incorporate your suggestion with my
SELECT @maxId = MAX(ExternalId) FROM focus_transaction_classic..Policy_IdGenerator
@maxID...
August 24, 2006 at 9:00 am
It looks complex but i'll try it.
Remeber that the key thing here is that I need to increment @maxID by 1 for each row.
August 24, 2006 at 8:32 am
SQL Delta is another from http://www.sqldelta.com
July 25, 2006 at 4:59 pm
Better still, plan to confiscate Sybase and migrate to SQL Server.
July 19, 2006 at 10:09 pm
Viewing 15 posts - 91 through 105 (of 575 total)