Backup Process-Using context menu(or right click on the database we need to restore ) 2. 3 Give name (extension is .bacpac) 4. 5. Execution…
Read MoreAzure SQL is a cloud-based service built along the lines of SQL Server, and so shares many features with on-premises SQL Server Attributes it carry Easy-to-use…
Read MoreSELECT [UserName] = ulogin.[name], [UserType] = CASE princ.[type] WHEN ‘S’ THEN ‘SQL User’ WHEN ‘U’ THEN ‘Windows User’ WHEN ‘G’ THEN ‘Windows Group’ END, [DatabaseUserName] =…
Read MoreViewing the filegroup to which tables belong to SELECT d.[Name] ‘File Group’, OBJECT_NAME(i.[Object_ID]) ‘Table Name’ FROM sys.data_spaces d Join sys.indexes i On(d.data_space_id = i.data_space_id) join sys.tables…
Read MoreGet Backup History for required database SELECT TOP 100 s.database_name, m.physical_device_name, CAST(CAST(s.backup_size / 1000000 AS INT) AS VARCHAR(14)) + ‘ ‘ + ‘MB’ AS bkSize, CAST(DATEDIFF(second,…
Read MoreUSE MASTER; DECLARE @FileName NVARCHAR(1024) SET @FileName = ‘C:\backups\fullTest_’ + REPLACE(REPLACE(CONVERT(VARCHAR(100),GETDATE(),111),’/’,’_’), ‘ ‘,’_’) + ‘.BAK’ SET @FileName = REPLACE(@FileName,’__’,’_’) BACKUP DATABASE test TO DISK = @FileName…
Read MoreCreate table to hold data CREATE TABLE [Department]( [DepartmentID] [int] NOT NULL PRIMARY KEY, [Name] VARCHAR(250) NOT NULL, ) ON [PRIMARY] Insert some values in it…
Read MoreCreate testable to hold some data CREATE TABLE [dbo].[EmpSalary]( [Department] [nchar](10) NULL, [EmpName] [nchar](10) NULL, [Salary] [int] NULL ) ON [PRIMARY] GO Insert some test data…
Read MorePractice Content CREATE TABLE CountryInfo ( RegionId char(10) primary key, RegionName varchar(100), CityName varchar(100), CountryName varchar(100) ) CREATE TABLE SalesInfo ( SL_No INT IDENTITY PRIMARY KEY,…
Read MoreDon’t use “SELECT*” in a SQL query Avoid unnecessary columns in the SELECT list and unnecessary tables in join conditions Do not use the COUNT() aggregate…
Read More