SQL Server – Configure tempdb to improve performance

How to Configure TempDB to improve performance As best practice, you should create multiple copy of tempdb data files matching to number of logical processors to reduce tempdb contention problem also advise to maintain same in size, you can use trace flag 1117 to keep data file in same size. Maximum number of tempdb data ...

Install Upgrade advisor 2014 – Before database upgrade

Database upgrade – Install Upgrade Advisor SQL Server upgrade Advisor tool helps you to analyze sql server component installed in your environment before upgrading to next version of SQL Server also generates the report that helps you to identify the issues in existing environment that can be fix either before or after upgrade. Prerequisites for ...

SQL Server – Create table statement and sql syntax

Database table is used to store data in column and rows format. Each table has its own name. Create Table Statement Using create table sql statement you can create a table inside your database. Note: Maximum number of column in table is 1024 CREATE TABLE table_name ( column_name datatype(size), column_name datatype(size), column_name datatype(size)…. ) Here, ...

SQL Server Date functions – How to use in query

SQL Server Date Functions While working with SQL Server Date function and to keep it simple, make sure that date column does not have time portion. Whenever you insert date in table verify that datatype of column should match with date format. SQL Server Functions helps you to convert date and time values to other date ...

SQL Introduction and basics

In simple terms, SQL is standard that is use to access database and for modifying data in the database. SQL introduction SQL is Structured Query Language, it allows to access data inside database. SQL follows an ANSI standard (American national standards institute). SQL lets you to communicate with database and using SQL you can Execute ...

SQL Server Database Audit feature in SQL SERVER 2014

Microsoft introduced audit feature in sql server 2008 which includes server and database level auditing. You can capture database objects, database level changes, lets say somebody deleted some records from your critical database, Bingo … means somebody is having DELETE permission on prod server apart from DBA, living in DANGER. As DBA we don’t allow ...

SQL Server 2014 – How to Create Memory Optimized table

In eariler post, you have learned how to use In-Memory OLTP Feature of SQL Server 2014 for your database. Here we will learn how to create memory optimized table in SQL Server 2014. Creating Memory is very simple similar to normal table. How to Create Memory Optimized table In Memory OLTP ? We will follow the step by ...

SQL Server 2014 – Limitation of Memory optimized tables

Every good things has some its pros and cons, so here are some of the limitions of In-Memory optimized tables in SQL Server 2014 Limition of Memory optimized tables Tables used in In-Memory OLTP feature of SQL Server 2014 are known as Memory optimized tables, SQL Server 2014 has some limitions for memory optimized tables Some datatypes ...

SQL Server 2014 – New Feature In-Memory OLTP Engine

SQL Server 2014 introduced many features to improve performance OLTP transactions, In-Memory OLTP is one of the most exciting feature in SQL Server 2014 which allows to move individual tables to special in-memory structures to improve query perfomance. What is In Memory OLTP Engine of SQL Server 2014 ? This is better than other in-memory solutions that require the ...

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 ...