SQLServerPedia Syndication

Houston Area SQL Server User Group Monthly Meeting

When: Tuesday, March 9, 2010 – 11:30am-1:00pmWhere: Microsoft Houston Office 2000 W. Sam Houston Pkwy. S. #350 Houston, TX 77042Pizza and drinks provided by IderaLive MeetingConference Call for audio: 888.320.3585 (Passcode 76027128)Topic: Accelerating Database Performance Using Solid State StorageSpeaker: Sumeet Bansal, Principal Solutions Architect at Fusion-io

0 comments More…

Book Review: Microsoft SQL Server 2008 – Implementation and Maintenance – Self Pace Training Kit

A few months ago I reviewed my training plan for 2009 and realized I needed to update my certifications and take the SQL Server 2008 – Implementation and Maintenance Exam 70-432. While I felt I had enough experience and knowledge to take the exam I wanted to ensure I would be comfortable with all of the areas covered by the exam. I turned to my training plan on Microsoft’s Learning site and purchased the recommended book by Mike Hotek (Twitter)

4 comments More…

MS Access ODBC Connetion Timeout Error

There are some of us unfortunate DBAs out there that are forced to support MS Access connections to our database. I am one of those poor souls.

I manage a Microsoft Dynamics NAV database with over 26,000 tables. When one of our users was trying to create a linked table in Access 2007 he was presented with a ODBC–call failed Timeout expired (#0) error.

9 comments More…

MS Project Server and Backup Best Practices

Microsoft’s Project is a very standard project management tool that most Project Managers are all to familiar with. While Project is a great application it was limited to local information. Microsoft’s Project Server extends Project’s capabilities and allows the sharing of resources and information across an Enterprise. Project Server 2007 is built around the SharePoint [...]

1 comment More…

Using Joins instead of Sub Queries: a Case Study

During a recent upgrade from SQL 2000 to SQL 2005 some poorly written code was exposed on a custom web application. Users and developers started reporting that their applications were timing out. One of the queries I posted in the Execution Plan Challenge. Another exposed query involved a sub query.

5 comments More…

Execution Plan Challenge

I have recently upgraded a database from SQL 2000 to SQL 2005. The upgrade was not an in-place upgrade. It was a side by side and we are moving from a physical to a VMware server. The data and log drives are separated out on our our SAN. The TempDB is still on the C:\ drive but that will be changed tonight and moved to a separate disk.

I am having problems with a few queries using. One of the queries that has me stumped is below.

26 comments More…

← Previous Entries

Next Entries →