136 reputation
4
bio website
location Nottingham, United Kingdom
age 30
visits member for 3 years, 2 months
seen May 23 at 14:34

An enthusiastic and driven self-learner with strong foundations in Windows support and T-SQL and an interest in SQL Server internals. Focused on expanding knowledge and strengthening acquired skills.

Skillset

Database Administration: Experienced installing, configuring and administering SQL Server 2005 and 2008(R2). Good understanding of execution plans and what influences the query optimizer’s[sic] decisions. Installed and tested SQL Server Denali CTP1. Limited use of MySQL with Wordpress and Xbox Media Centre.

Development: Experience developing and refactoring SQL objects and Queries with a set based approach. Comfortable writing reports and basic Integration Service packages. Able to read through pages written in ASP.Net(C#), Classic ASP and Java Script to determine what queries are passed to SQL Server. Also have basic understanding of PowerShell.

Operating Systems: Experience installing, configuring and administering Windows XP, 7, Server 2003 and 2008(R2) as well as Ubuntu Server and OS X. Knowledge of ESXi and other VM-Ware products.

Networking: Good understanding of TCP/IP, DHCP and DNS. Comfortable creating DNS records in MS DNS Server and have basic knowledge of MS ISA Server. Communication: Strong written and oral communication skills. Led training sessions and wrote accompanying documentation. At ease discussing both technical and non technical topics with clients by phone, email and face to face.


Jun
15
comment Recursive CTE performance
My understanding from a talk I went to at SQL Bits by Ramesh Meyypappan recursive CTEs always run serially. The speaker demonstrates a method by which you build your own recursion by inserting in to a temporary table using a while loop. Done like this the queries are able to scale to parallel execution where possible. He also highlights that cardinality estimates tend to be off when using recursive CTEs. The talk can be found sqlbits.com/Sessions/Event7/…, the example is within the first 5-10mins.
May
30
comment Query to find optimal filegroups for objects
PS The question from programmers is here if you are interested programmers.stackexchange.com/questions/149097/…
May
30
comment Query to find optimal filegroups for objects
Hi Mark, don't worry too much. I asked the question on programmers too but more from the algorithm angle. I got quite a good idea of how to approach it. I think it may be one of the few times to use a cursor. In the end though I have pushed for the arrays to be rebuilt with more spindles and therefore there will only two filegroups and as such it has been easier to do manually. Thanks for your efforts
May
17
comment Query to find optimal filegroups for objects
Thanks for you time and input. Volumes are RAID 10 with 4 spindles. I am aware that the spindle count is quite low too.
May
17
awarded  Editor
May
17
revised Query to find optimal filegroups for objects
added more detail to logic rules
May
17
comment SQL Server: filegroup for system tables only?
Wouldn't I be right in thinking that if the system objects are only in the primary filegroup should you need to in future you will be able to do the following. Create x additional files in another filegroup. Proportionally fill these files by migrating your data from your your existing data file?
May
16
awarded  Student
May
16
asked Query to find optimal filegroups for objects
May
2
comment Clarify - Need to add Multiple foreign key constraints
In theory yes another position could be added to this table. But unless you provide a method to do so in the application end users will not be able to. Could still be edited direct in the database, but what can't.
Nov
18
awarded  Teacher
Nov
18
answered Creating a view on a non-existing view
Nov
17
awarded  Supporter