Browse by Tags

SQL Server 2008 features - Relational & Data Warehouse Scalability list (new)

Scalability is an important aspect in every application, a common achievement within OLTP environment and still applicable to OLAP (Anlaysis Services) environment. In any if the application or a cube or mining model may be unavailable for querying because of a hardware or software failure, also it could...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 06-12-2008
SQL Server multiple instances and resource utilization - best practices

A newbie or FAQ within Forums and Newsgroups that having multiple instances and how best to set the resources on the server such as memory, CPU etc. Should you configure each of the instances to use specific portions of the available Operating System resources then best to leave the default settings...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 05-15-2008
SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?

You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based RAID. This could be due to one of the reasons such...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 04-28-2008
How to get rowcount efficiently within a SSIS package?

I would like to call this as how efficiently you can obtain counting rows in SSIS package. Usual thought would come is @@rowcount or COUNT_BIG functions, but this is not that efficient way to obtain the results. SSIS provides the snippet within its components such as using Row Count component, for this...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 03-26-2008
SQL Server scrollable server cursors, use them carefully!

One sentence, if you haven't used the Cursors sensibly then database performance will be cursed! This is for newbie users and DBAs to be aware that on general recommendation is server side cursors are better than client side one, in this you need to be careful using the scrollable API server cursor methods...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 03-10-2008
Pre-order the Kalen Delaney SQL Server Internals Course on DVD

Ok 2 months vanished in the year 2008, what have you done so far in terms of learning new concepts and technologies. Great news to all SQL Server users! (for me mostly) The DVD - Kalen Delaney SQL Server Internals course (part1) is almost ready and you can pre-order a copy right now! This is our first...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 03-04-2008
SQL Server 2008 - Declarative Management Framework (DMF) concepts - SQLBits presentation

01st March 2008, Saturday @ Aston Lakeside Conference center, Birmingham - UK. It was a good turnout to my session this morning at 09:30 on the topic : SQL Server 2008 – Declarative Management Framework concepts & database problem solutions with policy management. Declarative Management Framework...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 03-03-2008
SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!

Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation, in this regard review the blogs by SQLQuery...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 02-25-2008
SQL Server 2005 Index Optimization Best Practices

Do you have a maintenance window to perform database reindexing? Have you ever performed full set of re-organize and re-index process on a bigger database? Do you know there are best practices to deploy in this regard? On large database systems, with large numbers of insert and update commands, the problem...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 02-19-2008
Indexing Strategies

I attended the Scottish SQL Server User Group meeting during the week and heard a presentation from Martin Bell on his favourite DMV's. Mentioned in the discussion was sys.dm_db_index_usage_stats and that got me thinking about indexing strategies. I have been involved in performance troubleshooting databases...

Posted to Rob's SQL Blog (Weblog) by robcarrol on 02-16-2008

Page 1 of 2 (11 items) 1 2 Next >