Author: SQL Server Pro

mssql

STUFF Function in SQL Server

STUFF function is used to replace a string with another string within a text. This function can be very helpful in some situation. Here you can see the syntax of this function along with...

How to check if a table exists in SQL Server database

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 selected mssql database.

...

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 size, connection, speed &...