Here are the first two things I would look at:

(1) Is your query being blocked by another process?

(2) Have you compared the execution plans from the two databases?

Are the databases...

The UI is simpler, yes, but it's helpful to know the command if, for example, you're doing the same change on a lot of servers, or you're scripting a change...

Try running a trace, just capturing login events from your user accounts. That'll give you a bit more information, such as the application that's making the connection (provided the...

Is there a service or an application running under your account? The entry in the errorlog tells you the IP address from which the connection was made - this...

The answer's right there in the error message. You don't have an alias for the third column of your SELECT statement.

John

Please will you post your whole query and a CREATE TABLE statement for the table you're selecting from?

Thanks

John

Another way of doing it:

SELECT A, B, C, 'Text 1' MyText

FROM MyTable

UNION ALL

SELECT A, B, C, 'Text 2'

FROM MyTable

John

Yes.

Since 2016 hasn't been publicly released yet, I wouldn't advise you use it for production. There's SQL Server 2014 to consider as well, don't forget.

John

What do you want in the other two columns? Is this a homework question, by...

Something like this?

SELECT

dato

FROM dbo.dutyrostershift d

JOIN dbo.vacation v

ON d.dato BETWEEN CAST(start-36163 AS datetime) AND CAST(fld_end-36163 AS datetime)

AND d.employeeid = v.personalid

WHERE d.shifttype = 2

John

It's not clear whether you want five columns or three. This will work for your example:

DECLARE @StreetName varchar(100)

SET @StreetName = '-346A'

SELECT

col1 = LEFT(@StreetName,1)

,col2 = SUBSTRING(@StreetName,2,3)

,col3 = RIGHT(@StreetName,1)

John

The issue is still that, with the set of parameters you've passed in, you're selecting every row from the table. What you originally posted, though, was only the subquery...

You're selecting every row from the table, so it's not going to be all that quick. Get rid of your whole WHERE clause - it's just noise. A...

"The system cannot find the path specified" - that's a very clear error message. Is the file on the same computer as the database? If not, you'll need...