How to delete partitioned table data from a table without dropping the table?

Problem: How to delete partitioned table data from a table without dropping the table? Solution:  TRUNCATE TABLE, SQL server 2016 and later In some cases, where you want to clear out the existing data from the table to load the...

Read More

How to create a linked server, what’s it used for?

Problem: How to create a linked server, what’s it used for? Solution:  Create Linked Servers Linked Server creates a connection between two SQL Server Instances which can be helpful to use cross server database queries. A...

Read More

How to create, alter or remove the permission of a user inside a database or on a SQL server instance?

Problem: How to create, alter or remove the permission of a user inside a database or on a SQL server instance? Solution:  ROLE Adds or removes members to or from a database role, or changes the name of a user-defined database...

Read More

How to import data file like (csv or txt or xlsx) into a SQL Server Table?

Problem: How to import data file like (csv or txt or xlsx) into a SQL Server Table? Solution:  BULK INSERT There are sometimes where you want to import a data file into a table, like product prices which comes from the business...

Read More

How to stop SQL Server Query processing after number of rows to be returned?

Problem: How to stop SQL Server Query processing after number of rows to be returned? Solution:  ROWCOUNT In some cases, where infinite searches occur we need to stop the query processing for several reasons. If we must break the...

Read More

What are package configurations and how are they used.?

Problem: What are package configurations and how are they used.? Solution:  Package Configurations: SSIS provides package configurations that you can use to update the values of properties at run time. A configuration is a property/value...

Read More

What are the available predefined roles in SSRS Report Server.?

Problem: What are the available predefined roles in SSRS Report Server.? Solution:  Role Definitions - Predefined Roles After reports are deployed on to report server, reports are given specific role permissions that are available...

Read More

How to load data concurrently into a destination within the data flow task to fast load?

Problem: How to load data concurrently into a destination within the data flow task to fast load? Solution: Balanced Data Distributor Transformation The Balanced Data Distributor (BDD) transformation takes advantage of concurrent processing...

Read More

How to compile a stored procedure without executing the actual procedure to see potential problems.

Problem: How to compile a stored procedure without executing the actual procedure to see potential problems. Solution: NOEXEC When deploying the procedures to a production database where you want to know the compilation errors without executing the procedure. For example there are validation errors which did not come up until the first time of...

Read More