What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?2 9887
Difference between Cluster and Non-cluster index?32 122343
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1124
explain different types of jions with examples briefly?2 5508
Which databases are part of SQL server default installation? Explain the usage of each?2 4607
What all db objects can be found in MSDB database of a SQL Server instance?2 4842
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?3 8283
What is Query Execution Plan? How does it help optimize or tune a database driven application?2 6895
How do you fine the performance tunning?2 5287
What are mdf,ndf,ldf files and how to see the data in those files?6 53024
how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?15 13951
Differences between functions and stored procedures?8 8839
event classes in sql server2 4388
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.11 10892
What happens when you invoke a method on a nil pointer?
salam&hi, i need to know about how can i calculate an enough current for the new building before i submit it to the suppliers
Snake Game: This is normal snake game which you can find in most of the mobiles. You can develop it in Java, C/C++, C# or what ever language you know.
!what are the entry criteria for antomation testing ?
What are the main constrains of SCSI in storage networking?
Why sometime potassium ortho phosphate mix with acetone use for sample preparation for hplc
4 down vote favorite share [g+] share [fb] share [tw] I am developing my site using server side sessions using redis as backend for saving the session. Now the issue which is bothering me is of user leaving the website without logging out. I mean user simply closes the browser which causes the cookie to be deleted. Now session of that user still exists on the server and will not be used again as new login requires creating a new session due to security reasons. To avoid the case where hacker steals the old cookie and use it after user login again with same old session id. In essence user leaves the website without explicitly logging out and his session will be deleted after certain time limit of inaccessibility. I am thinking time limit of 30-60 minutes. Also with every new request from user his cookie will also be updated to keep track of when the user last time accessed the site. But nowadays, people let site remain open for long time without accessing it. For example users open facebook and gmail in new tabs and forget about them for 2-3 hours and still they are not asked to login again. Is letting a 2-3 hours old cooke access the session secure? My concern is someone steals user cookie and use it 2-3 hours later. Thinking on this topic has also forced me to question how facebook manages security if user can use a session where they are not accessing it for long periods of time and still they remain logged in. Or is it not secure for me to keep logged in when am not accessing the site session for longer period of time? It can be the case also there is some pinging mechanism using which sites keep track of user having their site open in a browser and when browser closes they are notified and can work accordingly. My website is a social network and needs all those security and usage features which a social network may need. I am new to web security and web development in general and may be the case where my above questions may seem a little basic. If you feel that is the case kindly point to some good reference where I can read and find answers to my question.
difference between checkbox vs radiobutton??
What is the Branch Accountant Responsbilities ?
what happen if drive input fail momentry at 48.5 HZ frequency?
what is Ratio Analysis ?
How to calculate pitch, gauge of winding wire, and No. of turns for 30HP, 3 phase, 4 poles 50Hz, 380V induction motors
what is the advantages of having in-built acvvvf (without seperate inverter in the control panel)in the drive system of elevators?
it is in our knowledge tht right plug of supply of residential suppy system is phase n other is neutral...howevr the battery charger of mobile works in both ways...i mean it is not restricted in only one direction.ny of the holder of charger can hav phase .so y is it not lik tht phase of supply must b connected 2 phase of charger...?
Plz any one send the sharepoint interview question @ email@example.com