Featured Article(s)
Edit SharePoint Display/New and Edit form look, feel, and functionality
Here is a scenario: you have a SharePoint list (calendar, announcements etc) and your users have requested special changes on out of the box display, new, or edit forms. Whether it`s few extra webparts added, or make another form that will serve a purpose of print friendly version, here is how to do it …
Webcast: End to End Database Development
How to manage the database Application Lifecycle. This session will discuss team-focused database development challenges, and will present tried and true methodologies for dealing with database development issues. This session is a must-attend for any database developer working in a team environment. Presented by: Ted Malone
> Register Now
> Live NOW
Wow. TempDB Lessons Learned – Don’t Miss This Post
Cindy Gross wrote a killer blog post about TempDB. There is so much information here, you’ll be picking and choosing what you need to do first.
Interestingly, the number of files that make up your TempDB under optimal configuration is not determined by file size or even disk configuration. It’s actually much more simple than that.
In the meantime, be thinking carefully about how many of these things in the post pertain to the other databases in your system. You’ll see a few items in the list that deserve attention. Specifically, check out the information about auto-grow options and the impact on performance. Also, the number of files your database should have for best performance.
Sorry for the teases – just go read the blog post. It’s excellent information and things you can apply right away.
A Question…
Have you tested virtualization vs. instances? Yes, I do know they are different approaches and environments, but I have had several people ask of late. What’s the best way, if both with technically "work" for your own installation, for you to bring up SQL Server functionality where you need separation? Have you tested the impact of instances on performance and maintenance? Have you worked with both to see what is easier to administer, report on and troubleshoot? If so, I’d like to hear from you about your experiences. Drop me a quick email here and let me know – are you an "instances" person or a "virtual machine" person?
Featured White Paper(s)
Performance Optimization: Extending the IT Infrastructure
Due to time, money, and resource limitations it is often no longer feasible to rewrite, re-architect, or even replace under-p… (read more)
Featured Script
dba3_DBCC_Ind_IndexDefrag
DBCC IndexDefrag DBCC Ind… (read more)