Stuart Moore

1,658 reputation

212

bio	website	leaf-node.co.uk
	location	Nottingham
	age
visits	member for	8 months
	seen	May 17 at 14:16
stats	profile views	26

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

	1,658 reputation	bio	website	leaf-node.co.uk	visits	member for	8 months
212 badges		location	Nottingham		seen	May 17 at 14:16

summary answers questions tags badges favorites bounties reputation activity

39 Comments

suggestions reviews revisions comments badges posts accepts all

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?
Nov 24	comment	Complex SQL Query Hi, sorry about that. I'd assumed a little too much about your data. I've added some edits to my answer that should solve those issues. I've added a where clause to let you specify the hostname, and then where clauses for each of the 3 joined tables to filter to snmp_index 527 as per your example.
Nov 20	comment	SELECT Data Set Using Stored Procedure with BCP Error Does the BCP command run if you run it direct from the command line rather than xp_cmdshell?
Nov 13	comment	Error in SSMS when attempting to restore a database You're welcome. And as @Marian mentions above, you'll probably want to check the other logging tables in msdb as it's likely they also contain 3 years worth of data ( `sp_maintplan_delete_log` , `sp_purge_jobhistory` and the `sysmail_delete_*` SPs detailed here - msdn.microsoft.com/en-us/library/ms177580(v=sql.105).aspx are probably worth investigating)
Nov 13	comment	Error in SSMS when attempting to restore a database Possibly, what's the output if you run `select COUNT(1), MIN(backup_start_date) from msdb.dbo.backupset` on the problem server? (this will give us the 'amount' of backuphistory you've got atm, and how far back it goes).
Nov 13	comment	MySQL, import SQL dump with another database Which operating system are you running on? If it's a unix variant, then a tool like sed should have no problems replacing all`USE db1` statements with `USE db2` ones (might take a while, but it'll do it).