Search Results

I have 1.8TB AX database. File Size : 1851427.75 MB Free Space : 502837.13 MB If free spaces will be used in the future, I don't want to shrink. Because it's taking a long time. (and index fragment …

My default schema dbo. I not give my users permission to create table. User authority ; datareader,datawriter CREATE TABLE dbo.newtable ... CREATE TABLE permission denied in database 'DB' B …

1- Create DB Role [db_support] 2- GRANT ALTER ON SCHEMA::support TO [db_support] DENY ALTER ON SCHEMA::dbo TO [db_support] 3- GRANT CREATE TABLE TO [db_support] 4- CREATE TABLE sup.asd (asd int) …

I guess, you can add IF your own query. Like this: declare @sql varchar(max) IF OBJECT_ID('tempdb..##types') IS NULL BEGIN set @sql = N' select top 10 NameSurName,Mail,Phone INTO ##types …

Probably your editor has a problem or I do not know what exactly the problem is. But I cleared all blank in msforeachdb and run it, so the errors are disappeared. DECLARE @orphan_users TABLE ( Serve …

I am reviewing sys.fn_dump_dblog and I can see the old states of the records, but I can not see which users are doing the operations. SPID, Transaction SID columns are always null, how to fix it, or a …

I will add the records in table A to table B. The tables are the same. However, table B is an actively transactional table. When doing the operation, the record in the tableB will continue to be added …

By reference to @Kin, I have come to the solve with the query. SELECT SUSER_SNAME([Transaction SID]) UserName ,[Current LSN] ,[operation] ,[Context] ,[Transaction ID] ,[Transactio …

I have two nodes and one database. I want to transfer data between them. DML operations on server node-1 should transfer to node-2 and DML operations on node-2 should transfer to node-1 as well. Is t …

Yes, it is possible. You should restore full backup first WITH NORECOVERY option, and after that, you can restore only DIFF backup. Just try without FULL backup; RESTORE DATABASE [MyDb] FROM DISK = …

MSSQL database has previously been archived on another database. Approximately 70m rows (includes sales information.) Now, I am asked to move this archived data to live database. Because, customer ca …

There is a lot of information about the jobs and SQL Server Agent in msdb. You can check it out below, I added a few columns that help you in your thoughts. Maybe you want to check If this job success …

I have my 200 gb database. I want to move EC2 from RDS. I work on a research to prevent the problems that you may see,but it has not been done before. There may be problems; *Security weaknesses, …

With log shipping you can do this. However, during the restore, the connection will be on hold. Query resulting is delay. Unfortunately, log shipping in there is no such solution.

You should update your statistics like below, not just indexes use for the whole table. These might take time. UPDATE STATISTICS tablename WITH FULLSCAN; I think you need a better index. Look at the …