Hello Chris,

No, I mean, if you do a trace you probably see that SSIS is sending such a command to SQL Server, before issuing the SELECT *...

I mean, SSIS is...

chris.stuart (12/10/2009)

---

Then I went to check in the sql database on the user id which is used to run the SSIS package, to my surprise, I found the following statement...

That is the Web Session time and has nothing to do with your database connection.

You have Query Timeout on your...

I would first look into How it is connecting, what is Actually giving the timeout and where in the code. On a lot of connections there are Query timeouts, connection...

SQL_Monster (5/18/2009)

---

Dear All,

According to J-F am done with the changes like improved CPU RAM for 5Gb as it was only 2GB earlier.

Need to change the equery timeout and the application...

Have you actually looked into anything of the above? Indexing for example? Eliminating Full Scans?

Hi!

This should be a moot point since it is violating common normalisation. The field contains more then one data value and should not have to be split up to be...

http://www.sommarskog.se/dynamic_sql.html

I am for FKs and all constraints necessary. No way an application should be the only one handling this kind of checking.

Other reason would be the JOIN elimmination that SQL...

Help coming.

Don't kill sleeping SPIDs if they are more then 2000-3000... You have enough memory and sleeping SPIDs are not always bad by themselves. Read on it in this forum...

Ed,

If that if your traditional answer I would say traditionally it is wrong 🙂 What you then are assuming is that your table is only going to be accessed by...

If you are into partitioning, which I hope you are with your kind of question, I'd recommend that you should look into SWITCHing in your table data. Then dropping your...

Anand S (5/8/2009)

---

Hi Brian,

I am facing a similar problem in my project - I don't see the issue in development, but when we move to...

bkDBA: I do not really agree with where you are coming from. Maybe SQL Server 2k8 will give us the inherent backup compression needed for VLDBs but previous versions...

Thank you for the article!

But we have hundreds of DoubleClick archive and every single one I have tried so far, that is smaller then an unsigned INT (bytes), works....