Filip Holub
- Feb 19, 2017
- 1 min
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
1200
Filip Holub
- Feb 16, 2017
- 1 min
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...
1720
Filip Holub
- Feb 14, 2017
- 1 min
List All permissions in the database!
This query will show you all permissions for whole database!
870
Filip Holub
- Feb 12, 2017
- 1 min
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
3,9300
Filip Holub
- Feb 9, 2017
- 1 min
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
890
Filip Holub
- Feb 7, 2017
- 1 min
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 "
450