Browse by Tags

All Tags » SQL2008 (RSS)
22 February 2010 11:47

Don't always believe your system procs - they may lie !

It's sometimes interesting how a simple thing can catch you out! I have a set of routines which handle the process of restoring copies of databases on other servers, it also supports full blown log shipping but has various other functionality. Generally...
Posted by GrumpyOldDBA | with no comments
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: , ,
01 February 2010 14:44

Detach a database and take out a cluster.

During testing I managed to take my SQL 2008 cluster offline by simply detaching a database. See http://msdn.microsoft.com/en-us/library/ms189128.aspx explaining the background. When you detach a database the ntfs file permissions go to the account that...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under: , , ,
28 January 2010 20:38

Index Rebuild Observations

As part of a series of migration tests carrying out an all index rebuild on a user database has been used to compare relative performance. As the application is a true 7 x 24, there are no maintenance windows so index rebuilds are very intrusive and elicit...
Posted by GrumpyOldDBA | with no comments
Filed under: , , ,
03 June 2009 11:44

Build Your Own Cluster

In case you've all missed this you can now build a real cluster with just three machines http://blogs.msdn.com/clustering/archive/2009/05/14/9613924.aspx Windows 2008 Storage Server is now available for msdn and technet download, as the man says now's...
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 | with no comments
Filed under: , , , , , ,
18 March 2009 21:33

x64 Memory Problems

(  I’m hopeful that Livewriter will enable me to publish a blog post which includes screen shots as this one has a large number! ) Please READ everything and the documentation with the download before you install this I’ve blogged about memory issues...
Posted by GrumpyOldDBA | with no comments
Filed under: , , , , ,
16 March 2009 20:38

Reasons to move to SQL 2008 MERGE pt 2

In my previous post with the MERGE statement it was assumed that the pairs of data would be unique and the second set would not already exist. I can’t say that I’d actually put together a really good example and I’m not saying that this is the most brilliant...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
11 March 2009 23:08

Reasons to move to SQL 2008 - MERGE

One of the great things for me currently is that my client is x64 SQL 2008, which means I can use all those features that make SQL Server 2008 such a great product. Anyway I have a very poor example of resolving a batch insert problem – you should realise...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
05 February 2009 20:24

Can I Index a bit ? ( Part 1 )

The final part wil follow and a fully illustrated pdf will be on my website - I'll post the location when it's complete. Can I index a bit? VBUG Presentation 27th January 2009 Bracknell. Here's a brief summary of subject matter and the points...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,
07 January 2009 12:00

SQL Server 2008 Information

I was searching for a particular document for SQL 2008 and thought I'd list the links to what I found, there's some especially good white papers in Technet, I can recommend the T-SQL enhancements and the indexed view white papers especially: SQL...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
15 September 2008 16:17

Indexes, Basically - from SQL Bits

I'll put the entire content including as much as I can remember of what I said, the demo code and results onto my web site over the following week or so. If you'd like the demo databases ( sql 2008 ) there are three, the largest being 60Gb - none...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
11 July 2008 18:46

Filtered Indexes - Really Cool !!!!!!!!!!!!!!!

You may or may not be aware that one of the major new features for SQL 2008 is filtered indexes. Now I'm not quite sure why more hasn't been made of this as it is without doubt a seriously significant new feature. I suppose it depends upon your...
Posted by GrumpyOldDBA | 3 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: , ,