149 reputation
18
bio website freetibet.org
location Varna, Bulgaria
age 24
visits member for 2 years, 2 months
seen Mar 24 at 13:08

Free Tibet From China Domination

http://freetibet.org/about/10-facts-about-tibet

enter image description here


Jan
9
comment Performance difference for COALESCE versus ISNULL?
So, in cases where the both functions can do the same thing like COALESCE(@VAR,'') and ISNULL(@VAR,''), knowing that ISNULL is internal engine function means we should use it? To be more accurate, talking about SQL Server 2012.
Aug
27
awarded  Popular Question
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