Yes the RequestType column values are {Interactive, Subscription}

There are multiple...

OK, so the...

have a look at ExecutionLog3 in the ReportServer database:

https://msdn.microsoft.com/en-us/library/ms159110(v=sql.110).aspx

jtrask (1/3/2017)

---

I have a table that stores EmployeeID, and Date. I want to create a report for 2016 that shows what the best month, by highest record count, for...

I've always followed the Kimball group methodology so my answer will be biased on their suggestions. One thing they talk about for documentation is what's called the Bus Matrix:

http://www.kimballgroup.com/2005/12/the-matrix-revisited/

Another...

Do you have people in different business job functions accessing the cube? Sometimes if the data warehouse is designed to cover everyone's needs it can seem overwhelming to users....

OK, here's a simpler query that may be easier to understand?

-- most recent backups per database

SELECT LEFT(d.name,20) AS DBname, LEFT(d.state_desc,10) AS StateDesc, LEFT(d.recovery_model_desc,10) AS RecoveryModel,

CONVERT(VARCHAR(20), fb.LastFullBackup,...

stephen.plant2 (1/3/2017)

---

...This table has a column of EventStatus_GUID as the PK and set to uniqueidentifier

It then has a Clustered Index PK_EventStatus on EventStatus_GUID

Then there is a Unique, Non Clustered Index...

Jeff Moden (1/2/2017)

---

...That's what I'm talking about. Just like the folks that casually recommended the use of WITH(NOLOCK), there are ramifications and risks that must be fully understood before...

Jeff Moden (12/30/2016)

---

I'd be very cautious about recommending the use of SNAPSHOT ISOLATION... very cautious. As with any such major feature, there are major caveats.

Kendra Little wrote a nice...

Sorry...

chuck.forbes (12/28/2016)

---

We're in the midst of an application upgrade, and part of the vendor instructions after the database pieces are upgraded is to rebuild all indexes, for improved performance. I've...

Sioban Krzywicki (12/21/2016)

---

I've seen articles that say you shouldn't make the leading column in your index a BIT column. There are, of course, other articles pointing out the eternal truth...

guaro5555 (12/28/2016)

---

Thanks a bunch for jumping in

I was planning on sync every hour if this is a good practice?

The Dbs are not that big at all, the biggest one...

fizzleme (12/27/2016)

---

Part 2. We have 2 2008 r2 servers with 2008 r2 sql server installed on both.

Our goal is to copy the full sql server backups from server A...