Question : I have secured a database within SQL Server Instance on my local machine using Netlib Encryptionizer. I can […]
Tag: sql-server-2008-r2
Refactoring subquery to JOIN and CROSS APPLY, get only one row for each record in parent table
Question : Given the following query: SELECT p.ProductName, CASE WHEN EXISTS(SELECT 1 FROM Product WHERE ProductSuperID = p.ProductSuperID AND HasImage […]
SQL Server 2005 Cluster Service pack 4 upgrade failure at remote user account
Question : I built SQL Server 2005 ENT Cluster on Windows Server 2008 R2. I need to upgrade it to […]
How to rollback after wrong update statement in sql server 2008R2? [duplicate]
Question : This question already has answers here: How do I get back some deleted records? (3 answers) Closed 7 […]
Identify NON-ANSI joins in SQL Server 2008 R2 on a Database that’s in 2000 (80) compatibility mode
Question : We have a very old database running on SQL Server 2008 R2. The database is running in 2000 […]
Active Directory group as a schema in SQL Server
Question : In SQL Server 2008 R2 we have a database that is being maintained by a team of developers. […]
Calculated Column Or Trigger
Question : We currently have an oninsert() trigger set-up that everytime a row is insert into a table an update […]
Behavior of data in indexes based on fill factor
Question : Let’s say you have a database where the default fill factor is 20. Whenever data is inserted, does […]
SQL Server: performance of IDENTITY vs INT as primary key
Question : The most important table of my database is about 300,000 records, and growing. More than 20 tables have […]
Is it important to release memory back to the server?
Question : I have a SQL Server 2008 R2 instance running on a production system. I’m not a DBA; I’m […]