Question : I have a table in A Microsoft SQL 2012 database, called Courses. It was “upconverted” from an originally […]
Category: SQL Server
Mapping a Login to a User
Question : On my production system I login to SQL Server with CPSDOMmconnors. When I execute SELECT CURRENT_USER; it returns […]
Using a join operation with conditionals
Question : I have two tables that I’m working with in my database. I am using SQL Server 2014. One […]
Why would SQL Server stop excluding partitions appropriately?
Question : I have a Fact Table that will run with an appropriate plan during our morning processing. Occasionally, later […]
sp_help with different object types with the same name
Question : I have a table with the same name as a user-defined data type (UDDT), and when I use […]
Powershell invoke sqlcmd
Question : How is it possible to execute a query as a applicationintent=readonly using powershell? I have an cluster alwayson […]
Restore fails in single mode because exclusive access cannot be obtained
Question : We have a script that runs every night, this is the relevant part of the script: —- Restore […]
How to set datetime2 to mandate?
Question : I want to create a SQL Script to clean datetime2 field and set it up to datetime2 begin […]
how cursor implementations are different for each cursor type in sql server
Question : In Oracle, there are only 2 types of cursor i.e. Implicit and Explicit cursor. Which is easy to […]
SQL Server 2016 Cluster – mail works in alerts; sp_send_dbmail dosen’t send in jobs
Question : I upgraded from 2008 R2 to a 2016 cluster [Microsoft SQL Server 2016 (SP1) (KB3182545) – 13.0.4001.0 (X64)]. […]