How to check if a table exists in SQL Server database

There are several methods to check if a table exists in SQL Server database. Using INFORMATION_SCHEMA.TABLES Query like below can be used to check if a Table exists in the…

Read more »

SQL Server Performance Monitoring Software by AppDynamics

The AppDynamics Database Monitoring product module for Microsoft SQL Server is a comprehensive 24×7 deep-dive tool used to monitor versions 2000, 2005, 2008, 2012 and 2014 of SQL Server instances…

Read more »

Understanding SQL Comparison tool and Operators

Contrasting different operands or factors in view of various conditions is the essential thing which is done in each program we make for deciding uniformity or imbalance between two operands,So…

Read more »

All you needed to think about SQL Comparison tools

Designers and DBAs regularly think about and synchronize structures of their database objects (Tables, Views, Triggers, Functions, Events and Stored Procedures) from Development server to Production server and the other…

Read more »

How to compare two SQL scripts or objects and export comparison results

  sql comparison tool is an instrument that can think about various sort of records, SQL items and envelopes. When run, the New undertaking window will be appeared and the…

Read more »

SpiceWorks SQL Server Monitoring Tool

Spiceworks lets you stay on top of performance so that you’ll detect issues before your users do… all for free! With Spiceworks SQL Server Monitoring, you can monitor SQL Server…

Read more »

Difference between INSERT INTO and SELECT INTO

INSERT INTO and SELECT INTO are different because they do different things. Three main differences are: INSERT INTO is used when the table exists. SELECT INTO works when table does…

Read more »

Setting default value for an existing column

This can be done using ALERT TABLE command. Here is the easiest way to do it. ALTER TABLE my-table ADD DEFAULT(‘my-default-value’) FOR my-column  

Read more »

Difference between varchar and nvarchar data types?

There is a major difference between these two data types. An nvarchar column can store any Unicode data but a varchar column is restricted to an 8-bit codepage. Some people…

Read more »