Reputation
440
Top tag
Next privilege 500 Rep.
Access review queues
Badges
6 15
Newest
 Excavator
Impact
~19k people reached

Apr
28
awarded  Excavator
Apr
28
revised Moving DB Log destination?
missing ) in the code; made it clearer when to delete the source file
Apr
28
comment How to use a cross reference table for different features of a product in different versions?
To tell us about your tables, post your DDL (CREATE TABLE etc). To tell us about your required output, show an example. It's pretty difficult to work out what you want from your current text.
Apr
28
suggested approved edit on Moving DB Log destination?
Mar
22
comment Database design for ordering complex products
I don't have time to answer, but it seems to me that what a customer orders is not in fact a single 'product' but a collection of order line items (think, the items listed on their receipt or invoice). On the other hand, for the sizes I would say yes you should have three db records for the different sizes, but also some new field that S M L have in common for a given product.
Mar
16
comment What is the best practices for storing sales tax rates?
My inner pedant is shuddering a little at 'almost infinitely' :)
Mar
1
comment How do I copy a table with SELECT INTO but ignore the IDENTITY property?
Except that that won't get you any rows...
Dec
15
comment Moving SQL Server database to a new disk while online
You're getting downvotes because you're not answering the question. There's only one server in the situation under discussion.
Nov
19
comment Determine Which Parameters Passed Into Stored Procedure
The obvious answer is that if you care about this, don't use default values?
Nov
5
comment Is there a way that I can merge the following update queries into one?
@ypercube fair points. Your own answer would of course be welcome...
Nov
4
comment Is there a way that I can merge the following update queries into one?
I'm guessing you can work out the third line then. The IN expression in the WHERE clause in Julien Vavasseur's answer should improve performance, if there's a lot of data to consider.
Nov
4
answered Is there a way that I can merge the following update queries into one?
Oct
21
awarded  Yearling
Oct
2
comment Fact Table with day grain that has many records that don't change
"which is getting a bit excessive" - a bit excessive for what? An organisation in a financial arena that has 14 million accounts probably has a bit of cash knocking around for db storage; why not use it?
Sep
22
comment modelling grocery orders, that can be split into multiple short orders
I don't have time to give a full answer, so I'll just offer: New table OrderPart that contains 1..n records per Order.
Sep
11
revised Cannot find either column “dba” or the user-defined function or aggregate “schema.functionName”, or the name is ambiguous
code formatting
Sep
11
suggested approved edit on Cannot find either column “dba” or the user-defined function or aggregate “schema.functionName”, or the name is ambiguous
Aug
4
awarded  Constituent
Jul
28
awarded  Caucus
Jul
1
awarded  Notable Question