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.

GSquared (1/9/2012)

---

GilaMonster (1/9/2012)

---

Steve Jones - SSC Editor (1/9/2012)

---

jcrawf02 (1/9/2012)

---

GilaMonster (1/9/2012)

---

Yes

http://sqlinthewild.co.za/index.php/2012/01/01/2011-book-review/

http://sqlskills.com/BLOGS/PAUL/post/2011-the-year-in-books.aspx

We both have 2010 posts as well if you...

Apparently I'm the person who prefers underscores to camelCase. I like it for case-sensitivity reasons. If I use all lower case and underscores I don't have to worry...

Roy Ernest (1/9/2012)

---

I see lots of comments regarding post counts... Does everybody have a target? I have never thought about it at all.

When I get time post some thing,...