Useful tips for everyday
How to expand an existing report data set? This topic focuses on the expansion of an existing report data set that is produced by using…
How pass data from stored procedure to XML? CREATE STORED PROCEDURE ALTER PROCEDURE [dbo].[InsertXMLData] ( @XMLdata AS XML ) AS. BEGIN. DECLARE @XML NVARCHAR(2000) ,…
How do I move a table from one primary filegroup to another? For this, we need to to do the following: Create a secondary filegroup.…
What is the difference between identifying and non identifying relationships? Identifying relationships exist when the primary key of the parent entity is included in the…
Is there way to optimize Microsoft SQL database? Microsoft SQL database optimization is a constant struggle for any project, and this is something that Apriorit…
How to find which tables are most accessed or frequently used in SQL Server? I am currently in a situation where I need to find…
What are the benefits of partitioning a hard drive? Some benefits of disk partitioning include: Running more than one OS on your system. Separating valuable…
How do you check if data already exists in SQL database? How to check if a record exists in table in Sql Server Using EXISTS…
Which of the following indexing techniques are appropriate for data warehousing? Bitmap indexes are widely used in data warehousing environments. The environments typically have large…
Which is the correct format of the join query? The RIGHT JOIN keyword returns all records from the right table (table2), and the matching records…