Browse by Tags

All Tags » SQL2008 » Diagnostics (RSS)
21 November 2011 20:12

Hello it’s your server calling

This is nothing exciting but I've always found this startup procedure  very useful. All this simple procedure does is send you an email if the SQL Service Starts. If your Server is a cluster it will tell you which node you're on. -- On it's...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
28 July 2010 13:28

An interesting annecdote

A while ago I blogged about using the dmvs to identify lookups and scans on tables http://sqlblogcasts.com/blogs/grumpyolddba/archive/2010/05/19/analysing-indexes-reducing-scans.aspx Well continuing on from this I had discovered that two of the top scanning...
Posted by GrumpyOldDBA | with no comments
Filed under: , , ,
23 March 2010 19:33

Cursors 1 Sets 0

I had an interesting experience with a database I essentially know nothing about. On the server is a database which stores session state, Microsoft provide the code/database with their dot net, so I'm told. Anyway this database has sat happily on...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under: , , ,
10 February 2010 12:09

Print vs Select - security through obscurity ?

Now here's an interesting snippet which I'm sure will provoke a few " ... and you didn't know that! " comments. I wanted to take the output from a stored procedure into a table using the insert into mytable exec proc; command but...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
19 March 2009 20:39

How to determine that hardware DEP is available and configured on your computer

Well here we are again with another post I’d been saving up until I resolved the images issue. DEP and how it affects memory on your SQL Server!!! Microsoft KB: 912923    MICROSOFT KB: 875352 ===========================================...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , , , , , ,
23 June 2008 09:19

Performance Dashboard for SQL 2008

Just in case you haven't seen this http://sqlblogcasts.com/blogs/thepremiers/archive/2008/06/20/sql-server-2008-performance-studio.aspx then have a read. As I actually create dashboards and performance reporting for sql 2000 and sql 2008, and have...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,