145 reputation
14
bio website desperadomar.blogspot.in
location Njarackal, India
age 25
visits member for 2 years, 3 months
seen Oct 7 at 4:35

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


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!
Feb
23
comment Performance of dynamic SQL Server reporting queries?
well you can find a good information from erland sommerskog article here sommarskog.se/dyn-search-2008.html but its for version 2008 but a good one to start
Dec
20
comment List table sizes for all tables on all databases
@cylindric, a useful link here
Dec
19
comment sql server database size shown different in properties pane
@ShawnMelton,given a shot to UPDATEUSAGE ,but didn't solved
Dec
19
comment How to move a SQL Agent Job to another Server?
hope this helps[stackoverflow.com/questions/5118243/…
Dec
19
revised sql server database size shown different in properties pane
corrected the code
Dec
19
comment sql server database size shown different in properties pane
@ShawnMelton,I will give it a try but before that, I suspect the Properties pane results are wrong because when I checked the physical space used on harddrive, it shows only 300mb(row+log)
Dec
19
asked sql server database size shown different in properties pane
Nov
18
comment Which user does Windows Authentication of a maintenance plan authenticate? before whom, why and for what?
@Fulproof,did you give a try what I said,this account which shows the account which sql server service is running, if you need to access a specific folder or a drive ,it is this account you have to give necessary permissions.I have given a solution how to find the sql server service account
Nov
18
comment How do I find all tables in a DB that have no explicit primary key?
,you were precisely correct about the object_id function, I just mixed things up there.well thanks for pointing it out.well the objectproperty() is available from 2005 onwards,I just checked bol,right?
Nov
18
comment How do I find all tables in a DB that have no explicit primary key?
well the object_id will work I thought we are using the function.but the sys.tables itself gives the id and thanks for showing this wonderful function.
Nov
18
revised How do I find all tables in a DB that have no explicit primary key?
table is a keyword and added parameter for `object_id`
Nov
18
suggested suggested edit on How do I find all tables in a DB that have no explicit primary key?
Nov
18
comment Which user does Windows Authentication of a maintenance plan authenticate? before whom, why and for what?
one info to find is SQL Server Service account is goto->services->right click on the service and click properties in the resulting box there is a tab log on in that this account shows the user that access resources outside sql server,in sql server agent its the user of sql server agent service account.this shows that the users are different when connections are made