onlygoodones (9/20/2011)

---

Thanks Gail, SScoach and Nate. I will choose 95 as my initial FF.

If I see any page splits down the road, I would go down to 90...

SQLRNNR (9/15/2011)

---

If not, then try this

SELECT dp.grantee_principal_id,p.name AS UName

,dp.permission_name,c.name

,OBJECT_NAME(o.object_id) AS TabName

FROM sys.database_permissions dp

INNER JOIN Sys.objects O

ON dp.major_id = o.object_id

INNER JOIN sys.columns C

ON c.object_id = O.object_id

AND c.column_id = dp.minor_id

INNER JOIN sys.database_principals...

Just to expand a bit on to the points already mentioned.

I never add indexes solely on what the above DMV query will return. That is not to say the query...

happiestgirl (9/15/2011)

---

here is nice explanation:

http://brandonlive.com/2010/02/21/measuring-memory-usage-in-windows-7/%5B/quote%5D

Thank you, this is a very useful link.

SQL SERVER NOOB (9/14/2011)

---

Hello gurus,

I'm working on SQL SERVER 2008 R2. Created a log shipping routine with secondary database in standby mode. The LS process is working fine, no errors....

Run sp_help_revlogin on the primary instance. That will give you a script as output of all logins on the instance. Run that script on the standby instance to re-create the...

Dropping the temp table explicitly at the end of a batch is considered good programming practice. On the other hand, I have seen it mentioned that NOT dropping it explicitly...

Ninja's_RGR'us (9/7/2011)

I tested that and I was never able to get anything returned from that table (even with 1 minute reports). I didn't test the subscription part because you...

eccentricDBA (9/7/2011)

---

The only way I know of how to do it outside of Managment...

Ninja's_RGR'us (9/7/2011)

---

Subscriptions are setup as...

But these are not SQL jobs, they are reports running on a user's machine.

Is there a way to "kill" reports running for too long, as identified from dbo.RunningJobs?

Revenant (9/6/2011)

---

Marios Philippopoulos (9/6/2011)

---

Revenant (9/6/2011)

---

. . .

Thanks, but I think this script provides info on running jobs in general.

I am interested in getting info on currently executing SSRS reports and...

Actually, this seems to be the answer for what I need. I just checked it and...

Revenant (9/6/2011)

---

SELECT job_name

,run_datetime

,run_duration

,run_status

FROM

(

SELECT job_name

...