Welcome to MSDN Blogs Sign in | Join | Help

June 2008 - Posts

Wednesday, June 25, 2008 3:01 PM

How It Works: Trace (.TRC) File Security

SQL Server 2000 shipped with different trace file security than later builds of SQL Server 2000, SQL Server 2005 and SQL Server 2008. The SQL Server process (sqlservr.exe) writes the trace files to the specified destination.   The SQL Server
Posted by psssql | 3 Comments
Wednesday, June 18, 2008 9:32 PM

How It Works: More on DBCC Shrink* Activities

My peers are starting to tease me about becoming a dbcc shrink* expert. (Ha, Ha I said.)  Then, I uncovered another design facet about shrinkfile helping with a SQL Server 2000 case.  The situation:     dbcc shrinkfile, with EMPTYFILE,
Posted by psssql | 1 Comments
Filed under: ,
Tuesday, June 17, 2008 5:50 PM

Helpful Hint: Making Review of a Query Plan Easier

I think we all have looked at the output of statistics profile and wished the Estimated Rows and Estimated Executions columns were placed beside the Rows and Executes columns.  Well, they can be. In grid mode you simply drag the columns beside each
Posted by psssql | 1 Comments
Filed under:
Monday, June 16, 2008 5:20 AM

Query Performance issues associated with a large sized security cache

In the past couple of months, SQL Server support team has come across some customers running into performance issues attributed to TokenAndPermUserStore in SQL Server 2005. This blog post attempts to compile all the information we have so far regarding
Posted by psssql | 3 Comments
 
Page view tracker