How to Get Owner of Job in SQL Server?
There are two ways how to find out owner of job. First way is open every job and look at owner, if you have 250 jobs it may take a long time
Filip Holub
Feb 19, 20171 min read
124
0
How to take Differential Backup for all user database?
This scritp you can use if you need to take differential backup for all user databases of instance. Script below exclude system...
Filip Holub
Feb 16, 20171 min read
176
0
List All permissions in the database!
This query will show you all permissions for whole database!
Filip Holub
Feb 14, 20171 min read
86
0
How to disable Data Compression on tables in whole database in SQL Server 2008R2?
If you restore database from enterprise edition to Standard edition and you have enabled "Data compression" on table, restoration
Filip Holub
Feb 12, 20171 min read
3,984
0
Data Migration Assistant
Data Migration Assistant (DMA) is tool for detects compatibility issue that can impact database functionality on your new version of SQL. Da
Filip Holub
Feb 9, 20171 min read
87
0
How to identify Index Fragmentation?
If you want to find out fragmentation of index your database you have several options. In my case is the best Dynamic Management View "
Filip Holub
Feb 7, 20171 min read
43
0
DBCC CLONEDATABASE in SQL 2016 SP1
Service Pack 1 in SQL Server 2016 introduces new management command "DBCC CLONEDATABASE". This command will generate a schema and
Filip Holub
Feb 6, 20171 min read
68
0
How to Backup and Restore File Group?
Today, I would like to show you how to backup and restore File Group. For this action I prefer using T-SQL, because for me it's faster a
Filip Holub
Feb 3, 20171 min read
40
0
