Browse by Tags

All Tags » SQL2008 » File Under Grumpy (RSS)
22 March 2011 11:42

Partitions and FullText - not an option

I'm a strong advocate of partitioning having deployed solutions through SQL 2000, 2005 and 2008, in fact federated servers is about the only aspect of partitioning which I've not deployed in a production environment. Recently I've been applying...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,
30 September 2010 22:05

Rowversion vs Timestamp !! what’s the word then microsoft?

I like to promote all things SQL Server whenever I can and when the subject of allocating some time to maintenance of our applications was raised I was quick to suggest we could replace the numerous Timestamp columns with Rowversion so that we future...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,
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: , , ,