meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 8 months |
| seen | 6 hours ago | |
| stats | profile views | 123 |
|
6h |
comment |
Are individual queries faster than joins? Your answer is so much better than mine, that I deleted mine. This is what I wanted to say but didn't manage to actually say. |
|
1d |
comment |
Effects of good and bad database designs Poor Performance is an effect of bad design. |
|
May 14 |
comment |
Left Join not giving desired result Your problem is the data doesn't support the result set you want. You have no payments for fee 300. |
|
May 14 |
answered | Left Join not giving desired result |
|
May 8 |
comment |
Trigger Performance : Is Using Trigger is a good way? Another benefit of using triggers for auditing it that it catches changes that are made outside the application including those made maliciously by disgruntled employees. Ther are also many times when an ad hoc query is written to change data. Auditing should NEVER be anywhere except the database. Doing it inthe application totally defeats the purpose of auditing. |
|
May 7 |
comment |
Tool to view intermediate query results Of course you are far less likely to get a Cartesian product accidentally if you use explicit joins. |
|
May 3 |
comment |
How can we get table name from inside trigger? and since you would need to change all references to that table why is that a problem? Personally it is rare to ever change a table name in a good design. If you are thinking about changing names, then you probably need to rethink that. |
|
May 3 |
comment |
Real-time merge of two databases on different servers IS there some reason why you haven't tried using replication? |
|
Apr 29 |
comment |
Performance issues moving 1 million rows between tables @dezo, that information is easily avialble in Books Online. This answer is fine as it is. We don't need to spoon feed people. |
|
Apr 22 |
awarded | Necromancer |
|
Apr 18 |
comment |
Optimizations Possible - SQLServer Reallly stop using implict joins, this is the 21st century after all. Those queries are harder to debug, likely to be harder to maintain and are far liklier to return the incorrect result. |
|
Apr 17 |
comment |
Why are constraints applied in the database rather than the code? You should never base a database design on the objects in your application. You would noramlly design this as person, then have a related table to deinfe the persons roles. Then the problem doesn;t come up as you havea realted table for the roles sso people can have multiple roles. If you want to have only one role person, then you constrain the table so that the peopleID is unique. When you want to change that remove teh constraint. |
|
Apr 17 |
comment |
Why are constraints applied in the database rather than the code? Excellent point about application developers designing for the editors and not the users of the data. |
|
Apr 17 |
revised |
MySQL: Join one Row in a table with two Rows in other table fixed code based on comment |
|
Apr 16 |
comment |
MySQL: Join one Row in a table with two Rows in other table If you would never have the case where the person is also the created by or if you would want two records in that case, then use UNION ALL as it tends to be faster. |
|
Apr 16 |
answered | MySQL: Join one Row in a table with two Rows in other table |
|
Apr 16 |
comment |
MySQL: Join one Row in a table with two Rows in other table You did use a join you just used an implict join whch you shoudl stop using as they are SQL antipatterns |
|
Apr 15 |
comment |
Approach for a 2,000 table migration If the structures will be different, it is worth the time to specifically figure out the mappings of every table/column to the new version. That takes a while in 2000 table migration but having amapping document will help you tremendously. Especially when you have differnt datatypes and you must convert them and what to do if the data cannot convert. Your current system may have dates stored in varchar and has some records where the date isn't a real date, if the new system uses date datatypes for dates, then you have to figure out what to do with the data that won't fit into it. |
|
Apr 12 |
comment |
How database administrators can see my requests to MSSQL server? Why would a dba answer this question? |
|
Apr 12 |
answered | Why are constraints applied in the database rather than the code? |
