nihal9200_kwada (5/13/2013)

---

Hi,

We have two similar reporting servers. Lets assume them Server A and Server B

On Server B, one of the ETL package SQL agent job is failed due an out...

Many thanks for your time and thoughts

Many thanks for your messages but I'm not sure that this is the case, this works from time to time - Surely it would be an all or nothing scenario...

From BOL -

USE AdventureWorks2008R2;

GO

DBCC UPDATEUSAGE (AdventureWorks2008R2,"HumanResources.Employee");

GO

Hi,

Thanks for the response and apologies about the vagueness. I'll try to be a bit more specific.

The SQLCmd is getting the sql from a networked file using:

sqlcmd -S...

or you can use the transfer sql objects task in SSIS

Correct - 2 is not required

balasach82 (5/10/2013)

---

Thank You Ness. Finally someone replied. am reading the post.

Another Q. Can a package be set with more than one config settings, so at 2 different schedules, 2...

Have you re-started the server? This may be required

You would need to return all the fields in the data set but you could hide the unwanted columns and unhide them based upon a condition...or you could...

Thick and eager provisioned is the best bet to avoid disk fragmentation

This may help - https://blogs.vmware.com/vsphere/2012/03/thin-provisioning-whats-the-scoop.html

You can get SSIS to download all files from the site/local folder. This may help..http://www.sql-server-performance.com/2009/data-profiler-ftp-task-ssis/2/

Not sure that I can help too much, but I would advise against using all numeric aliases. Try amending the alias to SQL2008 and SQL2005 and see if that helps....

Try the NEAR expression. That may solve the issue if you search for the word windows near 8. I assume(ok, shoot me down now) it works with numbers

BOL - CONTAINS(column_name,...

RAID 10 should be better for write operations but a more expsensive option. RAID 6 good al rounder but slower for write i/o Thick disks are probably best.