meta user
network profile
| bio | website | leaf-node.co.uk |
|---|---|---|
| location | Nottingham | |
| age | ||
| visits | member for | 9 months |
| seen | 43 secs ago | |
| stats | profile views | 26 |
Nottingham based DBA, mainly SQL Server but turns hand to anything else. Currently getting excited about cloudy stuff.
|
Jun 3 |
revised |
How large will the Transaction Log backup be? improved answer with an option I'd stupidly forgotten to add. |
|
May 31 |
comment |
How large will the Transaction Log backup be? @TomTom - Unfortunately that's not the case. Paul Randal wrote a comprehensive blog post about this - sqlskills.com/blogs/paul/… |
|
May 31 |
comment |
Autogrow of database1_log file in database database1 took 1010871 milliseconds TomTom's suggestion of 8GB would be good if you weren't experiencing what appears to be problems with slow disk when allocation 5GB. So maybe try with 2GB? The other option as mentioned is to create your database with a 50GB transaction log. Then you'll only have to wait while it's created then, rather than while executing your query. |
|
May 31 |
revised |
Autogrow of database1_log file in database database1 took 1010871 milliseconds bulleted options to make them stand out more |
|
May 31 |
answered | How large will the Transaction Log backup be? |
|
May 31 |
answered | Autogrow of database1_log file in database database1 took 1010871 milliseconds |
|
May 31 |
comment |
Copy a SQL Server database from one server to another on demand How large is the database? If it's particularly big then backup/restore will be the most efficient way to do this. |
|
May 31 |
comment |
Autogrow of database1_log file in database database1 took 1010871 milliseconds How big are the data and log files? And what are the autogrowth settings? |
|
May 30 |
comment |
How to set SQL Server index pages per fragment? What are you using for a clustered key for the table? Is it a monotonically increasing value (like an INDENTITY) or is it random (eg; GUID or character string). If it's the latter you may be getting page splits due to data having to be inserted to an existing page. |
|
May 17 |
comment |
sql server 2008 execution plan different on two production servers Are the statistics on both servers the same and up to date? I if one of them has stale stats for a table/index that will throw a plan off. |
|
May 17 |
comment |
Copy tables from a stand-by database And do you want to move structure and data, or just the structure? |
|
Mar 4 |
comment |
Efficiently retrieve big amount of data based on date range Can you proved the create scripts for the table and it's indexes please. So we can see the data types and what you're currently doing. |
|
Feb 26 |
revised |
Log all than queries taking more than X seconds spulling mistack |
|
Feb 26 |
answered | Log all than queries taking more than X seconds |
|
Feb 19 |
revised |
Move named instance to another server edited tags |
|
Feb 15 |
suggested | suggested edit on What to do with duplicate lookup information |
|
Feb 12 |
comment |
Restore the latest backup on the database Yes, it does make a difference as you don't need to scan the backup files. I've updated my answer with details about that scenario. |
|
Feb 12 |
revised |
Restore the latest backup on the database Updated answer after clarification of details from OP |
|
Feb 11 |
answered | Restore the latest backup on the database |
|
Feb 11 |
comment |
Restore the latest backup on the database Will you be able to query the original server while doing the restore? Or is it in a completely seperate environment? |
