#alter database

A few days ago, when the team performed some application deployment tasks, we noticed that the different schemas, created the datafiles, which belong to a TBS, were created at the destination of the CDB or PDB’s.

We start with the first task of verifying that the db_create_file_dest parameter was configured.

This parameter that differs in container paths as from PDB, is the one that…

Setting CE TraceFlags on a query-by-query (or session) basis

Using TraceFlags  on a query-by-query basis as described by Kimberly Tripp. This article does a great job of explaining this technique.

While the new cardinality estimator can offer benefits for some queries, it might not be perfect for ALLqueries. Having said that, there is an OPTION clause that allows you to set the CE for that query. The setting to use depends on the CE that you’re running…

Renaming your SQL Server Database

Renaming a SQL Server database is more difficult than you might be thinking. Sure, it is easy to change the name of the database in SSMS, or even by executing a script:

USE master GO ALTER DATABASE YOURDATABASENAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO EXEC master..sp_renamedb 'YOURDATABASENAME','YOUR_NEW_DATABASE_NAME' GO ALTER DATABASE YOUR_NEW_DATABASE_NAME SET MULTI_USER GO

New Post has been published on http://www.varindersandhu.in/2011/05/22/sql-server-database-read-only/

SQL Server - Database Read Only

Here is simple script with you can set your database in Read-Only Mode

Once you specify database is in read-only mode then users can read data from the database, not modify it.

Here is Script :

Mark Database Read Only

USE [master] GO ALTER DATABASE database_name SET READ_ONLY WITH NO_WAIT

Similarly you can change database Read-Only Mode to Read-Write

Here is script :

<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->

Mark Data Read- Write Mode

USE [master] GO ALTER DATABASE database_name SET READ_WRITE WITH NO_WAIT GO

Alternative way

1. Click the Start button.

2. Select All Programs.

3. Navigate to the Microsoft SQL Server 2008 folder.

4. Right Click on database then click properties

5. In the Option under State drop down

6. Mark Database Read-Only – True

SQL Server Compatibility Levels

With SQL Server 2014, there is a new compatibility level. You can operate SQL Server in a number of different compatibility levels, but you must change it from the default. These compatibility levels reflect the different versions of SQL server:

80 = SQL Server 2000 (Supported in SQL Server 2008 and SQL Server 2008 R2 or lower)

90 = SQL Server 2005 (Supported in SQL Server 2008 through SQL…