Browse by Tags

All Tags » Best Practices (RSS)
Common sense, courtesy and giving a damn?
17 February 11 11:16 PM | MartinBell | with no comments
It's not only the candidate that should prepare for an interview, here I look at why?...
Filed under:
How to choose a DBA or any other IT practitioner for that matter!
22 November 10 10:45 PM | MartinBell | 1 comment(s)
Few SQL Server professionals are accredited examiners/interviewers, but hopefully this some of this will help! If you are having problems finding a suitable DBA then may be you should look at what you are doing....
Filed under:
Checking Foreign Keys
19 September 09 08:38 PM | MartinBell | 2 comment(s)
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. ...
Filed under: , ,
Best practices on setting NOCOUNT
11 July 09 04:15 PM | MartinBell | with no comments
Setting NOCOUNT ON in stored procedures can have performance benefits, but that is not the only reason to SET NOCOUNT....
Filed under: ,
SQL Profiler and TEMP directory
18 June 09 07:00 PM | MartinBell | 1 comment(s)
When you spot the Windows Administrators scurrying about in a mild panic, just make sure you are not running SQL Profiler!!...
Filed under: ,
Do you change the default temp folder location on your live servers?
17 June 09 07:00 PM | MartinBell | 3 comment(s)
You may think that the controls in place on your production system(s) means your system disc will never get filled... but then when does everyone always stick to the plan or even know it? ...
Filed under:
Object housekeeping
12 June 09 12:50 PM | MartinBell | 2 comment(s)
Like any housekeeping tasks, Object housekeeping is a lot easier if you keep on top of it......
Filed under:
Changing Bound Defaults to Default Constraints
11 June 09 06:50 PM | MartinBell | 4 comment(s)
Something you can do now that could be very helpful in the future......
Filed under: , ,
Leeds Area SQL Server User Group Meeting 3rd June Slide decks
04 June 09 09:13 AM | MartinBell | with no comments
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...
Filed under: , , ,
Re-inventing the wheel!
03 June 09 09:30 AM | MartinBell | with no comments
A very interesting blog entry from MVP Aaron Bertrand was posted the other day......
Filed under: ,

This Blog

SQL Blogs

Syndication