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
1960
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
7,5670
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
820
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
4,9840
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
960
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...
750