Browse by Tags

• /3gb
• authentication
• awe
• cache
• databases
• disable
• dmv
• drop
• execution
• login
• memory
• microsoft
• mixed
• pae
• performance
• plan
• query
• sa
• schema
• server
• sql server
• ssms
• studio
• tuning
• windows

Disable SA account on a live SQL Server2005 instance, any drawbacks?
13 August 07 02:03 AM | SQL Master | 2 Comments   

Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices. On these SQL 2005 instances in particular I was more Read More...

Filed under: sql server, microsoft, security, management, login, windows, mixed, authentication, sa, disable

/3GB /PAE and AWE blurb what is it you hear within your environment?
25 July 07 07:06 AM | SQL Master | 4 Comments   

You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From Read More...

Filed under: performance, sql server, microsoft, security, server, management, memory, windows, pae, awe, /3gb

The database principal owns a schema in the database, and cannot be dropped'
13 July 07 01:10 AM | SQL Master | 0 Comments   

Check this FAQ post for further resolution. Read More...

Filed under: studio, schema, ssms, security, management, databases, drop

What events will cause a flushing of plan in cache?
14 May 07 05:17 AM | SQL Master | 3 Comments   

We already know that using DBCC FREEPROCCACHE will have the affect of flushing all the cache with immediate affect and also DBCC FREESYSTEMCACHE (new in SQL 2005) has similar affect but will flush the plans asynchronously that are marked as unused anymore. Read More...

Filed under: sql server, security, management, plan, cache, memory, perfmance

How to find that a query could benefit from an index?
30 April 07 03:48 AM | SQL Master | 0 Comments   

Performance is most required achievement in a multi-user environment, using SQL Server 2005 this can be achieved with a few statments execution. Firstly you need determine the issues by finding which query or queries are causing issues in achieving performance. Read More...

Filed under: ssms, performance, sql server, security, management, dmv

Estimated rowcount affects the performance - SQL 2005
25 April 07 01:02 PM | SQL Master | 1 Comments   

Using Query Analyzer you can get an estimated execution plan for a query against a database, in that plan the estimated number of rows is incredibly important when Query Analyzer is choosing an execution plan. In the real terms this is something to be Read More...

Filed under: performance, sql server, security, management, query, execution

Database Tuning Advisor - how far it can help?
25 April 07 12:06 PM | SQL Master | 0 Comments   

SQL Server 2000 includes Index Tuning Wizard (launch from Enterprise Manager | Tools | Wizards... | Management) that allows selecting and creating an optimal set of indexes and statistics for a SQL Server 2000 database. This wizard is now being replaced Read More...

Filed under: tuning, sql server, security, management