Viewing 15 posts - 196 through 210 (of 1,518 total)
onlygoodones (9/20/2011)
If I see any page splits down the road, I would go down to 90...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 20, 2011 at 2:26 pm
SQLRNNR (9/15/2011)
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 16, 2011 at 9:13 am
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 15, 2011 at 11:25 am
happiestgirl (9/15/2011)
here is nice explanation:http://brandonlive.com/2010/02/21/measuring-memory-usage-in-windows-7/
Thank you, this is a very useful link.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 15, 2011 at 8:46 am
SQL SERVER NOOB (9/14/2011)
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....
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 14, 2011 at 2:07 pm
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 11, 2011 at 10:04 am
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 11, 2011 at 6:50 am
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 7, 2011 at 2:32 pm
eccentricDBA (9/7/2011)
Marios Philippopoulos (9/7/2011)
Is there a way to "kill" reports running for too long, as identified from dbo.RunningJobs?
The only way I know of how to do it outside of Managment...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 7, 2011 at 10:58 am
Ninja's_RGR'us (9/7/2011)
Marios Philippopoulos (9/7/2011)
Ninja's_RGR'us (9/7/2011)
Just a guess but cancelling the job could do it...But these are not SQL jobs, they are reports running on a user's machine.
Subscriptions are setup as...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 7, 2011 at 9:12 am
Ninja's_RGR'us (9/7/2011)
Just a guess but cancelling the job could do it...
But these are not SQL jobs, they are reports running on a user's machine.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 7, 2011 at 9:06 am
Is there a way to "kill" reports running for too long, as identified from dbo.RunningJobs?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 7, 2011 at 9:02 am
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 6, 2011 at 2:35 pm
Marios Philippopoulos (9/6/2011)
eccentricDBA (9/6/2011)
Try dbo.RunningJobsThanks, but won't this only give me reports running as subscriptions?
Actually, this seems to be the answer for what I need. I just checked it and...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 6, 2011 at 2:23 pm
Revenant (9/6/2011)
SELECT job_name
,run_datetime
,run_duration
,run_status
FROM
(
SELECT job_name
...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 6, 2011 at 2:20 pm
Viewing 15 posts - 196 through 210 (of 1,518 total)