meta user
network profile
| bio | website | uk.linkedin.com/in/… |
|---|---|---|
| location | London, United Kingdom | |
| age | ||
| visits | member for | 1 year, 11 months |
| seen | 5 hours ago | |
| stats | profile views | 834 |
|
1d |
reviewed | Approve suggested edit on MySQL multiple rows with same id meeting two different conditions at same time |
|
1d |
comment |
What can I add to a server to make SQL restores faster? Certainly your suffering unduly from having the backups on the drive you're restoring too. How many disks in your current RAID5? |
|
1d |
comment |
What can I add to a server to make SQL restores faster? @SeanLong Mark's suggestion is probably the best option for your scenario. What I think you're misunderstanding is when and what you take the snapshot of. The plan on a test server would be to restore the test database from your live backup, then snapshot the test database, run your test cycle, then revert the snapshot, rinse & repeat. Periodically you can return to step 1 and restore the live backup to test again. |
|
1d |
comment |
How to take partitions or filegroups out of service What's the thinking/motivation behind taking older partitions offline? There's a number of things not possible or not advisable with your approach but understanding why you want this would lead to better answers. |
|
1d |
reviewed | No Action Needed How to make trigger code execute only for a specific application? |
|
1d |
reviewed | Close Need some good tutorial regarding Rman,datagaurd,rac and performance tuning |
|
1d |
revised |
SSIS Rollback Package added 302 characters in body |
|
2d |
revised |
Hazards of Upgrading SQL Server Express 2008 to R2 added 122 characters in body |
|
2d |
reviewed | No Action Needed Error while opening Oracle 11g Database |
|
2d |
reviewed | Reviewed What are the basic job functions required of a remote DBA for Oracle and SQL Server? |
|
2d |
comment |
What throughput should I expect with MPIO? @MrDenny Last comment on the matter, I promise. Craig Freedman on sequential read-ahead... SQL Server tries to combine up to 32 contiguous pages (256 Kbytes) into a single (asynchronous) I/O. So, in a best case scenario, it can read ahead 500 pages in just 16 I/Os. However, if the pages in the table are not contiguous (e.g., due to fragmentation), SQL Server cannot combine the I/Os and must issue one I/O per page (8 Kbytes) |
|
2d |
answered | Hazards of Upgrading SQL Server Express 2008 to R2 |
|
2d |
answered | Does Detach/Attach or Offline/Online Clear the Buffer Cache for a Particular Database? |
|
2d |
answered | SSIS Rollback Package |
|
2d |
awarded | Guru |
|
Jun 16 |
reviewed | Close Is it possible to integrate Oracle NoSQL Enterprise solution with Google app engine. If yes, then how..? |
|
Jun 15 |
reviewed | Close Remote connection to PostgresSQL in Windows 2008 Server is prompting the error below |
|
Jun 15 |
reviewed | Close speeding up a query on MySql |
|
Jun 15 |
reviewed | Close create table with date name |
|
Jun 15 |
reviewed | Close ORA-01562 --failed to extend rollback segment |
