Browse by Tags

• 32 bit
• 64 bit
• 823
• 8966
• analysis
• checkdb
• corrupted
• database
• dbcc
• dell
• disk
• disks
• index
• indexes
• Integration
• IO
• memory
• Microsoft
• notebooks
• page
• performance
• raid
• Random Chatter
• rebuild
• replication
• security
• server
• spindle
• SQL Server
• ssas
• SSMS
• sysindexes
• system
• table
• tempdb
• Testing
• tool
• transactional
• tuning
• windows
• x64

• Dell hints at next gen Precision notebooks

  Quad Core, 16Gb RAM, 1TB RAID, 1Gb Graphics, run dual 30' monitors see the video: http://www.dell.com/content/topics/topic.aspx/global/products/precn/topics/en/precision_concept_jumppage?c=us&l=en&s=gen Share this post: email it! | bookmark it! Read More... Posted Saturday, August 16, 2008 2:45 AM from Paul Nielsen | (Comments Off) Filed under: Hardware, notebooks, dell

• Dust out few tasks to gain transactional replication performance in SQL 2005

  Coming to the basics of Transactional Replication, that starts with a simple snapshot of publication database data. Similar to the name the process is carried upon the fashion of transactions and subsequent data changes and schema modifications made at Read More... Posted Thursday, August 16, 2007 7:20 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, Hardware, Integration, SSMS, ssas, replication, transactional, tuning

• DMVs to provide state of TEMPDB during a performance tuning analysis

  TEMPDB - though the name sounds like temporary database, it most important for any user database! Coming to performance tuning exercise or analysis you would go through Task Manager initially to see how system's memory & processor are coping up. Though Read More... Posted Tuesday, August 14, 2007 11:55 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, Hardware, analysis, rebuild, index, tempdb

• 32bit vs 64 bit what other factors you need to consider?

  Is 64 bit means more memory? Yes, to be precise. Microsoft has been investing heavily on X64 bit and within couple of years there will be no more development on 32-bit applications, as per the recent road map. So within 32-bit application it is one of Read More... Posted Tuesday, August 14, 2007 11:16 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, Hardware, x64, memory, server, windows, 32 bit, system, 64 bit

• Error: Could not find row in sysindexes for database. 8966, 823 and 602

  Long ago, not long ago.... No doubt that many of you might have gone through the error above within your SQL environment, also I see many forum posts out there to resolve the issue. The bottom line of this issue is Hardware and no other issue can contribute Read More... Posted Tuesday, August 14, 2007 7:35 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, Hardware, database, table, corrupted, dbcc, sysindexes, 8966, 823, page, checkdb

• Smaller disks <> more spindles which one is better for performance?

  I have gone through a question within the forums asking "smaller disks or more spindles" which is better for performance. The simple answer is more disks to handle the data growth and also mostly depends upon the number of transactons that are handled Read More... Posted Friday, August 10, 2007 7:53 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, performance, Hardware, disks, spindle

• How to gain Disk related performance with few simple steps

  Within your SQL Server environment there are few simple steps you can take up in order to gain performance to a level, for instance when configuring a SQL Server that will only contain a few gigabytes (GB) of data and not sustain heavy read nor write Read More... Posted Tuesday, July 31, 2007 12:24 AM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, Hardware, Microsoft, Testing, indexes, disk, IO, raid, tool

• First Cellphone Component arrived.

  I have orderd this neat little GPRS/GPS dev kit from SparkFun Electronics . It is essnetially a GPRS/GSM cell phone combo with integrated GPS capabilities. All in a matchbook sized module. Here is more details from the description on the SparkFun website. Read More... Posted Friday, April 20, 2007 3:49 PM from MSDN Blogs | (Comments Off) Filed under: Random Chatter, Hardware