Remove virus from Pendrive

1) முதலில் பென்டிரைவை உங்கள் கணினியில் சொருகி கொள்ளுங்கள்.

2) Start ==> Run ==> CMD==> Enter கொடுக்கவும்.

3) இப்பொழுது பென்ட்ரைவ் எந்த ட்ரைவில் உள்ளது என பாருங்கள். My Computer செல்வதன் மூலம் கண்டறியலாம்.

4) உதாரணமாக E: டிரைவில் பென்ட்ரைவ் இருக்கிறது எனவைத்து கொள்வோம் அதற்கு நீங்கள் E: என கொடுத்து Enter அழுத்தவும்.

5) attrib -h -s -r /s /d *.*என டைப் செய்யுங்கள் ஒவ்வொருபகுதிக்கும் Space சரியாககொடுக்கவும்.
 

Difference between Cell- level Encryption and Transparent Data Encryption

Difference between Cell- level Encryption and Transparent Data Encryption (TDE)

Cell- level Encryption	Transparent Data Encryption (TDE)
Granular control over which data is encrypted	Encrypts the entire database
User‐aware encryption can control access on a need‐to‐know basis	Encryption is not user‐aware; data is open to all users who have permission to access the database
Requires analysis to find sensitive data	No analysis required because entire database is encrypted
Affect table structure because encrypted data can only be stored in varbinary data type columns.	No change is required in table structure.
Database applications need to be modified to use specific functions to encrypt and decrypt data.	No database application change needed.
Indexes, primary keys, and foreign keys cannot be encrypted.	No impact on indexing, primary keys, or foreign keys
Potential impact on performance because indexes on encrypted columns are not used while searching a value.	Small impact on performance (up to 5%)

SQL Table Partition.

IF EXISTS (

SELECT name

FROM sys.databases

WHERE name = N'TestPartition')

DROP DATABASE TestPartition;

GO

CREATE DATABASE TestPartition

ON PRIMARY

(NAME='TestPartition_Part1', FILENAME= 'D:\Partition test\primary\TestPartitionPrimary.mdf', SIZE=2, MAXSIZE=100, FILEGROWTH=1 ),

FILEGROUP TestPartition_Part2

(NAME = 'TestPartition_Part2', FILENAME = 'D:\Partition test\Secondary\TestPartitionSecondary.ndf', SIZE = 2, MAXSIZE=100, FILEGROWTH=1 );

GO



use TestPartition

go

--DROP TABLE TestTable

GO

DROP PARTITION SCHEME TestPartition_PartitionScheme

GO



DROP PARTITION FUNCTION TestPartition_PartitionRange

GO



CREATE PARTITION FUNCTION TestPartition_PartitionRange (INT)

AS RANGE LEFT FOR

VALUES (10);

GO

CREATE PARTITION SCHEME TestPartition_PartitionScheme

AS PARTITION TestPartition_PartitionRange

TO ([PRIMARY], TestPartition_Part2);

GO







-- drop table TestTable

CREATE TABLE TestTable

(ID INT NOT NULL,

Date DATETIME)

ON TestPartition_PartitionScheme (ID);

GO





CREATE UNIQUE CLUSTERED INDEX IX_TestTable

ON TestTable(ID)

ON TestPartition_PartitionScheme (ID);

GO







--- Step 6 : Insert Data in Partitioned Table

INSERT INTO TestTable (ID, Date) -- Inserted in Partition 1

VALUES (1,GETDATE());

INSERT INTO TestTable (ID, Date) -- Inserted in Partition 2

VALUES (11,GETDATE());

INSERT INTO TestTable (ID, Date) -- Inserted in Partition 2

VALUES (123,GETDATE());

INSERT INTO TestTable (ID, Date) -- Inserted in Partition 2

VALUES (-1,GETDATE());

GO





SELECT *

FROM TestTable;

GO

-- drop table [staging_TestTable_20120704-162405]

SELECT *

FROM [staging_TestTable_20120704-162405];

GO



SELECT *

FROM sys.partitions

WHERE OBJECT_NAME(OBJECT_ID)='TestTable';

GO





select GETUTCDATE ()

-- drop table [TestTableArchive]

CREATE TABLE [TestTableArchive]

(ID INT NOT NULL,

Date DATETIME)

ON TestPartition_PartitionScheme (ID);

GO



CREATE UNIQUE CLUSTERED INDEX IX_TestTable

ON [TestTableArchive](ID)

ON TestPartition_PartitionScheme (ID);

GO







ALTER TABLE [TestTable]

SWITCH PARTITION 1

TO [TestTableArchive] PARTITION 1;

select * from [TestTableArchive]

select * from [TestTable]

Find grant permissions on user roles in sql server

select dp.NAME AS principal_name,

o.NAME AS [object_name],

p.permission_name

from sys.database_permissions p

left OUTER JOIN sys.all_objects o

on p.major_id = o.OBJECT_ID

inner JOIN sys.database_principals dp

on p.grantee_principal_id = dp.principal_id

where dp.NAME not in ('public' ) and o.NAME is not null

and o.NAME not like '%_view'

order by 1,2

MERGE in TSQL

MERGE [dbo].[LOBSupportedPropertyType] A

USING [dbo].[#LOBSupportedPropertyType] B

ON

(

A.[ID] = B.[ID] AND A.[LOBId] = B.[LOBId] AND A.[TypeId] = B.[TypeId]

)

WHEN MATCHED THEN

UPDATE

SET A.[PropertyTypeId] = B.[PropertyTypeId]

,A.[PropertyTypeName] = B.[PropertyTypeName]

,A.[DefaultPropertyValue] = B.[DefaultPropertyValue]

,A.[PropertyTypeDisplayName] = B.[PropertyTypeDisplayName]

,A.[Guid] = B.[Guid]

WHEN NOT MATCHED THEN

INSERT

(

[ID]

,[LOBID]

,[TypeId]

,[PropertyTypeId]

,[PropertyTypeName]

,[DefaultPropertyValue]

,[PropertyTypeDisplayName]

,[Guid]

)

VALUES

(

B.[ID]

,B.[LOBID]

,B.[TypeId]

,B.[PropertyTypeId]

,B.[PropertyTypeName]

,B.[DefaultPropertyValue]

,B.[PropertyTypeDisplayName]

,B.[Guid]

);

BCP using T-sql

exec master..xp_cmdshell 'bcp SupportWarehouse.dbo.AgentDataPointAudit out c:\AgentDataPointAudit.txt -c -t, -T -S AMBIVM'

declare @s nvarchar(2000)

set @s='bcp "select top 10 * from SupportWarehouse.dbo.AgentDataPointAudit" queryout c:\AgentDataPointAudit.txt -c -t, -T -S '+ @@servername

exec master..xp_cmdshell @s

Delete duplicate using "WITH"

WITH DUP_DATA AS


(

SELECT ServiceRequestid , WorkRecordID , COUNT(*) AS CNT

FROM OSWorkrecordfreeformfact WITH (NOLOCK)

GROUP BY ServiceRequestid , WorkRecordID

HAVING COUNT(*) > 1

)

--SELECT OS.ServiceRequestid , OS.WorkRecordID , OS.JobrunID

DELETE OS

FROM DUP_DATA D

INNER JOIN OSWorkrecordfreeformfact OS

ON D.ServiceRequestid = OS.ServiceRequestid AND D.WorkRecordID = OS.WorkRecordID

INNER JOIN OSWorkrecordfreeformfact OS1

ON OS.ServiceRequestid = OS1.ServiceRequestid AND OS.WorkRecordID = OS1.WorkRecordID

AND OS.JOBRUNID < OS1.JOBRUNID

percentile calculation in t-sql

select max(PERCENT_OUTBOUND_CALLS) from (
SELECT top 20 PERCENT PERCENT_OUTBOUND_CALLS FROM scorecard_outlier ORDER BY PERCENT_OUTBOUND_CALLS asc )a

BCP task using command prompt BCP testDB.dbo.TestTable in D:\testsourcefile.txt BCP testDB.dbo.TestTable out D:\testdestfile.txt