Create Primary Key with Cluster Index

The following example creates a table and defines a primary key on the column TransactionID in the AdventureWorks database. PAD_INDEX PAD_INDEX = { ON | OFF } Specifies index padding. The default is OFF. ON: The percentage of free space that is specified by fillfactor is applied to the intermediate-level pages of the index. OFF or... » read more

Primary Key for Table

All tables with Primary Key All tables missing Primary Key t.type – object type: Table View c.type – type of constraint: Primary key Unique key Foreign key Check constraint Default constraint

Changing Password On Another Domain

Start a Remote Desktop Connection to one of the servers on the domain. When logging into the server, the domain must show that domain. If it doesn’t, select ‘Use a different account’ and enter domain01\username01. Once logged in, press Ctrl-Alt-End and select ‘Change a password.’

TRUNCATE vs DELETE

Use TRUNCATE instead of DELETE If you need to clear the data in a table, use TRUNCATE instead of DELETE. TRUNCATE lock the table instead of at each row. No triggers are activated and no logs are generated resulting in faster performance. Note: TRUNCATE TABLE will reset your identity to the initial seed, whereas DELETE... » read more

SSRS Permissions

Error: The permissions granted to user ‘DOMAIN\user01’ are insufficient for performing this operation. (rsAccessDenied) User permissions need to be setup both at the SQL Server and SSRS. Account can be both SQL Server account or NT account. SQL Server Account has access to database. (Database -> Security) SSRS Reports pointing to correct Data Sources file.... » read more

Sql Not Exist

The following SQL Server Not Exists query will find the Employees whose Occupation is neither Skilled Manual nor Clerical. Note: Using NOT EXISTS may have a performance hit. Try to use LEFT JOIN and WHERE column is NULL to test if there is a performance improvement. Sometimes, NOT EXISTS may be faster, and sometimes it... » read more

Generating Data From Script

SSMS -> Database Name -> Task -> Generate Script Select object -> Next Click on “Advanced” in the “Types of Data to Script” select “Data only” Generated Script