1,517 reputation
723
bio website
location Austin, TX
age 33
visits member for 3 years, 7 months
seen yesterday

2d
comment Query execution time in Oracle SQL Developer
On my machine (4.0.2.15, build 15.21) it doesn't reset, but it DOES freeze up, and often. It's been stuck at 00:32 for the past few minutes, now. Surely there's some other more robust way to get elapsed time?
Dec
9
comment How does Oracle 10g use indexes?
How many records do you have in your table? What's the cardinality like in these fields? A low-cardinality index may not be useful: it may be faster to just scan a table with 1 M records then to scan an index with 1 M entries, and then seek the full records for 500 K of them.
Nov
24
comment Professor told us to store serialized Java objects as blobs instead of defining relational tables
Is the professor's model to store everything in the application as blobs, or is this a solution for some specific pieces, as fdreger and Justin, and Ian Ringrose outlined? Are there other tables with "normal" typed data, or is this the extent of the schema?
Nov
24
comment Professor told us to store serialized Java objects as blobs instead of defining relational tables
This is a good example of why BLOB data types exist, but I don't think it justifies the professor's idea of storing each object as a blob, an ID, and nothing else, for an entire project, in a SQL database.
Nov
21
revised Associating on the ID of an association table
Added an illustration of srutsky's point about granularity
Nov
21
comment Associating on the ID of an association table
Agreed. And even if the transactional system doesn't really need it, data warehouse guys like me will be very grateful for you for recording historical prices!
Nov
21
answered Associating on the ID of an association table
Nov
14
comment Need help designing a database
I'm not sure I understand you. LastLoggedTime will need to to support 3600 x 24 x number of days unique values for a resolution of one second, yes, but a TIMESTAMP field covers that easily using eight bytes. Are you perhaps imagining an index as having one record for each possible value, pointing to the records, if any, that have that value? That would indeed be very inefficient for most RDBMS purposes.
Nov
13
answered Need help designing a database
Nov
10
comment Can I minimize maintenance of duplicated Windows + SQL Auth logins?
I understand that the division between Prod and Dev domains is obliged for some legal reason; there's financial data in Prod which has to be firewalled. It's moot when people can log in directly with SQL Auth anyway, but try telling that to lawyers. Using triggers to keep them in synch is an excellent idea, I will propose that if there's no better solution offered. Also, a good point re: AD and privs; the IT desk could make someone an admin on a prod server without us DBAs even being aware.
Nov
7
asked Can I minimize maintenance of duplicated Windows + SQL Auth logins?
Nov
5
accepted Ctrl-F1 shortcut stopped working in SSMS 2014
Nov
5
awarded  Popular Question
Oct
31
comment Ctrl-F1 shortcut stopped working in SSMS 2014
Thanks for taking the shot, but it doesn't look like this is the case: Ctrl-L still works. I may end up trying "Reset all settings," but there are a number of little things I like to tweak which I'd hate to redo if I can help it.
Oct
30
asked Ctrl-F1 shortcut stopped working in SSMS 2014
Oct
30
comment How to assign CTRL+F1 to sp_whoisactive in ssms 2012?
This is not true, or at least not always: I've used Ctrl-F1 for sp_whoisactive in MSSS 2012 and 2014.
Oct
21
comment Importing CSV file using SQL Server Import and Export Wizard (SQL Server Express)
Are external scripts an option? I've found the SQL Import/Export wizard to be a colossal pain, but one can whip up a simple C# app to read from a file and write to a table in a couple hours. I'm sure other languages are just as easy.
Oct
19
awarded  Notable Question
Oct
8
revised Writing select result to a csv file
Added some clarification about the bcp command line arguments.
Oct
8
suggested approved edit on Writing select result to a csv file