9,247 reputation
52052
bio website blog.mvct.com
location Canada
age 45
visits member for 2 years
seen 11 hours ago

Professional Developer / SQL Server DBA

profile for Max Vernon on Stack Exchange, a network of free, community-driven Q&A sites

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

DBA.se all time rank

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


1d
reviewed Close Scaling mongoDB & Node.js
1d
reviewed Close aggregate type problem
1d
reviewed No Action Needed Run job once a minute, every day, except during a certain time
1d
reviewed Approve suggested edit on DB2 Materialised Query Table performance problems
1d
comment Database Timeout expiring when tables fill up
You really need to show us something more than a shrug report in order to get a good answer.
1d
reviewed No Action Needed Allow filtering not working as expected
1d
reviewed Reviewed Avamar SQL Agent running against live SQL Server databases
1d
comment Database Timeout expiring when tables fill up
So, no rows, everything is fast? Lots of rows, server has to work and it's slower? And, problem?
1d
comment Database Timeout expiring when tables fill up
SQL Server? Or some other type SQL server?
1d
comment PostGIS vs. SQL Server for GIS data
The age old mantra of use what you know certainly applies here. Switching to a different platform always seems like a great idea before embarking on the change. Not so much later, when you're 6 months into it and realize you have only just started to gain the necessary knowledge. Ever heard of opportunity cost?
1d
comment What do cursors do internally?
If you could add it to your question, it would be nice to see the code for the SP that implements the cursor, and for the one that does not.
1d
reviewed Approve suggested edit on infosphere-data-architect tag wiki
1d
reviewed Approve suggested edit on infosphere-data-architect tag wiki excerpt
1d
reviewed No Action Needed What track should i study towards? Oracle 11g, Oracle 10g or Oracle 12c
1d
reviewed Looks OK Environment Varible PATH exceeding recommended length solution?
1d
comment How to get Identity Column to jump ahead (by say 1000) on SQL Server 2012
Specifying the schema is not a huge problem until you start using more than just dbo. Still doesn't hurt to be direct about your intention, and will prevent hard-to-troubleshoot problems in future.
2d
comment Many small queries or one single query
If you add the design of your tables, with some sample data, and some desired output, I'm 99% certain you (we) can produce a query that will run in far far less than 80ms.
2d
comment Many small queries or one single query
Stop using RBAR methodologies. duckduckgo.com/?q=sql+set+based+design vs simple-talk.com/sql/t-sql-programming/…
2d
comment How to get Identity Column to jump ahead (by say 1000) on SQL Server 2012
+1; I may be preaching to the choir here, but you should get in the habit of appending a ; to every statement in T-SQL, and you should add the schema whenever referencing an object, such as dbo.YourTable
2d
revised How to get Identity Column to jump ahead (by say 1000) on SQL Server 2012
improved formatting