Your Technical Consultant
Storing and retrieving data as requested by other software applications, either on the same computer or a remote machine, utilizing the client-server model.
In this post, we want to discuss all tables containing columns with the specified names in SQL Server. Before we get started, if you want to know the necessity of Store Procedure, please go through the following article: Why do […]
Continue reading How to Search for a Column Name Across All Tables in SQL Server
If you’re using a GUI tool, such as SSMS to manage your databases, you can easily check the size of your database by clicking your way through the GUI (right-click the database, point to Reports, then Standard Reports, and then […]
Continue reading SQL Server Query to Find All Database Sizes (Data & Log) with Examples
You can add, modify, and delete operations on a set of records in the database using a simple form. The details also need to be shown after adding, updating, and deleting of records in a table. And the data-table should be given to a stored procedure to perform the operations. This feature will work with SQL Server 2008.
Continue reading Send DataTable as parameter through Stored Procedure in MSSQL
Purging Tables in SQL Using TRUNCATE and DELETE command.
Continue reading SQL Interview Question: Difference Between TRUNCATE and DELETE Commands
The difference between Union vs Union all is that Union all will not eliminate duplicate rows, instead, it just pulls all rows from all tables fitting your query specifics and combines them into a table. A UNION statement effectively does […]
Continue reading Union vs Union All – Which is better for performance?
In this tutorial post, we want to discuss how to execute store procedure with string query in Microsoft SQL Server 2008. Dynamic SQL lets you create a query string based on user input. SQL Server allows you to create dynamic […]
Continue reading Execute Store Procedure with String Query in MSSQL 2008
To retrieve data from a database, you need SQL (Structured Programming Language) statements. Performance matters when retrieving this data, which is why faster SQL queries are necessary. Regular SQL queries, when optimized for better and faster performance, save time for […]
Continue reading SQL Queries: Tips and Techniques for Faster Performance
In this blog post, we are going to discuss the top 10 SQL query optimization techniques to get precise data from the database. Structured Query Language (SQL) performance tuning can be an incredibly challenging task, especially when working with large-scale […]
In this article, you will learn how to transfer logins and passwords between different instances of Microsoft SQL Server. Before we get started, if you want to know about enabling/disabling of SA User, please go through the following article: Read More. Suppose […]
Continue reading How To Transfer Logins And Passwords Between Instances Of SQL Server
In this post, we want to discuss about a nice function to Get a month name from number in SQL Server. Before we get started, if you want to know about reduce log file size, please go through the following […]
Continue reading How to Get Month Name from Month Number in SQL Server
