Marios Philippopoulos | SQLServerCentral

Marios Philippopoulos

Forum Topics Started

Viewing 15 topics - 61 through 75 (of 302 total)

Topics

Posts

Last post
msdb indexes heavily fragmented - blocking on msdb.dbo.sp_jobhistory_row_limiter

2 replies

12 years, 8 months ago

By: Marios Philippopoulos
Is there any option to reduce the size of the log resulting from a reindex/reorg operation? Affecting mirroring to DR env

3 replies

12 years, 8 months ago

By: Marios Philippopoulos
"Scale-out deployment" error while migrating Reporting Services from SQL 2005 to SQL 2008

22 replies

12 years, 8 months ago

By: sqlfriend
Changing data type of column from INT to BIGINT in large table so as to maintain LOG size at current levels in FULL recovery database

8 replies

12 years, 9 months ago

By: Marios Philippopoulos
Should all database backups across the enterprise be scheduled at the same time? Or should they be staggered to balance IO load on fabric/SAN?

8 replies

12 years, 10 months ago

By: Gail Wanabee
OLE DB error: OLE DB or ODBC error: Operation canceled; HY008

1 replies

12 years, 10 months ago

By: Dark Knight
Need to grant execute permissions on all sprocs of a specific database to all server logins of a SQL instance without explicitly granting exec permissions on each individual object

19 replies

12 years, 10 months ago

By: GSquared
Running Full and Transaction-Log Backups Concurrently - Any Implications for Database Recovery?

7 replies

12 years, 10 months ago

By: Gail Shaw
Would like to start my own blog but don't know how

5 replies

12 years, 10 months ago

By: Grant Fritchey
Optimal Disaster/Recovery Strategy for Data Warehouse (BI) application

12 replies

12 years, 11 months ago

By: Marios Philippopoulos
Advice needed to ensure least impact on db mirroring during lengthy planned primary-server outage

4 replies

12 years, 11 months ago

By: Steve Jones - SSC Editor
ReportServer-db query to find which reports are largest contributors to CPU usage in a SQL-2008 SSRS server

2 replies

12 years, 11 months ago

By: Marios Philippopoulos
Query to find which columns have different values in a pair of rows

11 replies

12 years, 11 months ago

By: Jeff Moden
Trying to reproduce production SQL performance issue on dev server and failing...

30 replies

12 years, 11 months ago

By: Ninja's_RGR'us
Missing Index suggested in execution plan even though index with same exact columns already exists!

4 replies

13 years ago

By: Marios Philippopoulos

Viewing 15 topics - 61 through 75 (of 302 total)