If the procedure is trying to update and delete the data from the same table in two different statements and it is being called at the same time then this...

I think redgate has some tool to prepare the test data. you can chek the same.

andy.l (11/23/2010)

---

Hi

At occasions I've noticed that tempdb grows on one of my SQL Servers. And it keeps growing until either I run out of storage or I kill certain processes....

CrazyMan (11/23/2010)

---

Hi All

I have got a database which is of 1.3 TB, there is a main table which holds more than a...

Yes, either you can use 60 data sources and 60 derived columns then finally a union all or you can use a script component as source and put the DFT...

You can use a script component to read a file which needs to be used as a source. Basically you can read the first line as per the commas....

Thanks Roy. I have mostly worked on 2005. So, I was thinking, its the same in 2008. Thanks for the clarification.

Even it helped me to understand the internal principles of SSIS in a better way and how we can tune the SSIS package to get the best performance.

But, if you are an admin of the local system, then it should allow you to connect using the windows authentication!

Very correct. Probably thats the reason I suggested to go through the link to get a complete understanding and design the package accoring to the available resources and selecting best...

Well, it depends on the number of CPUs you are having. In Figure 6 of "Design approaches" section, you will find two additional union all which are redundant. This has...

But adding a semi blocking component will improve the performance. Check the following article. Hope this helps.

http://msdn.microsoft.com/en-us/library/cc966529.aspx

MDX can be used to pull the data from the cube, also you can update the values present in the cube(Consequently in RDBMS) using MDX. Yes mostly it is used...

Basically, what I meant is to use a connection string something like "Data Source=ServerName;Initial Catalog=DBName;user=UserName;pwd=Passowrd;". The user name provided should have the required access to fetch the data from the...

Rather than trying to fetch the data using the logged in user's autherntication, you can basically use a SQL server login. But the report viewing can be restricted assigning proper...