393 reputation
420
bio website
location Toronto, Canada
age
visits member for 3 years, 4 months
seen Dec 22 at 22:17

SQL Server 2005/2008/2012


Dec
22
awarded  Popular Question
Dec
20
awarded  Popular Question
Dec
16
awarded  Notable Question
Dec
12
awarded  Popular Question
Nov
17
awarded  Notable Question
Nov
10
awarded  Notable Question
Nov
7
awarded  Popular Question
Oct
28
revised PostgreSQL + PG_Monz (Zabbix) DB size too large > 1073741824
added 182 characters in body
Oct
28
answered PostgreSQL + PG_Monz (Zabbix) DB size too large > 1073741824
Oct
27
asked PostgreSQL + PG_Monz (Zabbix) DB size too large > 1073741824
Sep
24
awarded  Autobiographer
Sep
12
comment Mirroring failed over - created 2 principal database and will not allow me to drop one of them
Yes - at which point the database for which I removed mirroring entered "principal, disonnected" state, this one I attempted to delete and failed. Another database in similar situation (for which I did not try to remove mirroring) reverted to being mirror, synchronized instead.
Sep
12
comment Mirroring failed over - created 2 principal database and will not allow me to drop one of them
Sadly I just solved this problem with a reboot of the server. The databases became Mirror/Synchronized after reboot. Sigh...though I'm glad it's fixed, it's not the solution I was hoping for
Sep
12
asked Mirroring failed over - created 2 principal database and will not allow me to drop one of them
Aug
28
accepted How to get Identity Column to jump ahead (by say 1000) on SQL Server 2012
Aug
27
asked How to get Identity Column to jump ahead (by say 1000) on SQL Server 2012
Aug
21
accepted PGAdmin III Server Status Error: Could not read directory “pg_log” No such file or directory
Aug
21
revised PGAdmin III Server Status Error: Could not read directory “pg_log” No such file or directory
added 74 characters in body
Aug
21
asked PGAdmin III Server Status Error: Could not read directory “pg_log” No such file or directory
Aug
16
accepted PostgreSQL Slave has more files in pg_xlog than /wal_archive