Browse by Tags

Support for SQL Server 2005 SP2 and SQL Server 2008 RTM ends soon!

Its the time again that you should re-visit your database platform to ensure none of the SQL instances fall within SQL Server 2005 Service Pack2 or SQL Server 2008 RTM editions! It is quite common scenario that few of Enterprises may not have gone to upto date service pack on SQL Server 2005 which is...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 01-12-2010
Checking Foreign Keys

A while ago I answered a question in the news groups where someone was having problems doing a data load because of the foreign key constraints on a table. To overcome this you can disable these constraints, but then you have to be wary because it is possible to have loaded data that is orphaned. To...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on 09-19-2009
SQL Server: Monitor and Manage Database Maintenance issues - DBCC, backup and spotlight on tempdb and Transaction log backup performance

The subject line of this post is a common factor that every DBA might have (once in lifetime). Performance Monitoring is a big subject when it comes to practice, many factors include such as what to monitor, how often more from here ...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 09-08-2009
Best practices on setting NOCOUNT

One accepted SQL Server best practice is to SET NOCOUNT ON to avoid unnecessary DONE_IN_PROC messages being sent to the client. Although this may not have a noticeable performance benefit on many systems with few users, it can mount up to significant overhead when you have a higher number of users and...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on 07-11-2009
SQL Server version has a known compatibility issues with Windows 7 RC. This warning is genuine and applies to all SQL Server editions, including all Express editions.

There is no need to guess about the rootcause of the above error message, as it clearly mentions about compatibility issues as a warning.... read more !

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 06-29-2009
SQL Profiler and TEMP directory

In my last article I wrote about moving your temp directory to avoid problems if the system disc became full. If this does happen it could be a DBA running profiler that caused it! Accepted best practices for running SQL Profiler application, says you should run it on a different machine to the server...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on 06-18-2009
Do you change the default temp folder location on your live servers?

Depending on which version of windows you are running the location of the default temp directory may vary e.g. for Vista and Windows 2008 it is Drive_Letter:\Users\AppData\Local\Temp where Drive_Letter is the drive on which you installed Windows i.e. the system disc. So why should you change this? One...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on 06-17-2009
Object housekeeping

After my last blog entry it got me thinking about something I have been meaning to blog about for a while, which is object housekeeping. Some time ago I worked on a system that we upgraded from SQL 6.5 to SQL Server 2000, as part of the upgrade we looked at each database object to see if it was still...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on 06-12-2009
Changing Bound Defaults to Default Constraints

I answered a question on the newsgroups today about how to do this. Books Online says that CREATE DEFAULT, sp_bindefault and sp_unbindefault will be removed in future versions. I can’t think of any reasons why you can’t plan to remove them now as part of your release cycle and eliminate the additional...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on 06-11-2009
Leeds Area SQL Server User Group Meeting 3rd June Slide decks

Thanks to everyone who attended last nights meeting especially Iain Kick from Quest Software who sponsored the meeting, and Chris Testa-O’Neill and Remarc for providing a venue. The evening went very well and the feed back could have not been more positive. The slide deck for Iain Kick’s presentation...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on 06-04-2009

Page 1 of 5 (47 items) 1 2 3 4 5 Next >