1,853 reputation
414
bio website stuart-moore.com
location Nottingham
age
visits member for 2 years, 3 months
seen Dec 22 at 8:09

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
revised Autogrow of database1_log file in database database1 took 1010871 milliseconds
bulleted options to make them stand out more
Feb
26
revised Log all than queries taking more than X seconds
spulling mistack
Feb
19
revised Move named instance to another server
edited tags
Feb
12
revised Restore the latest backup on the database
Updated answer after clarification of details from OP
Feb
6
revised Reference the database from a stored proc?
improved answer
Feb
5
revised how to insert data from one table to another
deleted 15 characters in body
Feb
4
revised how to insert data from one table to another
more info from requester, so I've reinstated answer
Feb
4
revised how to insert data from one table to another
change query based on askers update
Jan
17
revised How to identify the db orphan mdf and ldf files
future proofed query
Nov
25
revised Please help configure my Mysql for 12GB 4cores server
fixed up spelling and grammar
Nov
24
revised Complex SQL Query
added extra criteria to fix OP's comments.
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
16
revised Create job to send alert using sp_send_dbmail when table value greater than x
forgot last line of answer, now added so it makes sense
Nov
15
revised SQL Server: Simple database restore with overwrite
not happy with phrasing.....
Nov
14
revised How define select, if bridge pair may have 3 players?
grammer and tidied up generally
Nov
13
revised tempdb usage in SQL Server
reformatted code for clarity
Nov
13
revised Restrict record to be update or deleted according to dates inside row for SQL Server 2005
fixed spelling and grammar, and hopefully made it a bit clearer.
Nov
5
revised Database Indexing - Maintenance Jobs
edited tags