143 reputation
13
bio website desperadomar.blogspot.in
location Njarackal, India
age 24
visits member for 1 year, 9 months
seen 10 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


2d
comment MS SQL Server Implement Limit Functionality
Since its 2012 you can use offset fetch method for pagination
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
Nov
18
comment SSPI handshake failed with error code 0x80090308 connection to Sql Server 2008 R2
@MaxVernon, any good place to start kerberos authentication and sql server
Nov
18
comment Keeping an eye on contention
@MikeWalsh ,that's right a lot of dmv's give you great information regarding the blocking sessions,since the user needs the data which is prior to 30 minutes the only way to get that is to capture the info and store it into a table.we uses some techniques developed by this mvp(german I think)deadlock detection
Nov
17
answered Keeping an eye on contention
Oct
24
comment SQL Server Management Studio - connection with SQL Server database engine
,the other way is using sql server configuration manager where you can see the port used for TCP/IP protocol under sql server network configuraion
Oct
13
awarded  Popular Question