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

Archives: September 2010

Performance Tuning Analysis Services (SSAS) Webinar Today

Thanks for coming to today's webinar. We had a great turnout and hope to see you again soon. I have posted the powerpoint from the session here! 

 

Thanks everyone! - Adam Read more

0 comments, 160 reads

Posted in Adam Jorgensen on 28 September 2010

Windows Power Plans and CPU Performance

Back in February, 2010, I did some preliminary testing on the effects of various BIOS settings and Windows Power Plans on processor performance in Windows Server 2008 R2 using the cross-platform Geekbench benchmark. That round of testing used an 2.8GHz Intel Core i7 860 processor in an ASUS desktop board.… Read more

0 comments, 1,019 reads

Posted in Glenn Berry's SQL Server Performance on 28 September 2010

Find the largest tables in a database

From time to time, I need to find the largest tables in terms of rows / used space / total space etc. I originally used sp_spaceused, a temp table and a cursor (or sp_MSForEachTable) and put them into a stored procedure to get the information I need.

But now as… Read more

7 comments, 18,158 reads

Posted in DBA Philosophy on 28 September 2010

Open-Source Databases are Not Free, MySQL has a High Cost, According to MySQL.com Itself

 

After having a few heated discussions on Facebook in reference to Open-Source Relational Databases, I would like to refer those who think that MySQL will cost your company nothing to the MySQL Enterprise DBA Savings Calculator page.

All Database servers have to be managed, and there are the costs… Read more

1 comments, 593 reads

Posted in The Database Hive for SQL Server DBAs on 28 September 2010

DBTA: The Trouble with Third-Party Applications

Third-party applications are a very important part of the IT landscape. Many of us have faced the common dilemma of trying to decide whether to build or buy that next important application our organizations need. (By the way, I’m talking about smaller, specialized applications like an inventory management system for… Read more

0 comments, 139 reads

Posted in Kevin E. Kline on 28 September 2010

Knight's Microsoft Business Intelligence 24-Hour Trainer released

Today the much awaited Knight's Microsoft Business Intelligence 24-Hour Trainer book was release.  In this book you will learn about the entire Microsoft BI stack from a bunch of experts that work with me (Brian Knight, myself, Adam Jorgensen, Patrick LeBlanc, and Mike Davis).… Read more

0 comments, 468 reads

Posted in Devin Knight on 28 September 2010

To Be There Or Not To Be There

Are you ready for Seattle?  Have you registered for the PASS Summit?  Hopefully with some good reasons you will be inspired to attend the summit this year.

Ten Reasons to Attend

There are, of course, countless reasons to attend the PASS Summit in November.  To hopefully inspire a few… Read more

1 comments, 227 reads

Posted in StrateSQL on 28 September 2010

Performing a Cross Join (Cartesian Product) in SSIS

There are a few times where you might want to perform a cross join/cartesian join/cartesian product operation in SSIS.  One of those scenarios could be performing some kind of a double-sided "range join" where you can't line up a specific key in your data flow to a specific key in your lookup table.  Quite often…

Read more

0 comments, 1,194 reads

Posted in Todd McDermid's Blog on 28 September 2010

Do You Have Influence? Part 3

I talked about the basics of Influence in Part 1 and Part 2, today I’m trying something harder, showing you how to deliberately use your hard won influence to evoke change. Earning influence is perhaps not simple, but it’s an easy enough formula to understand. The risk is low.… Read more

2 comments, 216 reads

Posted in SQLAndy on 28 September 2010

SQLSaturday #52 Report

I was lucky enough to present two sessions at SQLSaturday #52 in Denver on September 25, 2010. By my estimate, there were probably between 200-250 attendees for the event. The event was well organized, with easy parking, plenty of food, and a smooth registration process. The session rooms were a… Read more

2 comments, 204 reads

Posted in Glenn Berry's SQL Server Performance on 28 September 2010

Lessons from a Great Mentor

On Sunday I learned of the passing of one of my greatest mentors, Major Herbert L. Day, USMC, Retired. He was Director of Bands at The Citadel, the Military College of South Carolina, from 1984-2004. My tenure there started in August 1991 and ended with graduation in May… Read more

3 comments, 254 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 28 September 2010

SQL Saturday#52 – Colorado Recap

This past weekend was the first SQL Saturday in Colorado, and it went very well. I think everyone enjoyed it, the organizers were pleased, and I’m hoping that we end up with 2, or more, events next year.

This was my 5th SQL Saturday of 2010, and it was interesting.…

Read more

3 comments, 908 reads

Posted in The Voice of the DBA on 28 September 2010

Who wants to be a millionaire? - SQLQuiz

 

 

I have a question for all you DBA’s and SQL Professionals out there.  It’s an exciting new contest that is sure to rock the SQL Community, and the prizes are fantastic!

Coming to you from the Ahmedabad Area, India, who wants to be a millionaire?!    Read more

0 comments, 622 reads

Posted in Pearl Knows on 27 September 2010

SQL Server Quiz 2010

SQL Sever MVP Jacob Sebastian (blog/twitter) has been working hard to organize the SQL Server Quiz 2010 event which will be starting on October 1, 2010. This will be a series of 30 Quiz questions, presented each day by a “Quiz Master”, who will be in… Read more

2 comments, 403 reads

Posted in Glenn Berry's SQL Server Performance on 27 September 2010

Project Phoenix For Unemployed and Underemployed Developers

SQL Server MVP Arnie Rowland (blog/twitter) has put a lot of effort into conceiving, organizing, and publicizing Project Phoenix over the past several months. Just in case you have never heard of this effort, the gist of it is to reach out to unemployed/underemployed Developers and… Read more

0 comments, 235 reads

Posted in Glenn Berry's SQL Server Performance on 27 September 2010

Journal: SQL Saturday #52

Friday

6am – up to catch an 8:30 flight. My daughter Lisette is going with me on this trip.

9:30am local time, we arrive in CO. Grab a car and head north to Fort Collins for Beau Jo’s pizza, free loaner bikes from the Bicycle Library, and general sightseeing. BEAUTIFUL… Read more

0 comments, 261 reads

Posted in SQL Awesomesauce on 27 September 2010

Can Deadlocks be Resolved by Adding an Index?

Can Deadlocks be Resolved by Adding an Index? Yes. Really, I’m not kidding. Here, I’ll show you how.

First, let me set the scene: One of the applications I support has had issues with deadlocks for some time now. The deadlocks are really a result of design issues that it… Read more

0 comments, 404 reads

Posted in Adventures in SQL on 27 September 2010

Parameter Name Size And Performance

I saw an odd statement the other day, “The size of the name of the parameter does not affect performance.” My first thought was, “Well, duh!” But then, I had one of those, “Ah, but are you sure” thoughts. And you know what, I wasn’t sure.

If size of the… Read more

0 comments, 299 reads

Posted in The Scary DBA on 27 September 2010

Orlando – Reminder to Register for SQLSaturday #49

We’re less than 30 days out from SQLSaturday #49 and we’re working hard on the logistics. Speaker gifts ordered, lanyards this year instead of stick on badges, Jack working on a deal with our after party location for great appetizers, and all the rest of the stuff that goes into… Read more

0 comments, 194 reads

Posted in SQLAndy on 27 September 2010

Newer posts

Older posts