10,189 reputation
52358
bio website maxvernon.tel
location Canada
age 45
visits member for 2 years, 2 months
seen 12 hours ago

Max Vernon is an independent consultant operating in the SQL Server and Microsoft.Net spaces. He has reasonable rates, and is open to engagements world-wide.

profile for Max Vernon on Stack Exchange, a network of free, community-driven Q&A sites
DBA.se all time rank

Join me on LinkedIn at http://www.linkedin.com/pub/max-vernon/23/a0/598
I'm on Twitter at: http://twitter.com/max_vernon
Check my Flickr photo stream: http://flickr.com/photos/max_vernon

My careers 2.0 profile is at http://careers.stackoverflow.com/maxvernon


13h
comment Getting error creating database in SQL Server 2005
Unfortunately without being actual mind readers it is pretty hard to provide a good answer to your question. As @RBarryYoung said, you'll need to provide details of the trigger.
18h
reviewed Close T-SQL Parsing XML escaped in format %3E (less than)
18h
reviewed Close Is there a standard mechanism for moving data to a remote database?
18h
reviewed Reviewed What are the dangers of non-IT managers using improper database terminology
18h
reviewed No Action Needed Why does this query take 32 sec to execute?
1d
comment SQL Server Replication Snapshot Agent login fails
An "infrastructure error" is just that. Infrastructure is not SQL Server... The error message is essentially saying it cannot authenticate against the domain correctly. Is the domain controller on the same physical network as both SQL servers? Does the Event Log on the domain controller show any pertinent errors?
1d
reviewed Close The most important oracle database performance metrics
1d
reviewed Close Seeing multiple CXPACKET blocks when trying to load data from a INSERT SELECT
1d
reviewed Approve suggested edit on Does the SQL Server backup process use a buffer cache?
1d
comment One to many size and performance
Please show your current table design along with your proposed design, and some sample queries you might run.
1d
comment Is there a way to suppress DBCC TRACEON/OFF messages in the Error Log?
There is a Microsoft Connect item to have 610 converted into a query hint; seems like a good idea. connect.microsoft.com/SQLServer/feedback/details/557515/…
1d
reviewed Close “DISTINCT” JOIN in mySQL
1d
comment Seeing multiple CXPACKET blocks when trying to load data from a INSERT SELECT
How long does it take to run the SELECT without the INSERT clause?
1d
revised Seeing multiple CXPACKET blocks when trying to load data from a INSERT SELECT
improved formatting
1d
reviewed No Action Needed One to many size and performance
1d
reviewed No Action Needed How to group by on two fields and count
1d
reviewed Close How to use SQLite3 in VB.Net 2013
1d
comment personal database
Just a hint for the future: if you are going to ask for help on homework, you should clearly state this is homework, and show all the things you've tried. And by things you've tried, I don't mean "I can't figure it out".
1d
reviewed Close personal database
1d
reviewed Close SQL Server migration from 2005/2008 to 2012