You don't want to shrink and that won't fix the issue if all the space in the file is used. If you have drive space you should grow the...

You haven't provided enough information for anyone to provide an accurate answer.

What do you want the view to provide? A union of the results from the tables...

Yes you select the top option and then you just select install client tools.

I still think Windows authentication is more secure. At the very least people do not have to remember a second login, and you aren't storing a login in the...

There are some people who believe for security purposes that DBA's should have a separate AD account for sa access while your standard AD account only has minimal rights.

Not that I'm aware of in the local edition of BOL. You can add comments to the online version of BOL though.

I think the problem is in this line:

(select max(END_TMSTP) LOG)

There is no FROM clause, is LOG an alias for MAX(END_TMSTMP) or is the query supposed to be:

Select MAX(END_TMSTP) FROM...

cookie SQL (1/10/2012)

---

thanks for all the responses guys, after reading Jacks post a "lightbulb" appeared.

The culprit was :

A domain users group had been added using british english, as all users...

Sorry, I can duplicate it. Try this (you many want to check your language setting first):

SELECT

@@LANGUAGE AS language_name,

...

I'd like to know as well as I cannot duplicate the...

I assume that it is a varbinary(MAX) column. So your performance issue has to do with how SQL Server stores BLOB data. It has to do extra work...

If the column holds numeric data only the best way to deal with it is to use a numeric data type.

Based on what I know the engine (even with Compact...

How are you using the parameter in the query? Are you just using an IN (Parameters!paramter_name.Value) or are you splitting the delimited list into a table and doing a...

I don't think there is a way to do this because I don't think you can set the width property using an expression.

Why do you want it stay the...

Guess I'm going to have up my game to stay ahead of you. Enough others have passed me.