The role allows users to create jobs;I.e. not just a reader...

I guess it is not that bad a role to grant.

Thanks for the thoughts guys. We will actually have a read-only server in the HAGR that will handle a lot of the stuff. It is the large stuff I am...

Solomon Rutzky (1/8/2014)

---

Hey Jared. Did you ever get your...

It becomes important when the two databases are set up in availability groups 🙂 interesting, huh?I know these don't 'support' these kinds of transactions... but what do they do then?

Theoretically, which log would get the commit first? Or does the transaction manager apply the command at the same time?

I would start by asking you what the main purpose of your setup is. Why do you want high availability? Are you protecting from site failure? Server Failure? Disk failure?...

One of my favorite uses for window functions is for removing duplicates. This is pretty well documented, so I wanted to show how I use the new (2012) SUM() with...

This...

That is the final product. This clr is the interim while we slowly move millions of images out of the database.

CRAP! I didn't even realize this was 2005, I just looked for CLR. I feel like a newbie! We looked into filestream and the higher ups decided against it for...

I agree with you in your situation. However, we have terabytes of images and the business loves to keep them for 10 years (even though they don't go back to...

create procedure dbo.p_inner

as

select 1,NULL,NULL

UNION ALL

select 2,3,4

go

Without the union in the proc, it will create 2 result sets because it IS doing 2 selects. a stored proc will return as many...

george sibbald (10/7/2013)

---

did you get the message 'SQL Server has encountered %d occurrence(s) of cachestore flush for the '%s' cachestore (part of plan cache) due to some database maintenance or...

shahgols (9/26/2013)

---

Hi Jonathan, I read your article, but I am still unsure how to see the graphical view of the deadlock. The query returns several rows of xml data...