131 reputation
4
bio website developer42.wordpress.com
location Surrey, United Kingdom
age 32
visits member for 2 years
seen Jul 23 at 8:24

I work as a technical architect for an advertising company. Most of my day job revolves around ERP, Finance and Operations systems, though I also get involved with any technical issues which fall into knowledge gaps between the various IT teams' / people's roles.

My (IT related) interests are more towards web applications, artificial intelligence, productivity utilities, and scripting.

If you want to know more about me than that, just Google my username - it's a perfect example of how not to ensure personal privacy.


Jul
23
comment Performance of checking for data in related tables
Thanks @stacylaray. Is there a good way to figure out how many scans are likely to be performed aside from running queries and looking at query-plans / stats? e.g. some kind of Big O notation? I ask as I expected #4 to have more scans since all of the subqueries look like they'd be performed once for each of the results; which in the above case is pretty much the opposite of what happened. Also it would be interesting to see how this scaled with data & distribution.
Jul
22
comment Performance of checking for data in related tables
NB: also asked here: stackoverflow.com/questions/24897268/… as this spans the boundary of DBA & Programmer domains.
Jul
22
revised Performance of checking for data in related tables
edited title
Jul
22
asked Performance of checking for data in related tables
Jul
4
asked SSMS causing Event ID 4674: SeTakeOwnershipPrivilege
Apr
6
comment Why do we need to rebuild and reorganize Indexes in SQL Server
As a side question, any idea why SQL doesn't reorganise indexes in the background during low demand periods (i.e. to avoid requiring scheduled tasks or manually requesting this action)?
Oct
29
answered SQL Server : Is it possible to have a linked server link to another linked server?
Oct
21
awarded  Autobiographer
Oct
19
awarded  Supporter
Oct
19
comment Length of LOB data (%1) to be replicated exceeds configured maximum %2
Thanks Brandon - do you know of any stats around this (i.e. how replication time scales with the size of the lob), or know whether the impact will be limited to the current table vs hitting all tables on that publisher/distributor/subscriber?
Oct
19
asked Length of LOB data (%1) to be replicated exceeds configured maximum %2
Aug
16
comment SQL Server Replication :: Dedicated Distributor Hardware Requirements
For anyone viewing this looking for similar info, we're going with 4 cores / 12GB ram to begin with. These will be on virtuals so we can monitor and tweak as needed. I'll try to work out a rule based on what we see over the next few months to help guide others.
Aug
13
comment SQL Server 'Create Database' statement. How to inherit autogrowth settings?
ps. more info on this table here: msdn.microsoft.com/en-us/library/ms181338.aspx. In my code above I haven't accounted for the maxsize=0 case (i.e. no growth), and have masked the status code since I had a different figure for percentages to what's in the documentation, but was able to make the values comparable via masking. I'm not worried about the 0 status code, since that's taken care of by maxsize (were it implemented).
Aug
13
awarded  Editor
Aug
13
revised SQL Server 'Create Database' statement. How to inherit autogrowth settings?
tweaked to calculate correct growth amount
Aug
13
answered SQL Server 'Create Database' statement. How to inherit autogrowth settings?
Aug
13
awarded  Student
Aug
13
asked SQL Server Replication :: Dedicated Distributor Hardware Requirements