In SQL SERVER 2005, all the login (including ‘sa’ ) can be enabled and disabled using ALTER LOGIN...
Fresh Topics for Beginner
SQL Server
Enable, Disable Login, Change name of the ‘SA’
Query to reduce Transaction Log file size to just 1MB
Hello Reader! In this post, we want to discuss about a nice function to reduce transaction log size...
Execute Store Procedure with String Query in MSSQL 2008
In this tutorial post, we want to discuss about how to execute store procedure with string query in...
SQL: Get All the Information of Database using sys.databases
In SQL Database, this view is available in the master database and in user databases. In the master...
Some Important SQL Queries 2018
How can we know how many stored procedures have executed so far and how many times? SELECT...
Using Merge Into in SQL Server
The SQL Server MERGE command is the combination of INSERT, UPDATE and DELETE commands consolidated...
Run same command on all SQL Server databases without cursors
sp_MSforeachdb is extremely useful for pulling together metadata about your various SQL databases...
SQL: Get information on all of the tables
After some searching, I could not find an easy way to get information on all of the tables. There...
Table type Parameters in SQL Server
This is a new feature intorduced in Sql Server 2008. Table-Valued Parameters provides option for...
How To Optimize SQL Queries
In this article, we want to discuss about the efficient way to Optimize SQL Queries in SQL Server...
Interview QA
SQL Server Transaction Log Interview Question
In this article, we will discuss some important SQL Server Transaction Log interview question that...
Android Tutorials
Variables and Data Types in Java
In short Variable is name of reserved area allocated in memory. In other words, it is a name of...
