1) I would shut down sql server and other processes on the box and run chkdisk.exe (you can use -? to get options) to find possibly bad sectors on the...

1) Ninja hit it, and I doubt we need query plans to verify it. Your original code was set up to use nvarchar datatypes or joins and now you...

Are you trying to load to the free SQL Express edition? That has a 2GB file limit in SQL 2005/2008 and 10GB limit in 2008R2.

There is a very precise reason why your max used memory only gets to 1700MB or so. a) it is a 32 bit system, which under default configurations can...

1) consider moving your reporting off to another server. Log shipping is great for this if you only need say yesterday's data 'freshness'. Large-scale reporting against production databases...

Stop using maintenance plans. They have lots of issues, especially when it comes to indexes/statistics mx. Get the awesome, free and fully documented stuff from ola.hallengren.com

ksvr99 (7/25/2011)

---

Hi, I am new to SSIS. I need to pull data from EDW.

can you please tell me which connection manger (OLEDB or ADO.NET ...)do we need to use to...

Read the book(s) and any blogs/articles written by Allan Hirt.

I second the recommendation for using sp_whoisactive. See sqlblog.com for latest version and a 30-day blog series on how to effectively use the awesome free tool.

You simply must make improvements to your schema/data to allow you to remove the ISNULL(A, B) = something. Not only is it a CPU burn, it also voids index...

1) and (@filter = 0 or mas_id in (

That is a horrible construct for the optimizer. split this big mess into two separate pieces of code,...

>> One row can't be written on two pages. Keeping this in mind 8K was choosen as 4K would be too short and every row would have to be <...

Typically this wait indicates that the calling app is not consuming the rows as quickly as SQL Server wants to spool them out. Poorly written app, network bottleneck, overloaded...

Those two queries are NOT the same - one is parameterized and the other is hard-coded. This will absolutely lead to different plans.

Also, the after-some-time plan seems...

MudLuck (7/19/2011)

---

I have also read the article and it makes since that at the OS level only one thread can look a file at a time.

There for if...