I agree Jeff.

Rog, this is not an avenue for your marketing campaign. Rather say something useful...or don't.

Yes, that is probably the case.

I would not advise you to force the query to use a specific index. Rather structure your indexes so that the optimizer chooses the correct index.

There are always exceptions to the rule...

The above comments are good advice. I will also update statistics on the table(s)/indexes referenced. What happens sometimes is that the statistics on the particular table is outdated and the data...

I might be sending you on a wild-goose hunt, but it sounds like your application might not be closing its database connections properly...

You will probably have to write a vb/java script that:

• opens the file after you have populated it
• moves to the end of the file and check whether it is a carriage...

Hi,

Your domain password is the password you use to login to your network, or your local pc for that matter (if it is on a network).

To delete the SQL Server registration:

Right-click...

We have had similar issues sometimes when using Windows Authentication and our domain passwords expired and subsequently changed. For some reason it seems like the domain controller have not yet...

Hi,

The best thing to use here after you have your filename in a global variable is a dynamic properties task. You will see it on the left hand side in...

There is a way to do it, but its a bit of a hack. DTS will not give you the option to query a text file connection, but it will...

Hi,

It shouldn't take that long. I import csv files into our datawarehouse with a size of about 5GB, and it takes a couple of minutes.

You need to look at...

Hi, it is not necessarily incorrect. SQL server will hold on to allocated memory if there are no other processes requesting memory, and will do so untill another process wants...

In my experience, the following works very well:

• Firstly, you should try and separate your staging area into a separate db. This allows you to have a different backup strategy etc...

Yep, we indeed have a VVLDB...and it makes management and maintainance very interesting. Simple operations take forever because of the pure size of it, and planning becomes essential for even...

Hi,

This is a difficult question to answer and is very specific to the kind of system and business you find yourself in. In my opinion anything that gets to the...