Keep it Simple and Smart
We all know there are some system databases available in SQL Server. But we should have understanding about system databases. Here just try to give you understanding of system databases very briefly. There are four system databases available in SQL Server 2008 Master Model msdb tempdb Master Database The master
» Read moreHello Friends, I have setup the Linked server with the help of script here. My one of colleague helps me to write the script with we can map all user with one statement. This script will map all local SQL server users with remote user that you provide in the
» Read moreDear friends Most of time we have a question about difference between the SQL server editions, Lot of detailed stuff available over the internet but here sharing with you the brief information about the each SQL server editions so that we can understand easily about all the editions. SQL server
» Read moreDear friends, A new release of SQL Server is available, and if you follow blogs or tweets or check Microsoft’s SQL Server website. You might have seen mention of the new version, code-named “Denali” SQL Server 2011 – CTP1 Released. CTP stands for Community Technology Preview It’s available in both
» Read moreUNIQUE Creates a unique index on a table or view. A unique index is one in which no two rows are permitted to have the same index key value. A clustered index on a view must be unique. The Database Engine does not allow creating a unique index on columns
» Read moreFirst verify the “Distribute Transaction Coordinator” Service is running on both database server computer and client computers Go to “Administrative Tools > Services” Turn on the “Distribute Transaction Coordinator” Service if it is not running If it is running and client application is not on the same computer as the
» Read moreThis tool is a part of Microsoft .Net framework and like other tools this tool is also located in [drive:]%windir%Microsoft.NETFrameworkversion folder on your Web server.The ASP.NET SQL Server Registration tool is used to create a Microsoft SQL Server database for use by the SQL Server providers in ASP.NET, or to
» Read moreWe are using very few data type in SQL Server like INT, varchar,datetime etc But there are currently 37 datatype supported by SQL Server 2008 See the below scripts exec sp_datatype_info select * from sys.types exec sp_datatype_info_90 exec sp_datatype_info_100
» Read moreSQL Server code-named “Denali” Microsoft SQL Server code-named “Denali” empowers organizations to be more agile in today’s competitive market. Customers can efficiently deliver mission-critical solutions through a highly scalable and available platform. Industry-leading tools help developers quickly build innovative applications while data integration and management tools help deliver credible data
» Read moreHere is the quick script I use find file location for all the database in my server instance. SELECT Name, FileName FROM sysdatabases if you have any other way to find please share!!!
» Read moreVarinder Sandhu is using WP-Gravatar