Question : I’m trying to find a better solution when publishing data to a remote table. So we have Server […]
Tag: sql-server-2008-r2
Does SQL check each And condition if first condition fails? [duplicate]
Question : This question already has answers here: Logical operators OR AND in condition and order of conditions in WHERE […]
SQL Server: How to add a full join to two tables but have matches line up?
Question : I am working with a system that has two databases. One for the ERP system and one for […]
Why is there still a varchar data type?
Question : Many of my databases have fields defined as varchars. This hasn’t been much of problem since I live […]
limit the number of rows returned when a condition is met?
Question : Is it possible to limit the number of rows returned when a condition is met? I am working […]
Creating an index on a really busy table
Question : We have a table with a lot of insertselect every time ( like 100 machines insertingupdating every second). […]
Hidden user rights
Question : I’m running SQL Server 2008 R2 SP2. I have a SQL Server user, that the application uses to […]
Creating Linked Server – Impersonation of Windows Authentication
Question : I am trying to set up a linked server on Server A to Server B using windows authentication. […]
How do you GRANT SELECT on hidden resource database mssqlsystemresource?
Question : I get an error when I run this query: SELECT dependencies.referencing_id as object_id, dependencies.referencing_minor_id as column_id, dependencies.referenced_id AS […]
Cross database reference select access with disabled login for DB user
Question : We have two databases (DB1, DB2) with the following view structure. DB1: T1, T2, T3, ….. Tn (Tables) […]