Difference between LEFT and RIGHT OUTER Joins in SQL – MySQL
What is Stored in tempdb? tempdb is used to store three different categories of temporary data: User Objects Internal Objects…
sp_spaceused gives the size of table and index but it gives the sum of size of all indexes on a…
AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from CodePlex site. AdventureWorks has replaced…
The standard un-install utility doesn’t work sometimes. This happens when there is usually more than one database instance.
SQL Server Find and Replace Values in All Tables and All Text Columns
Changing the default collation for an instance of SQL Server can be a complex operation and involves the following steps:
To rebuild system databases for an instance of SQL Server
Moving the tempdb database in SQL Server is a simple process but does require the service to be restarted. By…
SELECT SERVERPROPERTY(‘productversion’) as ‘Product Version’, SERVERPROPERTY (‘productlevel’) as ‘Product Level’, SERVERPROPERTY (‘edition’) as ‘Edition’ Query is show information about MS…