Filip Holub
- Dec 14, 2018
- 1 min
Problem after migration from compatibility level 100 to 120.
QUERYTRACEON 9481 - This hint is used with compatibility level 120 and above for forcing cardinality estimator version 70, which means from
1980
Filip Holub
- Jun 2, 2018
- 1 min
How to grant "Execute" permission for User Defined Table Type?
My colleague asked me " How Can I grant Execute rights for my User Defined Table Type"? - There is not execute option as you can s
8,0350
Filip Holub
- May 13, 2018
- 1 min
Daily use in Management Studio - #3 Query to find running queries via T-SQL
I use this script every day for identify all running, runnable and suspended queries on the SQL Server. The script shows you a couple of use
810
Filip Holub
- Apr 4, 2018
- 1 min
Dynamic SQL Merge Script for Generate Merge statement
One day I needed to compare the tables where the source tables were production database and the target tables were for reporting database.Th
5,2790
Filip Holub
- Jun 7, 2017
- 1 min
Poweshell program for Backup databases from PROD to TEST environment in MS SQL2016
Hi guys, We have not seen you for ages!Today, I will write about backuping in powershell. I often have to deals with with development depatm
940
Filip Holub
- Feb 28, 2017
- 1 min
The Generate Script for sp_purge_jobhistory!
I have created a small script for generating sp_purge_jobhistory for my SQL jobs at work. The first part of script generate system store...
730
Filip Holub
- Feb 26, 2017
- 1 min
How to take Transaction Log Backups For All User Databases?
This scritp you can use if you need to take transaction log backup for all user databases of instance. Script below exclude system...
3990
Filip Holub
- Feb 22, 2017
- 1 min
How to Enable or Disable All Jobs in SQL Server?
We display the result of the SELECT. Result looks like this: For change please use system stored procedure sp_update_job. For more details -
3670