Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: January 2010

Professional Association of SQL Server (PASS)

I recently discovered the Professional Association of SQL Server (PASS) virtual chapters. For those of you who struggle to make chapter and user group meetings (like me) this can be an excellent way of getting some excellent SQL Server training. I only came across the virtual chapters recently.…

Read more

0 comments, 637 reads

Posted in The SQL DBA in the UK on 31 January 2010

SEO my SQL Server Blog


I was going to spend today finishing off some SQL Server related blog posts, I currently have a list of four or five titles saved as draft that I am keen to publish including “special data file pages”, “Restoring master DB”, “Locks” but instead I have spent the day looking…

Read more

0 comments, 614 reads

Posted in The SQL DBA in the UK on 30 January 2010

Wildcards in WHERE Clauses

This is just a very short post regarding the use of wildcards in a WHERE Clause

It is possible that the first WHERE clause below can use an Index seek

Where LastName like ‘[a-z]%ent’ can use an index

This second statement will not be able to use a seek…

Read more

0 comments, 223 reads

Posted in The SQL DBA in the UK on 27 January 2010

XML Index - ALTER INDEX with REBUILD Issue

I run into a small issue at the end last week, a CHECKDB job was reporting corruption on one of my development databases:

Msg 8964, Level 16, State 1, Line 1

Table error: Object ID 965578478, index ID 1, partition ID 72057594042515456, alloc unit ID 72057594052083712 (type LOB data). The…

Read more

0 comments, 292 reads

Posted in The SQL DBA in the UK on 24 January 2010

Instant File Initialisation

I have been reading up on instant file initialization and I have read a couple of good blog posts by Kimberly Tripp(http://www.sqlskills.com/blogs/kimberly/post/Instant-Initialization-What-Why-and-How.aspx ), Paul Randal (http://www.sqlskills.com/BLOGS/PAUL/post/Misconceptions-around-instant-file-initialization.aspx) and Cindy Gross. From SQL Server 2005 onwards if you grant the SQL Service Account “Perform volume Maintenance tasks” then with…

Read more

0 comments, 635 reads

Posted in The SQL DBA in the UK on 21 January 2010

SQL Server Resource Governor

I didn’t know this bit Resource Governor in SQL Server 2008 is only available in Enterprise edition

 

Read more

0 comments, 478 reads

Posted in The SQL DBA in the UK on 20 January 2010

DDL Triggers

We had a request from a developer who wanted to access data from a source database and another database on the same server. We needed to ensure that the underlying tables are not changed in a way that would impact on the view in either database

Prior to 2005 I…

Read more

0 comments, 292 reads

Posted in The SQL DBA in the UK on 20 January 2010

SQL Server 2008 R2 - Release May2010

SQL Server 2008 R2 now has a release date...May 2010.

Check out the microsoft site for more details...link to follow

Read more

0 comments, 218 reads

Posted in The SQL DBA in the UK on 20 January 2010

January Roundup

I have just put together the January newsletter for www.gre-sqlserver-solutions.com and scheduled it to run Sunday night/Monday morning. It is a little late this month because of the Christmas holidays hopefully we get back into sending them at the start of month from next month. If you would like sign…

Read more

0 comments, 241 reads

Posted in The SQL DBA in the UK on 16 January 2010

Lock configuration setting and preventing locking contention

The locks configuration option for SQL Server controls the number of locks available in SQL Server. You can view this through Management Studio by right clicking on the Server in object exploer, selecting and selecting the tab. The default is 0 which allows SQL server to allocate and de-allocate locking…

Read more

0 comments, 330 reads

Posted in The SQL DBA in the UK on 11 January 2010

Permon Counters Missing Windows 64 Bit SQL Server 32 Bit

For reasons beyond the scope of this post I have an environment where I have Windows 2003 R2 64 bit running but SQL Server 2005 running on 32 bit.


Having fired up perfmon I could not see the SQL Server 2005 counters which left me in a state of confusion.…

Read more

1 comments, 314 reads

Posted in The SQL DBA in the UK on 11 January 2010