Question : I have 2 databases that reside on the same server. I am trying to read static data from […]
Category: SQL Server
Create a custom db roles that uses a lookup table
Question : Can you create a custom DB_role like truncate, select, insert, delete permission to tables that are stored in […]
Find ClientHost using ClientIP – SQL Server 2014
Question : Recently we started getting alerts as below : EventID 18456 – Login failed for user ‘abc’. Reason: Could […]
SSIS deployment on databases part of AAG
Question : Experts, I have two databases, one is SSISDB, other is user database. Both of them are a part […]
How to get SQL insert and/or update to not lock entire table on MS SQL Server
Question : Very much a newbie on DB work, so appreciate your patience with a basic question. I’m running SQL […]
Does SQL Server use pointers instead of storing duplicate rows?
Question : I’m using the built in sp_spaceused stored procedure before and after performing a operation in our software to […]
Is it a bad practice to always create a transaction?
Question : Is it a bad practice to always create a transaction? For example, it is a good practice to […]
SQL Server: Query Efficiency Having vs Subquery
Question : I have the following query where I used a sub query since I can’t use aggregates in the […]
How to check actual execution plan of a query after it has been executed
Question : In SQL Server, how can we see actual execution plan of a query, after it has been executed? […]
Create function in central database or repeat in each database?
Question : One of my developers has written a SQL function that works like the VB.Net function (LastIndexOf) and wants […]