Browse by Tags

Reset cached plan - how to and what to?

Published 14 May 7 3:53 AM | SqlServer-QA.net (SSQA)

I don't believe you would need to reset the cache on a production server, it is not a best practice to perform in this case. Most of the times in development or test environments for the purpose of benchmarking you would need to reset the cache for...

Filed under: sql server, package, indexes, memory, integration, perfmance, plan, cache

Taking advantages of Cryptographic features in SQL 2005 - security

Published 12 May 7 5:16 AM | SqlServer-QA.net (SSQA)

When I had a chance to know about encryption features in SQL Server I always go with books online as a first hand information, but there is more to ask about this feature in 2005 version: Have you ever thought about encryption in SQL Server, how to implement...

Filed under: sql server, integration, ssis, security, ssas, cache, entry