4,716 reputation
11137
bio website stanleyjohns.wordpress.com
location Canada
age 33
visits member for 3 years, 6 months
seen Jan 19 at 8:32

Passionate about faster retrieval of data, and high scalability. Specializing in SQL server and little MySQL.

MCTS: SQL 2005, SQL 2008, SQL 2008 development.

MCITP: SQL 2005, SQL 2008.


Sep
30
awarded  Explainer
Sep
24
awarded  Popular Question
Apr
13
awarded  Yearling
Dec
11
awarded  Notable Question
Sep
27
reviewed Close How To Speed up Merge Replication
Sep
27
reviewed Close Cannot restore Amazon RDS SQL Server database to given point-in-time using SQL Server Management Studio
Sep
27
reviewed Close Sort a non-grouped (SUM) column in descending order
Sep
27
reviewed Close Pros/Cons of Using Table/Index Partitioning in SQL Server
Sep
27
reviewed Close Huge sizes Replication Tables in Sql Server db, how to deal with?
Sep
27
reviewed Close How to properly design this type of relationship
Sep
27
reviewed Leave Open Easy replication for SQL Server: Can it be set up like mongodb or Oracle?
Sep
25
reviewed No Action Needed ERROR 1166 (42000) at line 65203: Incorrect column name ''
Sep
25
reviewed No Action Needed MySQL 1366 Error on Replication Slave
Sep
25
reviewed Approve suggested edit on ERROR 1166 (42000) at line 65203: Incorrect column name ''
Sep
24
reviewed Close Increase all primary key values by 1
Sep
24
reviewed Close SQL Insert error Column name or number of supplied values
Sep
23
reviewed Leave Open Nested with - Incorrect syntax near the keyword 'WITH'
Sep
23
reviewed No Action Needed Location of the mdf file of the database
Sep
22
reviewed Close Custom Auto-Generated Sequences with SQL Server
Sep
22
reviewed Close How can I move one table from one database to other database