You can't just put a disk in this. It's not like a "server". And, it's likely that the disks are already SSD's, although the hosts can be purchased...

Did you mean to post this is a different forum? SQL 2008 does not support Always on.

As for jobs, yes, you will need to create them in both...

DECLARE @TodaysDate datetime = getdate()

DECLARE @StartDate datetime = DATEFROMPARTS ( DATEPART(year, @TodaysDate) - 2, 1, 1)

SELECT @TodaysDate, @StartDate

Here's some ideas.

Create a true / false check box labeled "Except". Keep your existing list of all of the possible choices in the drop down.

If the user...

Take a look at this link.

https://blogs.msdn.microsoft.com/sqljourney/2012/05/07/sql-20082008-r220122014-setup-disappearsfails-when-installing-setup-support-files/

Steve Jones - SSC Editor (11/22/2016)

---

Have to drop this here, since I'm proud.

My son completed his Board of Review last night to earn his Eagle Scout rank. It's been a...

tschuler-738392 (11/18/2016)

---

Yeah, I see that. I took out the and c.client_id not like '%.%'

Still get the error.

Running the following now but same issue.

select c.client_id,...

First, lets make it readable

SELECT c.client_id,

c.client_name,

m.matter_id,

m.matter_name,

m.billable

FROM docsadm.client AS c

LEFT JOIN docsadm.matter AS m ON c.client_id = m.client_id

WHERE c.client_name <> ''

AND m.matter_name <> ''

AND c.client_id NOT LIKE '%.%'

ORDER BY c.client_id

This line...

Isn't this functionally the same ?

WHERE Column50 IS NULL

It appears that you are testing for nulls incorrectly.

Why? The OP was looking to send an...

Converting to a float is the problem.

Try converting to a varchar(10) instead of a float.

Wryan138 (10/30/2016)

---

Hi Jeff,

Nope I'm a real person. I joined up an I've been reading EVERYTHING on the forum for

quite a while. The one thing I have noticed is...

I'm not sure I would consider this unfair.

In 2008, the only real thing available was mirroring. The spares were warm, and only one could be alive at a...

sqlserverDBA2016 (10/24/2016)

---

i'm gonna be using ssms to run the export and import.

but i'm just asking if whether after the installation of sql server 2014 , is there a backward compatibility...

You are attempting to use a string function on a date or datetime data type.

You need to use cast or convert on the field first, then attempt the substring.