network profile
| bio | website | freetibet.org |
|---|---|---|
| location | Varna, Bulgaria | |
| age | 23 | |
| visits | member for | 1 year, 3 months |
| seen | 15 hours ago | |
| stats | profile views | 14 |
- Star Craft
- Football/Swimming
- Real Madrid FC
Free Tibet From China Domination
|
Nov 6 |
awarded | Enthusiast |
|
Sep 18 |
awarded | Organizer |
|
Sep 18 |
revised |
Query performance while using sqlcmd More tags added. |
|
Sep 18 |
suggested | suggested edit on Query performance while using sqlcmd |
|
Sep 6 |
awarded | Analytical |
|
Sep 6 |
awarded | Autobiographer |
|
Sep 6 |
accepted | IBM DB2 - store large files |
|
Sep 6 |
asked | IBM DB2 - store large files |
|
Sep 3 |
awarded | Critic |
|
Sep 3 |
comment |
Writing select result to a csv file +1 For BCP utility - it is very easy for use, it is the fastest tool that I have ever used for export/import information and there are a lot of options. I will advice you to add "> FileName.log" at the end of the statement - this will create a log file. |
|
Aug 27 |
accepted | DB2 Express-C 10.1 database move to DB2 Work group Server/Enterprise Edition |
|
Aug 27 |
comment |
DB2 Express-C 10.1 database move to DB2 Work group Server/Enterprise Edition Thank you very much for the answer. |
|
Aug 26 |
asked | DB2 Express-C 10.1 database move to DB2 Work group Server/Enterprise Edition |
|
Aug 16 |
awarded | Supporter |
|
Jan 28 |
comment |
T-SQL INNER JOIN Optimisation @Martin Smith You are right. I have compared the execution plans and they were the same. Maybe the difference that I get (a few seconds) is results of the traffic to the server. Anyway. I have read a lot of new things of how to optimize my view. The solution is one - make it a index view. I was amazed by the big difference in performance that I get with the test. Perfect. But, unfortunately, in my real case (that I have written about in this thread) I am not able to create a indexed view because of the limitations...So, waiting for this year SQLServer and hope it will be more easy to do this. |
|
Jan 26 |
awarded | Student |
|
Jan 26 |
awarded | Scholar |
|
Jan 26 |
accepted | T-SQL INNER JOIN Optimisation |
|
Jan 26 |
comment |
T-SQL INNER JOIN Optimisation Thank you all for the answers. It makes more sense now (even I have some guesses). I will test the convert and cast function's execution plans to see which one is better. |
|
Jan 26 |
comment |
T-SQL INNER JOIN Optimisation I have read about this when I was trying to find a way to optimize my joins. It was said that there is no difference, other people told that when you move the where after the join it will definitely help, but personally, in my case - i move all where clauses after the last join and the result was the same. |
