Viewing 15 posts - 256 through 270 (of 279 total)
Typically, that error happens when ssis can't decrypt with the user key. If you aren't getting that error, then enable verbose logging and try again.
are you...
October 11, 2011 at 4:50 pm
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?...
October 10, 2011 at 10:57 pm
sp_help_revlogin
October 10, 2011 at 10:42 pm
I'd use a script task instead of an execute sql task. It would be about 3 lines of c#.
October 10, 2011 at 10:26 pm
If you add a mesage box right after the
assignment, do you see the changed value?
Edit: glad to hear you got it working.
October 8, 2011 at 10:51 pm
I like the isnull datediff. Very elegant.
two questions:
Would that work in a filtered index?
"SARGable"?
Thanks.
October 8, 2011 at 10:11 pm
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...
October 8, 2011 at 9:43 pm
Maybe add a computed column for the datediff between the dates and index that?
no scans then...
October 8, 2011 at 9:10 pm
As I said above, both articles are correct.
...A separate solution, implemented at the scope of the BLOB store, must be implemented to ensure the availability of BLOB data.
If you're using...
October 5, 2011 at 7:04 pm
Yes, filestream data is backed up in a sql.
No, RBS only backs up the blob references, not the blob data.
both are correct.
RBS is a client library that allows for store...
October 5, 2011 at 2:45 pm
I getting an error from appllication side is No ManagedConnections available within configured blocking timeout
10 seconds on google says this is a timeout retrieving a connection from the connection pool...
October 5, 2011 at 1:30 pm
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...
September 30, 2011 at 5:44 am
found this:
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...
September 29, 2011 at 1:20 pm
LAW1143 (9/28/2011)
the ghost_record_count query has been going over 5 hours now and has over 1100 rows.
1100 rows seems way too high for 1 table (unless you have literally hundreds of...
September 28, 2011 at 3:14 pm
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...
September 26, 2011 at 9:24 am
Viewing 15 posts - 256 through 270 (of 279 total)