1,502 reputation
723
bio website
location Austin, TX
age 33
visits member for 3 years, 6 months
seen 2 days ago

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 suggested edit on Writing select result to a csv file
Oct
6
comment Should these two indexes suggested by the SSMS missing index feature be combined?
What indices exist right now? Assuming the execution plan is too complex to share, what are the most expensive steps?
Oct
1
comment I have this two models, which one is better?
Casting it once to save it to the database is normal. Presumably you'll be reading your data multiple times, however, so it would be helpful to not have to CAST again every time you do so. 50 sparse columns is a lot, but NULLs take up very little space; MS SQL offers the SPARSE flag which reduces it to zero (stackoverflow.com/questions/1398453/…); what's your RDBMS?