1,788 reputation
313
bio website stuart-moore.com
location Nottingham
age
visits member for 1 year, 10 months
seen Jul 22 at 12:33

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


Feb
4
answered how to insert data from one table to another
Jan
17
comment How to identify the db orphan mdf and ldf files
good points. I'd forgotten to account for multiple instances.
Jan
17
revised How to identify the db orphan mdf and ldf files
future proofed query
Jan
17
answered How to identify the db orphan mdf and ldf files
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
27
answered Update field with new string made from characters in existing value
Nov
25
revised Please help configure my Mysql for 12GB 4cores server
fixed up spelling and grammar
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
25
suggested suggested edit on Please help configure my Mysql for 12GB 4cores server
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
24
revised Complex SQL Query
added extra criteria to fix OP's comments.
Nov
24
answered Complex SQL Query
Nov
23
revised Achieve log transfer to standby (Data Guard)
edited tags
Nov
22
revised Named pipes connection closed when subjected to load
fixed up spelling and grammar
Nov
22
awarded  Analytical
Nov
22
suggested suggested edit on Named pipes connection closed when subjected to load
Nov
22
answered using IDENTITY column with increment -1
Nov
20
answered Response On Database Failover
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
20
awarded  Enthusiast