Evaluation is not available any more.

Express can be downloaded from here: http://www.microsoft.com/en-us/download/details.aspx?id=21844

Markus (11/25/2014)

---

You guys must live in a perfect world of applications. We have well over 100 purchased apps and virtually none of them use Windows Auth. The user...

Thanks, I didn't know it worked on 2008 R2. Maybe it arrived with a later SP?...

Thanks Brandie! We really needed the fantasy of a writer here 🙂

"The creepy DBA" - out soon...

On the few 2008 servers we still have, we're using PowerShell in a SQLAgent job.

Markus (11/21/2014)

---

The query tool that our developers use do not allow for the use of Windows accounts to query, only SQL Server authenticated IDs.

I guess I fail to see...

Ed Wagner (11/21/2014)

---

I must admit I was excited when I saw this, but sys.dm_os_volume_stats is for 2012 and later. I'm still on 2008, so I'm out of luck.

Thank you,...

You don't need xp_fixeddrives any more:

SELECT DISTINCT vs.volume_mount_point

, vs.logical_volume_name

, vs.total_bytes

, vs.available_bytes

FROM sys.master_files AS mf

CROSS APPLY sys.dm_os_volume_stats(mf.database_id, mf.file_id) AS vs

No issues at all

Vendage1 (11/20/2014)

---

I don't want to. I would prefer not having to...

It is the job_id:

select * from msdb..sysjobs where job_id = 0x5FABFDB18CA34A4C83D6CFB5CE6751AD

Joy Smith San (11/21/2014)

---

Thank you very much.!

So a failover is essential is it ?

We will failover and then faiolver back once again as we need the current node as active.

Thanks...

DBA_AUS (11/20/2014)

---

Hi everyone,

i need some help in assiging a group of users read,write,update (not delete) permission on all user databases. is there any way to do so instead of creating...

Looks like bad parameter sniffing and/or stale statistics.

Here's a good article on the subject: http://www.mssqltips.com/sqlservertip/3257/different-approaches-to-correct-sql-server-parameter-sniffing/

frdrckmitchell7 (11/20/2014)

---

Thank you both for your reply but the integer dates are still hard-coded in your answers. And that's the problem that I have. Instead of 20141106 (hard-coded)...