Hmm, yes of course. Is it not at all possible to say it that way in English, or was it just that in that context it could be interpreted the...

In some cases that is true. But not if the object is stored in multiple files, since then the algorithm for calculating extent scan fragmentation does not work as intended.

Even...

You should be sending the value as a correctly typed parameter. That way you use the web server's settings to parse the input and create a typed value, then supply...

As I implied above, it is impossible to give advice without knowing the specifics, because 'it always depends'. We can only make guesses. But the way I understand your question...

Yes, whenever you are using a relation DBMS you should design correctly. It saves you time, gives you the best performance in most cases and most importantly avoids problems with...

You are talking about application requirements. How the application works has nothing, absolutely nothing at all, with how the data should be modeled. The database is a collection of facts...

Here is some more info on the subject.

No. The reason why it is beneficial to put a log file on a single drive is that the log is always written to sequentially by SQL Server. That means...

There does not seem to be much of a problem with fragmentation. Are you sure that the procedure is using an optimal execution plan? Are the statistics up to date?

Yes, and those entries are read from the SGAM and PFS pages. That part is not really stored in every data page, it is just that DBCC PAGE fetches and...

I guess this might not be the answer you want, but you should really change the design. That is just not proper design and you will spend much more time...

Just to make sure. You are aware that you will need a separate physcial drive for each database's log file, right?

See this post (same post by same author, different forum) where this is answered.

Like I said, MAX is about the fastest you can get. TOP 1 is an alternative, but performance will normally be very similar. With the index I specified above your...

What exactly do you mean with "The fields InpassNo,CompanyID and Finyear are Primary keys"?

To execute this query as fast as possible you should have a non-clustered index defined on (CompanyID,...