Standard Members

DB2 Pro Members Standard Members

DB2 Buffer Pool Essentials (Part 2)

DB2 Buffer Pool Essentials (Part 2) By Craig S. Mullins Buffer Pool Page Stealing Algorithm Although most DB2 buffer pools are set up as discussed in the previous section, you can modify the page-stealing algorithm used by DB2 virtual buffer pools using the PGSTEAL parameter. When DB2 removes a page from the buffer pool to make room for a newer...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

What Does Mentoring Mean to You?

What Does Mentoring Mean to You? Professional development series This is Laura Lee Rose, instructor for the GoTo Academy: Tools for the GoTo Guy and Gal. I am a business and life coach that specializes in professional development, time management, project management and work-life balance strategies. This is a segment from the GoTo Academy Leadership series In the previous SSWUG...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Detecting and Removing Duplicate Indexes

Detecting and Removing Duplicate Indexes Author: Basit A. Farooq Problem Indexes are the solution to many performance problems, but with too many indexes on tables can hurt the performance of your database. This is because SQL Server performs extra work in order keep these indexes up-to-date during insert/update/delete operations against tables where these indexes exist. This means that the SQL...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with CLR in SQL Server 2008 R2

Troubleshooting problems with CLR in SQL Server 2008 R2 If you have problems with Common Language Runtime (CLR) in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 CLR bugs were fixed in SQL Server service packs, you should install the...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

DB2 Buffer Pool Essentials (Part 1)

DB2 Buffer Pool Essentials (Part 1) By Craig S. Mullins If you use DB2 for z/OS as your database management system you know that you need to keep a watchful eye on your memory. DB2 just loves memory. Some might say that the more memory you throw at DB2, the better. But simply adding more and more memory to your...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

What is The Best Way to Create a ‘One Team’ Culture?

What is the best way to create a "One Team" Culture? Professional development series This is Laura Lee Rose, instructor for the GoTo Academy: Tools for the GoTo Guy and Gal. I am a business and life coach that specializes in professional development, time management, project management and work-life balance strategies. This is a segment from the GoTo Academy Leadership...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Introduction to Windows Azure SQL Database (Part 2)

Introduction to Windows Azure SQL Database Services (Part 2) Author: Basit A. Farooq Introduction In my last article "Introduction to Windows Azure SQL Database Services (Part 1)", I’ve provided an overview of Microsoft Windows Azure SQL database, which is a cloud-based relational database platform that is built on SQL Server technologies. We also learned about the steps on how to...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Nob Hill Software Database Compare: A Data Developer’s Dream Tool For Comparison And Migration Of Databases

Nob Hill Software Database Compare: A Data Developer’s Dream Tool For Comparison And Migration Of Databases By: Stephen Wynkoop Introduction Database comparison and migration tools are evolving and now provide leverage and advanced guidance and feedback during the migration and testing process. Moving beyond a traditional copy-style migration tool can save time, money and frustration in managing your data infrastructure....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with joins in SQL Server 2008 R2

Troubleshooting problems with joins in SQL Server 2008 R2 If you have problems with joins in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 join bugs were fixed in SQL Server service packs, you should install the latest SQL Server...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Columnar Databases and SQL Server Columnstore Indexes

Columnar Databases and SQL Server Columnstore Indexes Lately I have been working with Vertica – a column based database from HP and I have to admit that I am amazed by its capabilities and the functionalities it offers, especially when we are talking about relatively big data. The basic difference between SQL Server and Vertica is the way they store...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register