Category Archives: SQL

Window Azure SQL Clustered Index Problem Fix

rx online Windows Azure SQL Database is SQL Server technology delivered as a service on the Windows Azure Platform. The cloud-based SQL Database solutions can provide many benefits, including rapid provisioning, cost-effective scalability, high availability, and reduced management overhead. SQL Database supports the same tooling and development practices used for on-premise SQL Server applications. Therefore, […]

1,235 total views, no views today

Count No of records in all table using T-SQL

rx online In this article we will learn to fetch the numbers of rows in your each table. Some time in situations you are required just the count of the rows in each table, we can go with various approach like  using third party software, count manually 🙁 or write program in our preferred language. […]

1,804 total views, no views today

Category: SQL

First Date and Last Date of Last Month using SQL

rx online In this article we will see how to get the first and last date of past / last month. This is very helpful to generate the previous month reports. 1,068 total views, no views today

1,068 total views, no views today

Category: SQL

Password protected MS SQL bak file

rx online In this article, we will learn to take the backup of MS SQL database with password protected. Password protected files are very secured since unauthorized person will not able to access it. If it is database then it is more important to secured the database backup file with password. 1,413 total views, no views […]

1,413 total views, no views today

Category: SQL

sqlcmd Utility – SQL Server Express

rx online Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the […]

1,205 total views, no views today

Category: SQL

How to debug SQL Store Procedures

rx online In this article, we will learn how to debug the SQL Store Procedures. Debugging is a methodical process of finding and reducing the number of bugs, or defects, in a computer program, thus making it behave as expected. Debugging tends to be harder when various subsystems are tightly coupled, as changes in one […]

1,636 total views, no views today

Category: SQL

Table Value Funcation in MS SQL

rx online Table value function is User-defined functions that return a table data type can be powerful alternatives to views. These functions are referred to as table-valued functions. A table-valued user-defined function can be used where table or view expressions are allowed in Transact-SQL queries. While views are limited to a single SELECT statement, user-defined […]

1,657 total views, no views today

Category: SQL

How to create CMD Exec Job in SQL Agent

rx online This topic describes how to create and define a Microsoft SQL Server Agent job step in SQL Server 2012 that uses an executable program or operating system command by using SQL Server Management Studio, Transact-SQL or SQL Server Management Objects 4,705 total views, no views today

4,705 total views, no views today

Category: SQL

Set Max SQL Memory to increase Server Performance

rx online Use the two server memory options, min server memory and max server memory, to reconfigure the amount of memory (in megabytes) that is managed by the SQL Server Memory Manager for a SQL Server process used by an instance of SQL Server. The default setting for min server memory is 0, and the […]

2,167 total views, no views today

Category: SQL

How to use SQL Profiler in SQL 2008

rx online SQL Server Profiler is a rich interface to create and manage traces and analyze and replay trace results. The events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem. To know more about SQL Profiler please […]

2,739 total views, 1 views today

Category: SQL