913 reputation
313
bio website zetaproductions.co.uk
location London, United Kingdom
age 34
visits member for 1 year, 11 months
seen Jul 22 at 7:32

UK based SQL Server professional and enthusiast. I work with, and am passionate about all aspects of SQL Server including the Database Engine and the BI stack, especially SSIS, but my real passion is SQL Server Internals, with my favourite blogger being the legend that is Paul Randle.

Career wise, I am a gun for hire, specialising in OLTP and DataWarehouse performance and ETL. I have experience in BIG data (80TB), FastTrack, and exposure to PDW.


Nov
9
answered Why do we need to rebuild and reorganize Indexes in SQL Server
Oct
31
comment SQL Server 2008 Performance issue with very strange resolution
Ok, have you considered outside influence, such as firewall or antivirus. If defiantly internal to SQL, set up an Extended Event session that you can then query after the event. It's very lightweight and you should be able to leave it running, unlike a traditional trace
Oct
31
comment SQL Server 2008 Performance issue with very strange resolution
Is there any CLR code running when the problem arrises?
Oct
26
awarded  Scholar
Oct
26
accepted SQL Server using incorrect plan
Oct
25
comment SQL Server using incorrect plan
@richrdthekiwi - thanks, the team are investigating this, but I don't understand why the SET options would be different? same machine, .NET guys tell me nothing being passed explicitly in the connection string?
Oct
25
comment SQL Server using incorrect plan
@MartinSmith - sorry, typo. Was meant to read "made no difference"
Oct
25
revised SQL Server using incorrect plan
added 3 characters in body
Oct
25
asked SQL Server using incorrect plan
Oct
23
awarded  Enthusiast
Oct
22
answered Security and Performance implications of “View Server State”
Oct
21
awarded  Autobiographer
Oct
19
answered Can you set up a SQL server maintenance plan to restore a database?
Oct
18
answered sql server session revert
Oct
18
answered correct security and user setup for SQL Server database
Oct
15
comment SQL Server 2012 CPU core usage
Sorry Eric, your answer had not appeared when I started typing mine!!
Oct
15
answered SQL Server 2012 CPU core usage
Oct
15
comment SQL Server 2012 CPU core usage
I think this is a perfectly valid dba question
Oct
15
answered How can I copy specific tables into one SQL Server Table into a separate table automatically?
Oct
15
answered How do I find I.O. statistics (by index) for queries in progress