I can GUARANTEE you that I will still be supporting clients using database mirroring 10 years from now - probably more like 15. Always On is ENTERPRISE EDITION ONLY,...

Just get out books online and review the RESTORE LOG section.

Or you can use SSMS GUI to fully script out your options and then click the Script button...

dan-572483 (3/10/2015)

---

I've read several times in different places that one should NEVER shrink a database data file except as a last resort due to the effect on index fragmentation. One...

krypto69 (3/9/2015)

---

Hi,

We have H/A setup on SQL2012. Seems to work fine.

I thought there was code I could add that would check to see if it was running on the primary...

So you did 600K reads, with 80K being physical, and you are upset it takes 5 mins?? 😀

I sit with and work closely with the developers, they work with me, and we all work together on the common goal. More companies should do such a thing because...

t.mounika01 (3/6/2015)

---

Actually, what i meant was that I just have thereotical knowledge and I have been practicing queries on ssms installed in my laptop. I want to know how...

Scott Coleman (3/6/2015)

---

Hopefully the CRM app rarely does "SELECT * FROM dbo.notes" on the whole table, so doing that in Management Studio is not a useful test. You're just...

Your "real time" doesn't make any sense to me. Real time happens in SQL Server all the time. You INSERT data - it goes in in "real time". ...

Oh, I should also ask WHY do you want to bring back the entire table to SSMS?

So you are spooling 1M+ rows (fat or otherwise) back to the client, in this case SSMS?!? That isn't going to work out well for you!!

Declare variables...

Nevyn (3/4/2015)

---

Thanks!

Started doing it with a CTE for the max(case) and then it just occurred to me that I really didn't need it to be in a CTE just to...

Nevyn (3/4/2015)

---

For starters:

SELECT PERSID,

CASE MAX(CASE DUESTATUS

WHEN 'Overdue' THEN 2

WHEN 'DUE' THEN 1

ELSE 0

END)

WHEN 2 THEN 'Overdue'

WHEN 1 THEN 'Due'

ELSE 'Unknown'

END DUESTATUS,

CASE MAX(CASE COMPSTATUS...

There are DMVs that expose Always On metadata and status information. If you aren't familiar with them and can't find a blog post just set up Profiler and open...

Sangeeth878787 (3/3/2015)

---

hi,

I want to check if column 1 = 'ab' then I need all the other columns (column2, column3 ) values need to be zero

I tried doing this

select case when...