Monday , December 11 2017
Home / 2016 / October

Monthly Archives: October 2016

Union vs Union All in Sql Server

Union vs Union All in Sql Server: UNION The UNION command is used to select related information from two tables, much like the JOIN command. However, when using the UNION command all selected columns need to be of the same data type. With UNION, only distinct values are selected. in …

Read More »

View All Databases Information In SqlServer

Sp_helpdb

 View All Databases Information In SqlServer: There are different ways of listing all databases within an instance of SQL Server. 1.Sp_helpdb : Reports information about a specified database or all databases. Example 1: exec Sp_helpdb Output: Example 2: exec Sp_helpdb ‘Construction’ 2. sp_databases  : Reports all databases Names and Sizes Example: EXEC sp_databases  …

Read More »

DBCC SQLPERF (Transact-SQL)

DBCC SQLPERF (Transact-SQL): To increase sql Performance always we need to keep an eye on log File size. DBCC SQLPERF command will get size information about the transaction logs for all databases , so this command will useful in helping to monitor the growth of your transaction logs. Syntax: DBCC SQLPERF( logspace) …

Read More »

How to Increase the SSMS Results Grid Font Size?

How to Increase the SSMS Results Grid Font Size? If we want to increase  font size for query editor we can easily increase  by using ctrl+mousewheel button. and if we want increase result window grid size then we can also easily increase its font size by using below steps 1.This is …

Read More »

Sql Server Data Types

sql_datatypes

Sql Server Data Types: 1.Numeric Datatypes : Data Type Maximum Size Explanation BIT Integer that can be 0, 1, or NULL. TINYINT 0 to 255 SMALLINT -32768 to 32767 INT -2,147,483,648 to 2,147,483,647 BIGINT -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 DECIMAL(m,d) m defaults to 18, if not specified. d defaults to 0, if not …

Read More »

Sql Server Important Queries

sql_queries

Sql Server Important Queries: 1.View All Tables in a Particular Database: [crayon-5a2e82ba8175b818737122/] For example if you want to know all table names which contains Sales [crayon-5a2e82ba81766103964897/] 2.View All Triggers in a Particular Database: [crayon-5a2e82ba8176a268166780/] 3.View Any object definition: [crayon-5a2e82ba8176d091162156/] in the place of Name we can give either table name …

Read More »

How to know when database Restored in sql server

sqldb_restore

How to know when database Restored in sql server: In some situation we want to know from which location and in which time database was restored.at that time we will use below query [crayon-5a2e82ba81c6f418704907/] It will return below output: Thanks for reading this article if you like this article please …

Read More »

How to know object information in sql server

sql module

How to know object information in sql server: Suppose we are working on a supporting project or Application Maintenance and we are new to that application and we don’t have the full knowledge on that database, in that situation some times we need to work on below things we need to …

Read More »
Page 1 of 2
1 2