Featured Article(s)
How to set Compatibility Mode for a Database Using T-SQL
I participated in a database server migration from SQL Server 2000 to SQL Server 2005 and noticed some query performance issues that came up during testing. When a database is upgraded from SQL 2000 to SQL Server 2005 using backuprestore or sp_attach, the database retains its current compatibility level. Read on as I explain how to set compatibility mode for a single database using T-SQL and how this may affect query performance.
Only One Day Left to Register
SSWUG.ORG Virtual Conference – More than 100 sessions, 40 speakers, 3 days… AMAZING content. This is NOT your typical webcast, trust me. Top industry presenters, authors, MVPs and experts, downloadable transcripts of sessions, download the scripts from the demonstrations, see the presenter as they’re talking and showing off the technologies. There is still time to register, but it all kicks off Wednesday, so be sure to register today – only $100 for access to SQL Server, Business Intelligence, .NET Development or SharePoint sections. Add other sections for even less. You can even chat with speakers and other attendees, re-watch sessions on-demand after the initial air time and a lot more.
We have outstanding exhibitors, from our Title Sponsor, Idera, to our other partners – AvePoint, AppDev, Maximum ASP, SQL Sentry, SQL on Call, Solid Quality Mentors, SharePoint Solutions… Great technologies, be sure to check out the exhibit hall for demonstrations and downloadable materials.
Register here – and we’ll see you online at the conference, starting Wednesday AM.
Featured White Paper(s)
Improving Data Protection and Storage Reliability for Critical Databases
Discover how a healthcare management company met the challenge of improving data protection and storage reliability for criti… (read more)
SQL Server Fragmentation Explained
As the data in Microsoft SQL Server tables changes, their indexes change. Over time, these indexes become fragmented. This fr… (read more)