1,833 reputation
414
bio website stuart-moore.com
location Nottingham
age
visits member for 2 years, 2 months
seen Nov 20 at 12:06

Nottingham based DBA, mainly SQL Server but turns hand to anything else. Currently getting excited about cloudy stuff.


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
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
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
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?
Feb
5
comment Change SQL Server 2008 name
what happens if you run the following DOS command: nslookup SERVER2
Feb
5
comment how to insert data from one table to another
I have edited an an extraneous column that I used for testing. Here's a SQLFiddle showing it working - sqlfiddle.com/#!2/ea8e8
Feb
4
comment how to insert data from one table to another
OK, I've edited my answer to incorporate your revisions, though please note that as the created column isn't defined anywhere I can't answer that section.
Feb
4
comment how to insert data from one table to another
What's the created column?
Feb
4
comment how to insert data from one table to another
BTW, I made a mistake in the previous note, and meant is SKU always the string 'prod-' with the id appended. If there's no relationship, then this query logically can't exist as there's no way to like a specific sku to a particular id.
Feb
4
comment how to insert data from one table to another
How are id and sku related? Is sku allways 'sku-'+id ?
Feb
4
comment Using data from other database to populate a new database
You have more columns in target than source, and they're also NOT NULL columns. Where are you getting the other values from? (This will affect the query you need to use).
Jan
17
comment How to identify the db orphan mdf and ldf files
good points. I'd forgotten to account for multiple instances.
Jan
16
comment Backup Only Database Schema Everynight
When you say 'schema only', are you meaning you only want to backup certain schemas. Or are you using schema to mean the db structure, and you want the create scripts for tables, indexes, etc?
Nov
25
comment Please help configure my Mysql for 12GB 4cores server
Do you mean a single 4 core CPU, or 4 CPUs? What else is running on the server? Is MySQL writing anything to it's log when it does restart?