"No one is harder on a talented person than the person themselves" - Linda Wilkinson ; "Trust your guts and don't follow the herd" ; "Validate direction not destination" ;

June 30, 2009

Partition Elimination in SQL Server 2005


Partition function and Partition Scheme Step by Step Example

http://blogs.msdn.com/sqlcat/archive/2006/02/17/Partition-Elimination-in-SQL-Server-2005.aspx


Tried the same for Table test1. Deleting data from a Partition
--STEP 1

select $partition.PF1(a) [Partition Number], a, b from test1

--STEP2
--To Delete this data from a Partition in the Table, Create another table and switch the partition
create table test1_truncate (a int, b int)

DECLARE @PartitionNumber INT
SET @PartitionNumber = 1
ALTER TABLE dbo.test1 SWITCH PARTITION @PartitionNumber TO test1_truncate;

TRUNCATE TABLE test1_truncate

--STEP 3
select $partition.PF1(a) [Partition Number], a, b from test1

Partitioning Tips
Handling Large SQL Server Tables with Data Partitioning
Dynamically controlling the number of rows affected by a SQL Server query


Thanks,
Sivaram

Software Testing Interesting Reads - Sara Ford

Very Good Reads from Sara Ford Blog
What are Test Hooks?. With VSTS 2010 You can do a Record and Playback of UI controls
5 Tips for surviving as a Tester - Excellent Article. Key Learnings I would suggest are
  • Develop Deep Domain Expertise, Work with Business and Try to master the domain/Application
  • Learnt from Mistakes - Production Bugs
  • Participate in Design Reviews and question Error Handling/Exception Scenarios
  • Encourge situations to work together and Debug the code together with DEV
Automation Testing versus Manual Testing Guidelines
Target Automation for BVT (Build Verification Test), Regression Test. Access ROI (Return of Investment) on Functional Test Automation. If the feature set changes Release over Release then it may not be a right candidate for Automation.

SQL Server Side Trace explained


As Against using profiler, Server side trace is light weight, runs in the server not at the client end. Details and walk thru provided here http://www.mssqltips.com/tip.asp?tip=1035

Thanks,
Sivaram

Understanding Query Processing and Query Plans in SQL Server

Compiled list of posts for Learning Execution Plan


Happy Learning!!!

SQL Server Coding Guidelines

Compiled List of posts for TSQL Code Review and Best Practices


Happy Reading!!!