1,460 reputation
1720
bio website
location California
age 42
visits member for 2 years, 6 months
seen Jun 11 at 17:21

email is "stackoverflow dit com atthedomain esquared dit mooo dit com", replace dit with . and atthedomain with @


Jul
22
awarded  Notable Question
Jul
2
awarded  Curious
Apr
10
awarded  Notable Question
Mar
7
awarded  Famous Question
Mar
3
awarded  Revival
Mar
3
revised How to improve performance if index is not Most SELECTIVE?
deleted 1 characters in body
Feb
1
revised How to improve performance if index is not Most SELECTIVE?
add tag sql-server-2008-r2
Feb
1
suggested suggested edit on How to improve performance if index is not Most SELECTIVE?
Feb
1
answered How to improve performance if index is not Most SELECTIVE?
Feb
1
comment How to improve performance if index is not Most SELECTIVE?
Does 1,80,000 mean 1,800,000 or 180,000?
Jan
28
awarded  Yearling
Nov
14
comment MySQL vs SQL Server Express (Compare Free DBMS)
Note: later versions of SQL Server Express / Compact / CE support larger database sizes and other higher limits.
Oct
11
comment Syntax for restoring SQL Server backup from non-disk source
@Kin It is a virtual server--but I'm confused because a few weeks ago it wasn't a virtual server and I saw the same GUID style for backup.
Oct
11
revised Syntax for restoring SQL Server backup from non-disk source
deleted 2 characters in body
Oct
11
comment Syntax for restoring SQL Server backup from non-disk source
@RLF There's no mixing and matching that I know of... I'm not going to be taking my own backups. If you mean that I can't restore such backups using SQL Server then okay, but you didn't really spell it out.
Oct
11
revised Syntax for restoring SQL Server backup from non-disk source
deleted 2 characters in body
Oct
11
comment Restoring a backup to an older version of SQL Server
@ThomasRushton That script is by definition going to be bigger than the database itself, probably by at least double if not worse! I hope it's not a 50 GB database...
Oct
11
asked Syntax for restoring SQL Server backup from non-disk source
Sep
11
answered Why are queries parsed in such a way that disallows the use of column aliases in most clauses?
Jun
8
comment financial transactions with and without commissions
@cosmolev Look into the supertype-subtype pattern. The GenericTransactions table would be the supertype, and you could put all common columns in it, so that for many queries you wouldn't need to join to the other tables (except when dealing with the columns that are specific to each transaction type). Basically, you convert NULL values in columns to the absence of rows in another table. The other, subtype, tables share the same ID as its supertype ID.