Useful tips for everyday
How do you stop transactional Replication in SQL Server 2012? Connect to the Publisher or Distributor you want to disable in Microsoft SQL Server Management…
Was deadlocked on lock resources with another process and? Transaction (Process ID) was deadlocked on lock resources with another process and has been chosen as…
What is sector size in SQL Server database? SQL Server supports disk drives that have standard native sector sizes of 512 bytes and 4 KB.…
How do you name a constraint? Some CONSTRAINTS can be used along with the SQL CREATE TABLE statement. The general structure of the SQL CONSTRAINT…
How do I import a flat file into SQL Server? Getting Started Open SQL Server Management Studio. Connect to an instance of the SQL Server…
How to shrink SQL Server transaction log file? The size of the virtual log file is chosen dynamically by the Database Engine when log files…
How do you change the datatype of a primary key column in SQL Server? You can’t change primary key column,unless you drop it.. Any operations…
How do you group a many-to-many relationship? When you have a many-to-many relationship between dimension-type tables, we provide the following guidance: Add each many-to-many related…
What is testing in data compression? Test compression is a technique used to reduce the time and cost of testing integrated circuits. However, as chips…
How do you make a SQL query on a single line? You can format your SQL to one line. Note: Single line comments (start with…