Start and Stop SQL Server Services using Command prompt

There are number of different ways to Start and Stop SQL Server services, you can using SQL Server Configuration Manger, SQL Server Mangement Studio, Sqlserver.exe, Command prompt and Windows Console . We will see how to start and stop SQL Server using Command Prompt. You can use Net Start and Net Stop command to Start and ...

Difference in Features of SQL Server 2012 Vs SQL Server 2014

SQL Server 2012 vs 2014 There are lots of new features added in SQL Server 2014 to improve query performance, main difference between SQL Server 2012 and SQL Server 2014 are listed in this article. * SQL Server 2012 supports upto 64 GB RAM, SQL Server 2014 supports 4 TB RAM. * SQL Server 2012 ...

SQL SERVER – Select Best Recovery Model for your database

Recovery model for sql server database is depends on customer requirement, SQL Server supports three recovery models, Full recovery, Simple recovery and bulk-logged recovery. Recovery models tells you whether How much data loss is acceptable by customer. SIMPLE RECOVERY If your database is not critical and Data loss is accepable by client after last full or differential backup than ...

SQL Server 2014 – Different Editions

Different Editions of SQL SERVER 2014 Select best SQL Server 2014 Editions for your environment to improve your business. Enterprise Edition SQL Server Enterprise delivers comprehensive high-end datacenter capabilities for demanding database and business intelligence requirements. Business Intelligence Edition SQL Server Business Intelligence empowers organizations to build and deploy secure, scalable and manageable self-service corporate BI solutions. Standard Edition ...

SQL Server 2012 -How to setup new Availability Group and Listener

Steps to setup new Availability Group and Listener in SQL 2012 Follow the below steps by step approach to setup new Availability Group and Listener using powerShell Script in SQL Server 2012. 1. Before starting ensure that you have the AG name, listener name and IP address ready. 2. On a new instance, endpoint need to be created. ...

SQL SERVER 2014 – New features

  New features in SQL Server 2014 It introdue lots of new features to improve performance 40 times better compare to older version of SQL Server for heavy workload queries. Top features of SQL Server 2014 are listed below. In-Memory OLTP Engine You can store tables and stored procedure in memory to improve query peformance, This ...

SQL Server – Transaction log for database ‘tempdb’ is full due to ACTIVE_TRANSACTION

Tempdb is full due to active transaction Tempdb database is part of SQL Server System database and gets created every time SQL Server Service starts. Tempdb stores temporary operations (like sorting and grouping data output etc) and tables, it stores lots of  information in cache to improve query performance in sql server. Whenever transaction log for ...

SQL Server Error – Cannot resolve collation conflict for equal to operation

Resolve collation conflict error in SQL Server This error comes up when you try to compare two different collation column in the query. To resolve collation conflict error you can use COLLATE DATABASE_DEFAULT option while comparing two different collation in select query. In my case, if I run the below select query in SQL Server using SSMS.  It ...

SQL Server – Move SQL Server 2000 System Databases

Move System Databases in sql server 2000 Moving all sql server system databases from new location to another location or different server, Here is step by step approach to move all system database at once 1. Update the startup parameters (i.e -d and -l ) for SQL Server with new location of mdf and ldf file. ...

SQL Server – MSDB System database

MSDB database SQL Server MSDB database part of System database. The MSDB database holds SQL Server Jobs details, alerts, Database mail and service broker. SQL Server stores all backup and restore history within tables in msdb. These backup and restore history is important in case to find out old full backup and file location. All ...