One can enable caching for their reports in SSRS. When we do that, the data is then retrieved from the ReportServerTempDB instead of real time execution of the query. But there are things that you need to be aware of before you start caching the reports. The caches can only be expired based on e

(Kalen Delaney) In my earlier post about the maximum number of row-overflow columns, I just got a comment from someone wanting to know WHY they couldn’t get the number I reported… that is, 308 long varchar columns, of which 307 will be stored off page in row-overflow pages and one will be stored on

(Michael Coles) A common question on the newsgroups is "how do you encrypt data in a .NET [or other] client application and then decrypt it on SQL Server [or vice versa]?" I actually ran down my list of answers to someone who asked this in the newsgroups a few weeks ago. I won’t get into the details

(Chris Skorlinski) This is a continuation of “Repl Talk” series on troubleshooting Transactional Replication. This posting walk through initial setup of Replication then PUSH of Snapshot to the Subscriber. The walkthrough can be done on a single Microsoft SQL Server 2008.

(K. Brian Kelley) I understand that starting with SQL Server 2005, SQL Server could enforce password complexity and password expiration. But I don’t understand how that works or what the parameters are for either. I want to be able to explain to an auditor what my SQL Server is enforcing. How do I f

(Jonathan Kehayias) I am not sure where the “myth” that restoring a database removes the index fragmentation, or that restoring a database causes a database to become fragmented came from recently, but twice in the last few days I have seen questions asked about the impact of restoring a database ha

(Ray Barley) We have SQL Server Reporting Services (SSRS) 2005 running on a single server that supports a large user base. There are specific times during the month where the response time is not acceptable. Based on performance data that we have gathered we have been able to pinpoint the times wh

(Gregory A. Larsen) It always seems like the creation of indexes on a database are always the last thing developers and database designers think about when designing a database. Indexes are almost an afterthought. Developers seem to only place indexes on tables after they notice one of their queries

(Chris Skorlinski) This new “Repl Talk” series of posting will cover troubleshooting Microsoft SQL Server Transactional Replication. I’ll cover everything from setting up Tran Repl through troubleshooting common problems.

(bml3i) Today, I encountered a tricky problem about performance.