.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

How to find the last restart time and date of sql server?

Posted By :Deco     Posted Date :September 20, 2010    Points :10   Category :Sql Server 
First Check the recent error log
Then Check the creation of TempDb
Click Start and hit Run then type "Net Statistics server" in command prompt.


You can also find related Interview Question to How to find the last restart time and date of sql server?  below: 

How to find the last backup time and date for particular database

  
step1: open enterprise manager

step2: select the particular database -->properties-->Now we are able to see last full,transaction log backup time and date (More...)

Should validation (did the user enter a real date) occur server-side or client-side? Why?

  
Validation will be done in both sides i.e., at the server side and client side. Server side validation will be done even though client side validation performed on the code because of proper
security reasons. (More...)

Which property needs to be set for script manager control to extend the time before throwing time out expection if no response is received from the server?

  
AsyncPostBackTimeout Property needs to set which gets or sets a value that indicates the time, in seconds, before asynchronous postback time out if no response is received from the server.




The default value of this property is 90 second. We can also set the user defined error message using asyncpostbackerrormessage property (as shown in above code) for time out. (More...)

How can we find the open transactions details in sql server?

  
Yes, it is possible.

select * from sysprocesses where open_tran > 0


This query will provide list of all the open transaction details. (More...)

How to Find Number of Days for provided date range?

  
Code extract :

TimeSpan DayDifference = Convert.ToDateTime("2009-1-7").Subtract(Convert.ToDateTime("2009-1-1"));


To find the difference of the days, here we have used Subtract method. The Subtract method does not take start date into consideration. Hence, to get the exact number of days for the date range we need to add one more day to the result.

Response.Write("Number of Days : " + DayDifference.Days+1); (More...)

How to find out server name using query

  


SELECT @@SERVERNAME as Server Name


The results look like the following:

Server Name
---------------------------------
Server1 (More...)

how to find the table name in sql server database?

  
select * from INFORMATION_SCHEMA.tables where table_name like 'tblname%' (More...)

how to find column name from sql server table?

  
select * from INFORMATION_SCHEMA.Columns where column_name like 'colname%' (More...)

How to get yesterday date in sql server?

  
Just use the follwing query

select yesterdaydate=getdate()-1 (More...)

1.Should validation (did the user enter a real date) occur server-side or client-side? Why?

  
client side . there is no need to go to validate user input. If it relates to data base validation we need to validate at server side. (More...)

how to get Indian time in U.S Server?

  
You can use the below Query to get the Indian Time

SELECT DATEADD(Minute, 30, DATEADD(Hour, 5, GETUTCDATE())) AS [Indian Time] (More...)

Where would you find ULS logs on Office Web Apps (OWA) 2013 server?

  

C:\ProgramData\Microsoft\OfficeWebApps\Data\Logs\ULS folder (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend