Question : I would like to delete data from a specific partition using the partition ID. I got queries to […]
Tag: sql-server-2012
Execute job every time database changes – execute job on each change-event
Question : I have a transactional-replication running in my database, and I need to execute a service on my website […]
SSIS 2012 metadata not refreshing on re-deploy
Question : I have three systems: DEV, UAT, PROD, all running SQL 2012 Enterprise. I have existing packages that hit […]
How to list the permissions on User-Defined Table Types?
Question : I am using some user-defined table types. They are very useful. you can see information about them by […]
Index issue on upgrade from SQL Server 2000 to 2012
Question : About 6 months ago, we upgraded a large .NET project from SQL server 2000 to 2012. (i know […]
Optimizing complex join predicates [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Why are virtual log files not always allocated in order?
Question : Quarterly I check the VLF on all of my servers through CMS with a query from the tigertoolbox/Fixing-VLFs/ […]
How to grant permissions to allow anything inside a SQL Server schema?
Question : I have a schema called training. I have a new role called training_modify. Here are the desired permissions […]
MS SQL Server Performance Issues After Enabling All CPU’s [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Any possible way to encrypt SQL Server 2012 database or backup?
Question : We don’t have SQL Server 2014 or later versions, so I can’t take advantage of the backup encryption […]