Dimant Data Base Solutions Blog - Information, Reviews, and Comments on Blogged

Submit a Blog

SignUp

Blog Directory

Old Home

Blog Detail

Dimant Data Base Solutions

http://dimantdatabasesolutions.blog...

The goal of this blog is to share my knowledge as a DBA/Developer in SQL Server area. Many years ago I started to collect some tips and tricks from many experts of SQL Server around the world as well as the scripts developed by myself. And I really want to share them with you. Also my intend is to help beginners as well as experienced people such I have been doing at Microsoft forums.

Click to Update Blog Details

Dimant Data Base Solutions Blog

Listed in: Technology > Information Technology
Related Topics: data, SQL Server, tables
Author: Click here if Dimant Data Base Solutions is your Blog

Visit this blog on Facebook for more info.

Related Blogs



Don McCubbrey's Blog	Heretic of Kayem	IT Blagger 3.0

Show this rating on your blog!

6.9

good

based on editor's review


	Consistency checking for a 1.2 TB database Nov 8, 2009 I would like to share with you my recent experience on how to build consistency checking for VLDB by using DBCC CHECKDB/CHECKTABLE and etc. I was following Paul's great... Import data from AS400 by using SSIS Oct 18, 2009 That was deviation towards the world of BI. I was helping my co-worker to build a SSIS Package to import the data from AS400 into SQL Server. At first I selected OLE DB Source component for getting the data but started getting odd errors of driver... Does the fragmentation have impact on performance on Heaps? Oct 5, 2009 I have been working on some project that involves using very huge tables. Actually most of tables are heaps and to reduce IO we decided to compress those tables on PAGE level because the database is READ-ONLY. Fortunately in SQL Server 2008 we can...

Comments & Reviews:

Be the First to Review this Blog!

Consistency checking for a 1.2 TB database

Import data from AS400 by using SSIS

Does the fragmentation have impact on performance on Heaps?