Question : I am writing a stored procedure that takes a database name as an argument and returns a table […]
Category: SQL Server
Group By hour over large dataset
Question : Using MS SQL 2008 I am selecting an averaged field from 2.5 million records. Each record represents one […]
“Force Encryption” vs “Force Protocol Encryption” in SQL Server
Question : I’m trying to understand how the different settings affect the behaviour of my server-client communication. On the server […]
Allow users to only view the databases they have access to
Question : I wonder if there’s any way to allow a user to only view the specific databases they have […]
Delete rows from a large table with joins and aggregating (resulting in 1 % less rows in the big table)
Question : I got a bit stuck on performance, so I thought about asking a bit of help. I have […]
Return values from Left Table Only Once
Question : This is my table structure and a sample query. However, my query returns these results: ID event1 Exists […]
Get the list of all Tables, Views, Stored procedures that are not added in a publication for replication
Question : How do I get the list of all Tables, Views, Stored procedures that are NOT added in a […]
How do I send a database to someone else?
Question : I am working with a more experienced database admin and he wants me to send him a database […]
Logshipping alert emails are being sent out while there is no error
Question : I have logshipping setup with a Primary and a Secondary, and this has been working fine for a […]
Difference between two tables
Question : I am trying to pull the differences between two tables, each in a different database. I thought I […]