152 reputation
114
bio website desperadomar.blogspot.in
location Njarackal, India
age 25
visits member for 2 years, 8 months
seen 18 hours ago

Starting a career in dba and also a maths physics enthusiast ,fan of mir publications in russia and a passion to develop wonderful websites


Mar
19
comment calculate perfomance of sql server
rusanu.com/2014/02/24/how-to-analyse-sql-server-performance
Mar
18
revised No value to update but still an TABLE UPDATE Operator
added execution plan
Mar
18
revised No value to update but still an TABLE UPDATE Operator
[Edit removed during grace period]
Mar
18
comment No value to update but still an TABLE UPDATE Operator
Agree with the optimizer will generate a general plan , but why this much cost? And I did liked that analogy. Oops I came to conclusion with out proper understanding , need to go back and try hard.
Mar
18
asked No value to update but still an TABLE UPDATE Operator
Feb
17
comment General access denied error while using import data in SSMS
@ITresearcher, I hope you posted this here in Microsoft forums here(social.msdn.microsoft.com/Forums/sqlserver/en-US/…) have you tried all the solutions provided
Feb
17
comment General access denied error while using import data in SSMS
@ITresearcher, Not sure but can you do the OPENROWSET method to import data , if it give a success its not a login access issue.
Feb
5
comment SQL Maintenance Rebuild Fails
@dtaylor, I think it's a maintenance plan , you can also check the log under management->maintenance plan -> your maintenance plan and right click on it and click historyyou will get some lead from there.
Jan
31
revised How to get best mark for each Student
Need an alias since the output shown by OP has one
Jan
31
suggested approved edit on How to get best mark for each Student
Jan
31
comment Application is hanging when database upgraded from SQL Server 2000 to SQL Server 2008 R2
@KiranRS To know if it's due to 2008R2 , I hope changing the compatibility level to 2000 version and checking the issue is solved
Jan
27
awarded  Notable Question
Jan
25
comment Uexpected values inserted in table
can you post the DDL for FunctionWeights and your TVF's
Jul
28
comment Nightly reload of tables from a linked server
@Geoff Dwady, since your are truncating the table, a better option is to create a new table, push the records to it and rename the table. I hope it will be faster since the truncating time is NIL. After that you can easily delete the old table without causing any issues.
Jul
28
answered Get the table affected by the query
Jul
23
comment LIKE to select the independent existence of the word whereever in the text
@gbn how the multiple OR is done with adding spaces between [textvalue]?Can you give a brief comment on it.
Jul
2
awarded  Curious
Apr
27
accepted SQL Server BPA 2008R2
Apr
27
comment SQL Server BPA 2008R2
@ellert hjelmeseth, thanks for the T-SQL solution works like a charm. This was little easy for me since I am a newbie in powershell.run and verified.
Mar
21
comment How to open SQL Server 2008 R2 Configuration manager in Windows 8.1
I always use this press win+F and type configuration manager ,it will be listed in any of the sub lists ,i can't test it since i just uninstalled it due to the lack of the old start button!