Find the size of Indexes in SQL Server
sp_spaceused gives the size of table and index but it gives the sum of size of all indexes on a…
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…
If a user wants to finds out when was the last table updated user can query dynamic management view (dmv)…
Microsoft SQL Server üzerinde bir kullanıcıya “User Map” kullanarak “dbowner” yetkisi verilmek istendiğinde “Cannot use the special principal ‘user_name’. (Microsoft…