Skip to main content

Posts

What is LSN chain in SQL

What is LSN chain in SQL Every trasaction in sql server is identified by lsn number .means log sequence number If LSN is broken then u may not able to restore it. Hope LSN needed in order to perform restoration. LSN means log sequence number. Log file consists of internally log sequence number. If LSN is miss match we can't to restore data at point of time. We can restore For e.g you have 1 full back and 4 log files, suppose if ur LSN broken on 3rd log file, then we can restore up to log file 2 rest all we can't restore it.

Certifications options for IT Person

E-Business Suite Manufacturing, E-Business Suite E-Business Suite Manufacturing, E-Business Suite Procurement, E-Business Suite Project Management, E-Business Suite Supply Chain Management, -Business Suite Tools and Technology Hoodp SAP Cisco Certification, sales force, informatica, tera data, Oracle 11g/12c(OCA,OCP), Weblogic, ITIL,Sharepoint, Java,.Net, MicroSoft, E-Business Suite, E-Business Suite Financial Management, E-Business Suite Human Capital Management, Endeca Oracle Endeca Commerce, Fusion Applications, Fusion Governance Risk and Compliance, Hyperion, Data Relationship Management, Hyperion Financial Management Planning, JD Edwards EnterpriseOne, JD Edwards Financial Management, JD Edwards Project Management, JD Edwards Supply Chain Execution (Logistics), JD Edwards Tools and Technology Manufacturing and Engineering, ATG Web Commerce, ATG Developer, Agile, Agile Product Lifecycle Management, CRM On Demand, Oracle CRM On Demand, Deman

Activities That Cause a Checkpoint in SQL Server

Checkpoints occur in the following situations: 1. A CHECKPOINT statement is explicitly executed. A checkpoint occurs in the current database for the connection. 2. A minimally logged operation is performed in the database; for example, a bulk-copy operation is performed on a database that is using the Bulk-Logged recovery model. 3. Database files have been added or removed by using ALTER DATABASE. 4. An instance of SQL Server is stopped by a SHUTDOWN statement or by stopping the SQL Server (MSSQLSERVER) service. Either action causes a checkpoint in each database in the instance of SQL Server. 5. An instance of SQL Server periodically generates automatic checkpoints in each database to reduce the time that the instance would take to recover the database. 6. A database backup is taken. 7. An activity requiring a database shutdown is performed. For example, AUTO_CLOSE is ON and the last user connection to the database is closed, or a database option change is made that req

Max degree of parallelism Property in sql server

Question -What is  max degree of parallelism in SQL server and how can we find the parallelism which has been in  SQL  server Answer : When we execute a query number of processes use in parallel  execution Parallelism is to execute a query Some process is required if the process required more time to execute the query. So we have to enable parallelism. In parallelism we mention max degree of parallelism is number of processes is you are allowed to execute that query nothing else. When this parallelism is applied to a query that query cost reach to cost threshold for parallelism by default its value is zero. You can set it to 1 or another number based on hardware configuration for Memory. Example sp_configure 'show advanced options', 1; GO RECONFIGURE WITH OVERRIDE; GO sp_configure 'max degree of parallelism', 1; GO RECONFIGURE WITH OVERRIDE; GO

Decrease SQL Server Database and Table Size with simple steps

In this clip shows you Practical Tips to Reduce SQL Server Database annd Table Size . The  Steps are provided but process is taking time so final result not shown . You can check from your end by applying steps and it will be for your practice exercise also. How to Shrink MDF,LDF Database Data  and log File in SQL Server and How to check size of all tables in database. Script is  provided to get all table records count,used space,unused space etc.   You can check single as well as multiple table details by checking query in script. If you clean log files before database shrinking then you will able to decrease more size for database. Database size increased due to daily transaction by users and log file size getting huge so you can see this clip to reduce the size of database to improve disk space. You can also set batch job to do in automatically based on time frame you given for batch job in SQL. You can visit below online clip to get more details. If you like

Table data Backup steps from database in SQL Management Studio

How You  can take table backup in sql database There is simple way and step shown in below youtube clip. 1.Open SQL database engine and connect it. 2.let us You want to copy data of table custtable to  table custtable_bkp where custtable_bkp does not exist in your database. 3. This clip will show the step and will create new table with data of custtable . 4. In this clip select into statement used same way you can do the same using insert into command also but insert into used if table custtable_bkp already exist with structure only not data. 5. If you want to drop or delete table you can use this command. drop table <table name> Mow after execution  drop command table will be deleted.. Thanks for watching. If you like it please subscribe

VAT vs GST

How to assign permission for database to user in SQL Server 2012

How to assign permission for database to user . First you need to Connect with database engine in SQL server Then go to security option after databases Then expand  users and select user. then You need to go to user mapping tab. Tick  to yes for your selected database to assign permission . Then select permission. Thanks for watching this clip.

How to Create a Differential Database Backup and Restore in SQL Server 2012 online training clip

This is an Example of differential backup in SQL server 2012 . Following is the Step-by-Step Approach to Differential Backup for database. 1.let us create one database 2.Now create  one single table 3.You need to Insert  two line records in table 4.Take full backup of data base as mentioned on clips Right click on the database name Select Tasks -> Backup  Select "full" as the backup type for taking full backup Select "Disk" as the destination folder and select path of folder  Click on "Add." to add a backup file and type  and click "OK" to start backup Click "OK" again to create the backup .  5.Now insert one more line in table. 6.Then take differential backup   as mentioned on clip Right click on the database name Select Tasks -> Backup  Select "Differential" as the backup type for taking full backup Select "Disk" as the destination folder and select path of folder  Click on "Add.&q

SQL Database shrinking full step details with Screenshots to reduce database size

Step 1: (‎05-‎Mar-‎17 4:00:46 PM) User right click on "MicrosoftDynamicsAX (tree item)" in "Microsoft SQL Server Management Studio" Step 2: (‎05-‎Mar-‎17 4:00:49 PM) User left click on "Properties (menu item)" Step 3: (‎05-‎Mar-‎17 4:00:56 PM) User left click on "Options (tree item)" in "Database Properties - MicrosoftDynamicsAX" Step 4: (‎05-‎Mar-‎17 4:00:59 PM) User left click on "Auto Shrink ()" in "Database Properties - MicrosoftDynamicsAX" Step 5: (‎05-‎Mar-‎17 4:01:00 PM) User left click on "Open (button)" in "Database Properties - MicrosoftDynamicsAX" Step 6: (‎05-‎Mar-‎17 4:01:02 PM) User left click on "containmentTypeComboBox (combo box)" in "Database Properties - MicrosoftDynamicsAX" Step 7: (‎05-‎Mar-‎17 4:01:03 PM) User left click on "Recovery model: (co

Create Index From SQL of Expensive queries

Index creation from expensive query from SQL You can use Activity monitor of SQL . Then you can find missing index detail from show execution plan by right click on query. Add caption If its ax then you can create it from AOT step provided at the end of video.