Reputation
4,903
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
7 20
Newest
 Constituent
Impact
~479k people reached

1h
comment Review this ER Diagram?
I cannot speak for others, but I personally do not like questions that are clearly homework and avoid answering them. In my opinion, you do not learn anything by getting someone else to do it for you. If for example you said, I had this question, I gave this answer, for this reason, is there a better or more standardized way of doing it - then no problem. The way it was posted in your question led me to believe it had just been copied from a text book.
1h
comment Review this ER Diagram?
Is this a homework question?
4h
comment RestFul API with framework or pure code?
This does not belong on this site, I am going to vote to close it on here and transfer it to another site.
4h
answered I would like to emulate the Microsoft SQL Server function GetSqlBinary() in MySQL version 5.6
8h
comment Why is my query using parallelism, even with MAXDOP = 0?
@RafaelPiccinelli no problem - it happens. Sometimes you look at something so long you can't see the obvious. ;)
8h
comment Logon Trigger preventing any connection
Can you log in using the dedicated admin connection? technet.microsoft.com/en-us/library/ms178068(v=sql.105).aspx
8h
answered Why is my query using parallelism, even with MAXDOP = 0?
Feb
4
comment Remove duplicates in sequence based on keys
Is there a reason that you insert duplicate data (i.e. the second record is the same as the first but with a different date)? Can you not just update the time on the original record? Just helps me understand better
Feb
4
comment Foreign Keys doesn't work as I expect
I would second that, I never actually use cascading in my designs, it promotes lazy coding and has too much room for error.
Feb
4
answered Foreign Keys doesn't work as I expect
Feb
4
comment Most restricting permissions for querying view with linked server
What permissions did the account have prior to SA?
Feb
4
comment Design database -
That's up to you, if you don't have any additional information to add other than they are a manager or customer you could just add a column to your user table indicating the category instead. Then you would just have user, role and user_role
Feb
4
comment Most restricting permissions for querying view with linked server
That's not what I asked. I expect that you can using your AD account but you said you were using a SQL login to set up the linked server. Can you access the linked server with those credentials? I suspect not...
Feb
4
comment Most restricting permissions for querying view with linked server
If you used a sql login then the error means that the credentials you supplied don't exist on the target server. Can you query it?
Feb
4
answered Most restricting permissions for querying view with linked server
Feb
4
answered Design database -
Feb
3
comment MySQL - Compare record value against previous
@vsani there is nothing here that cannot be done with the solution that I provided you. You can add additional IF...ELSE statements within the body of the procedure if needed to handle your specific logic
Feb
3
revised MySQL - Compare record value against previous
Updated formatting
Feb
3
comment MySQL - Compare record value against previous
Sorry, your edit has confused the question even more. Did my solution below not meet your requirements?
Feb
3
comment How to split a wide table in Production?
@JohnM fair point, I was just mentioning what I did at the time but it's good to note going forward :)