It won't fix it any more: take a look at this entry on connect.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=386810

It looks like Microsoft has announced that for SQL 2008 SP1...

I think this is a strategy issue rather than strictly technical.

I suggest you take a look at this

http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm

whitepaper from Kimberly Tripp, which focuses more on the strategies regarding filegroups...

Oh, I see. Well, I'm no partitioning expert, but I don't think you can partition tables "together", but you will have to partition each table on its own and then...

I think you will find the response to your doubts in this article.

http://technet.microsoft.com/en-us/library/aa964122(SQL.90).aspx

Hope this helps

Gianluca

I think you mean Express Edition. Enterprise Edition is the most expensive one.

A subset of Visual Studio 2005 is bundled with SQLServer and tools are bundled with SQLServer. VB6 is not needed, unless you are planning to code with it, which I...

I suggest you start from reading on the topic. There's plenty of resources out there, starting from BOL and technet.

I found this[/url] article very helpful.

This one is also very interesting...

What do you mean "SQL Server Software"? Is it SQLServer Management Studio or what? If this is the software you need, it is bundled with SQLServer (2005 or 2008) itself....

I use JTDS http://jtds.sourceforge.net with SQL2008 and I have no problem.

It's not designed or certified yet for SQL2008, but it works.

Hope this helps

Gianluca

I recently had the chance to read this blog on the topic and I found really helpful.

Hope you find it helpful too.

Gianluca

I suggest you start from reading on the topic. There's plenty of resources out there, starting from BOL and technet.

I found this[/url] article very helpful.

This one is also very interesting.

Hope...

I'm sorry I can't help you any further, 'cause I'm no AS400 expert, but I suggest you consider buying an OLEDB provider for this task.

I don't know all of them, but there are some small differences between "regular" SSMS and express. Nothing that will prevent you from doing your job, but some strange little...

We have the same configuration: AS/400 and SQLServer 2005 x64.

ODBC has always been slow in our environment, so we had to buy a OLEDB provider, which is much faster.

Now...

DECLARE @answer varchar(8000)

SELECT TOP...