Looks like CommandTimeout, not ConnectionTimeout.

You can either increse the timeout or tune the query and make it complete before the timeout expires (default is 30 seconds).

They're semantically equivalent and the optimizer will likely convert the second form to the first form.

There is no performance benefit in choosing one.

I suggest that you write your queries...

You don't have to change it in the passive node. Just change it in the active node and the setting will be preserved when you fail over the instance to...

SQLRNNR (11/20/2014)

---

spaghettidba (11/20/2014)

---

Regarding compromising data, if you're the DBA you already have access to all the data, so this is a bit of a moot point IMHO. Also, you can...

It depends...

I never keep track of end users passwords. Also, we have very few users that log in using SQL Server authentication. They're very few, but they forget their passwords...

Your condition for 99 is never met, check your logic.

Here's a method to calculate the dates dynamically:

DECLARE @startDate int = 20140601;

WITH SampleData AS (

SELECT *

FROM (

VALUES

(20140601),

(20140701),

(20140801),

(20140901),

(20141001),

(20141101),

(20141201),

(20150101),

(20150201),

(20150301),

(20150401),

(20150501),

(20150601),

(20150701),

(20150801),

(20140601)

) AS data (TransDateNumeric)

)

SELECT...

With "frontend" you mean the application that handles the data?

You could use a custom url such as myapplication://open-form?reference=123

Then you need to register your application as the handler for that kind...

Normally I would say you could use a SQL Server Agent Alert with a performance condition, but it doesn't appear to work. Looks like it's a bug (so a MSFT...

I think you already found out what the options are.

If you don't have time and/or means to test the whole workload in the new CE, I think your best bet...

Looks like a connectivity issue.

Log in to the server that contains the linked server and see if you can connect to the linked server from there (use sqlcmd if SSMS...

Microseconds.

See sys.dm_exec_procedure_stats

Use a splitter function.

Here's a good one: http://www.sqlservercentral.com/articles/Tally+Table/72993/

Example please.

See the first article linked in my signature line for posting guidelines.

GilaMonster (11/17/2014)

---

Yeah, google's image recognition (originally intended to interpret...

Jeff Moden (11/17/2014)

---

spaghettidba (11/17/2014)

---

Steve, spam deletion in a good thing, but preventing spam is better in my opinion.

I just registered to the site with one of my addresses and it...