https://msdn.microsoft.com/en-us/library/ms179882.aspx

SELECT £

SELECT $

SELECT ¥

SELECT €

SELECT ?

SELECT ?

SELECT ?

SELECT ?

SELECT ?

The trace doesn't necessarily have to be running on that server.

There is a nice whitepaper which assists you to decide which objects to compress and which compression to use.

http://technet.microsoft.com/en-us/library/dd894051(v=sql.100).aspx

Haha. The server team will be reinstalling Windows.

Perry Whittle (12/1/2014)

---

have you checked the local SQL Server groups to see if the svc account has been added, when installing SQL Server 2008 on Windows 2003 it will use...

GilaMonster (12/1/2014)

---

You may need to open a case with Customer Support then.

Never use the services app to change a SQL logon. Config manager is the only thing which should be...

I tried both configuration manager and windows services. Also specifying the account during the installation caused the failure.

Epic comprehension failure.

There are two correct answers.

We really need to see your code to help you. As you can see below, the documented max values for VARCHAR(MAX) are correct. There is something else at fault here.

DECLARE...

Thank you :Wow:

There are many ways to skin this cat, for example:

If you use Management Studio and right-click - execute stored procedure it will op up a window to input parameter values.

You...

Replicate the tables you need.

Use two quotes to represent a single quote inside a string, i.e.

You can use SQL Sentry Plan Explorer. This allows you to anonymize the plan.

Does IIF have the same performance impact?

SELECT A.City_Name, B.Country_Code, IIF(B.Country_Area = 'EUR', 1, 0) AS Country_Area

FROM Cities...