Just to be clear, you are using sql authentication, right?

also, how are you running the packages, from BIDS? Dtexec?

How are you configuring the password? External config file?...

sp_help_revlogin

I'd use a script task instead of an execute sql task. It would be about 3 lines of c#.

If you add a mesage box right after the

assignment, do you see the changed value?

Edit: glad to hear you got it working.

I like the isnull datediff. Very elegant.

two questions:

Would that work in a filtered index?

"SARGable"?

Thanks.

Joining to a table on a single int clustered primary key is as about as efficient as it gets. ( clustered index seek)

Adding partition _id will bloat your non...

Maybe add a computed column for the datediff between the dates and index that?

no scans then...

As I said above, both articles are correct.

If you're using...

Yes, filestream data is backed up in a sql.

No, RBS only backs up the blob references, not the blob data.

both are correct.

http://blogs.msdn.com/b/sqlrbs/archive/2009/11/18/sql-server-remote-blob-store-and-filestream-feature-comparison.aspx

RBS is a client library that allows for store...

10 seconds on google says this is a timeout retrieving a connection from the connection pool...

Performance gain if data files are on different spindles. Sql uses the files proportionally based on free space in each file. Objects are spread across files...

found this:

http://www.sqlskills.com/BLOGS/PAUL/post/Turning-off-the-ghost-cleanup-task-for-a-performance-gain.aspx

I'm not recommending that you turn it off, but it mentioned that index reorgs and rebuilds will remove ghost records.

So, if you take the output from...

1100 rows seems way too high for 1 table (unless you have literally hundreds of...

You need to compare the physical index details from before and after the most current load:

can you post the results of this: (preferrably both before/after)

declare @tableid int

select @tableid = object_id...

watson_mike (9/12/2011)

Not a "Newbie" but definitely new to this issue. A year or so ago, a third party vendor set up a SQL 2005 2-node...