Thursday , April 18 2019
Home / Murali (page 3)


Hello everyone I am Software Developer having 3+ years of Experience in Microsoft Technologies and Others. My skills :-, C#,, SQL SERVER, web services, windows Service,Windows applications,HTML,CSS, JavaScript,JQuery,AnjularJs

October, 2016

  • 31 October

    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 …

  • 29 October

    View All Databases Information In SqlServer


     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  …

  • 29 October

    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) …

  • 26 October

    Vertical Select Mode feature in SQL Server Management Studio

    Vertical Select Mode feature in SQL Server Management Studio: Vertical Select Mode trick itself is very simple—but very powerful (one of those things that can save you a lot of time (over time) if you know it well)—and rests solely in the ability to be able to select and change text …

  • 23 October

    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 …

  • 22 October

    Sql Server Data Types


    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 …

  • 15 October

    Sql Server Important Queries


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

  • 14 October

    How to know when database Restored in sql server


    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 that time we will use below query [crayon-5cb8970836ead906602926/] It will return below output: Thanks for reading this article if you like this article please …

  • 12 October

    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 …

  • 9 October

    How to alter table in DesignMode in SQL Server


    How to alter table in DesignMode in SQL Server: Suppose we already created a table in sql server now we want to alter table like add additional column in table or we need to remove existing column from table. If we perform above tasks from query window then we can …

  • Page 3 of 8
    1 2 3 4 5 8