How to repair a suspect DB in MSSQL

Issue You have a database in MS SQL that is tagged as (suspect) and you are unable to connect to the database. Possible Causes The database could have become corrupted. There is not enough space available for the SQL Server to recover the database during startup. The database cannot be opened due to inaccessible files… Continue reading How to repair a suspect DB in MSSQL

SharePoint 2013 and SQL Server AlwaysOn – High Availability SharePoint

AlwaysOn is a great new feature to SQL Server 2012 that allows consuming clients to have a mirroring and failover database solution all transparently for a single named instance. SharePoint is one such consumer of SQL and depends on having a solid connectivity to run. If SQL goes down, so does SharePoint so it’s well… Continue reading SharePoint 2013 and SQL Server AlwaysOn – High Availability SharePoint

How to get Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server

Many a times we may need to get the Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server. In this article we will see how we can get these parts of the DateTime in Sql Server. You may like to read the other popular articles on Date and Time: How to get… Continue reading How to get Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server

SQL Server 2012 Error 15023 : User already exists in current database.

1) This is the best Solution. First of all run following T-SQL Query in Query Analyzer. This will return all the existing users in database in result pan. USE YourDB GO EXEC sp_change_users_login ‘Report’ GO Run following T-SQL Query in Query Analyzer to associate login with the username. ‘Auto_Fix’ attribute will create the user in… Continue reading SQL Server 2012 Error 15023 : User already exists in current database.

How to Shrink LDF File Size using SQL Management Studio

If the transaction log file (.ldf) in Microsoft SQL is too big, it can cause performance issues, eat up valuable disk space and consume resources when you back up. Therefore it’s imperative to periodically maintain the database to keep the .ldf file under control. To reduce the .ldf file, you must do threethings: Backup the… Continue reading How to Shrink LDF File Size using SQL Management Studio

Unable to install this application because an application with the same identity is already installed.

This kind of error I get trying to edit rdl file by Report Bulider 3.0. After while I figured out that I need do this two steps : 1. Open a command prompt. Enter the following:  rundll32 dfshim CleanOnlineAppCache Press Enter. 2.  Go to the C:\Users\[User Name]\AppData\Local\Apps\2.0 Delete the all temporay files. *You may want… Continue reading Unable to install this application because an application with the same identity is already installed.