Monday , December 11 2017
Home / Murali (page 3)

Murali

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

October, 2016

  • 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_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 …

  • 15 October

    Sql Server Important Queries

    sql_queries

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

  • 14 October

    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-5a2e85154daa3890631657/] 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

    sql_server_table_alter_error

    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 …

  • 9 October

    Google Chrome Keyboard Shortcut Keys

    studyclues_chrome_shortcut

    Google Chrome Keyboard Shortcut Keys: By learning a few simple keyboard shortcuts, we can speed up our Internet Access via Google Chrome Below is a listing of all the major shortcut keys used with the Google Chrome Internet browser. 1.Tab and Window Shortcut Keys: Action Shortcut Open a new window Ctrl …

September, 2016

  • 25 September

    Facebook keyboard shortcut Keys

    studyclues_facebook_shortcut

    Facebook keyboard shortcut Keys: In Today’s Life everyone is active on Facebook,  you can use keyboard shortcuts and make your activity on facebook much easier! Facebook has shortcuts (access keys) for people who only use their keyboards to navigate.Keep in mind that keyboard shortcuts can differ by browser (ex: Firefox, …

  • Page 3 of 8
    1 2 3 4 5 8