Viewing 15 posts - 5,371 through 5,385 (of 7,191 total)
ALZDBA (5/20/2011)
I had the impressions that would only be the case in active/active setups
You're quite right - I said active-passive but I meant to say active-active. I'll amend my...
May 20, 2011 at 5:57 am
Be aware that if you go active-active then your licensing costs double, since you have to pay for a licence for each node that SQL Server runs on.
John
May 20, 2011 at 5:34 am
Putting performance aside for a moment, creating a separate instance for Sharepoint would provide a couple of benefits. The first is that you can perform maintenance on your Sharepoint...
May 20, 2011 at 4:33 am
You can use the Derived Column transformation.
John
May 19, 2011 at 8:56 am
You can specify in your package at design time which configuration filter to use. If you want to specify a different one at run time, I don't know how...
May 19, 2011 at 8:31 am
If your parameters are stored in a table that looks like the [SSIS Configurations] table that is created when you enable package configurations for a SQL Server table, then you'll...
May 19, 2011 at 6:28 am
Since all those rows are from the same date, how do you decide which order they are in to calculate the running total? Please provide full table DDL (including...
May 19, 2011 at 4:44 am
Where is the drive to which you are backing up (D) - on your office server or on the SQL Server? If it's not on the SQL Server then...
May 19, 2011 at 3:37 am
Milda
If you have enabled package configurations in your package then those "parameters" should be passed in automatically whenever the package is loaded.
John
May 19, 2011 at 3:27 am
Make sure your SQL Server service account and/or SQL Server Agent service account have write access to the location to which you are trying to back up.
John
May 19, 2011 at 3:24 am
When you set up the trace, you need to make sure that the Audit Login Failed event is included.
John
May 17, 2011 at 3:23 am
Your best bet is to run a trace, either server-side or through Profiler. Make sure you capture the Application column (I think that's what it's called). How helpful...
May 16, 2011 at 3:54 am
Richard Williams-416852 (5/16/2011)
Only in IT could being a decent human being be described as "soft skills" 😉
Point taken, Richard, but I don't think it's only in IT:
http://en.wikipedia.org/wiki/Soft_skills
John
May 16, 2011 at 3:50 am
SanDroid (5/13/2011)
John Mitchell-245523 (5/13/2011)
Koen Verbeeck (5/13/2011)
Nils Gustav Stråbø (5/13/2011)
False, since they can be a mixed extent (or even an extent that has not...
May 13, 2011 at 7:23 am
You'll need to select the distinct values and join the result set back to the original table in order to get the value for name. You'll need to decide...
May 13, 2011 at 4:46 am
Viewing 15 posts - 5,371 through 5,385 (of 7,191 total)