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
1120
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...
1640
Filip Holub
- Feb 14, 2017
- 1 min
List All permissions in the database!
This query will show you all permissions for whole database!
790
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,8380
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
810
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 "
400
Filip Holub
- Feb 6, 2017
- 1 min
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
590
Filip Holub
- Feb 3, 2017
- 1 min
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
360
