196 reputation
3
bio website ameble.com
location Prishtina, Kosovo
age 28
visits member for 3 years, 4 months
seen Jun 2 at 13:22

I'm a technology enthusiast, and professional database administrator. I seek to learn and experience the newest trends in development too.


Feb
23
comment Is matriculation number a good primary key?
You will end up having a dozen of indexes anyway, having +1 in this case will not affect performance that much, it will slow down a bit data modifications, but in other cases it might help reads. But overall, you will gain more than you'll loose. Don't forget any relationships this table might have.
Feb
23
comment Is matriculation number a good primary key?
Yeah you're correct. But in case that the table is clustered, index size matters. Unique is implemented with non-clustered indexes, at least this is the case in SQL Server.
Feb
23
answered Is matriculation number a good primary key?
Feb
23
answered General table name for Person Inf
Feb
23
comment UPDATE table with another table data
Could you tell what do you want to achieve, what is not working?
Aug
13
comment which one is more efficient query?
You are wrong my friend, he needs the last student that rolled in a class, so that has nothing to do with StudentID (for that matter it could have been that StudentID was not an auto generated sequential number). So the correct way is to sort by enrollment date descending.
Aug
13
comment which one is more efficient query?
You can view the query plan associated with each query. If you need more in regard to query plans find some basic stuff here simple-talk.com/sql/performance/execution-plan-basics
Aug
13
comment which one is more efficient query?
Definitively stick to the first option. The second option needs another scan / seek to the table depending on your index to find the MAX value which is unnecessary.
Aug
13
comment What is a good way to query data stored in multiple identical tables split by date/time
You could also generate a dynamic query, but since you have a specific number of tables you will get a better performance if you stick to UNION.
Jul
27
awarded  Supporter
Jul
27
answered SQL Server 2012 Standard Edition - multiple instances and memory utilization
Jul
27
answered sp_send_dbmail fails when mailing queries, but no error returned, query just hangs
Jul
23
awarded  Teacher
Jul
22
answered Is adding rows better then adding columns in case their value is not consistent?
Jul
22
answered Import data problem in SQL Server 2008
Jun
2
awarded  Autobiographer