SQLShare - Public Profile for Plamen Ratchev

Member for 510 days

Plamen Ratchev (Author)

http://pratchev.blogspot.com

Plamen Ratchev has over two decades experience in the software architecture and development field. He has enjoyed building solutions for UNIX, DOS and Windows platforms, with main focus on SQL Server since version 4.21.

Plamen is founder of Tangra, specializing in relational database applications analysis, implementation, and tuning. His particular interest is in design patterns, performance and optimization.

Plamen has master's degree in computer science with specialization in algorithms and compliers, and holds MCSE, MCSD/.NET, MCDBA, MCSA, MCAD.NET, and MCITP certifications; SQL Server MVP.

Report Card

Questions Attempted:	0
Correct Answers:	0
Current Score:	0.00%

Videos I've made

Title	Published Date
Shredding XML Elements with the Xquery Query Function	11/6/2008
Solve Parameter Sniffing By Using Local Variables	11/6/2008
Solve Parameter Sniffing By Using Optimize for Unknown	11/6/2008
Solve Parameter Sniffing By Using OPTIMIZE FOR	11/6/2008
Solve Parameter Sniffing by Using OPTION RECOMPILE	11/6/2008
Solve Parameter Sniffing by Using A Plan Guide	11/6/2008
Solve Parameter Sniffing by using RECOMPILE	11/6/2008
Sparse Columns in SQL Server 2008	11/6/2008
Preventing SQL Injection With String Filtering	11/6/2008
Table Valued Parameters in SQL Server 2008	11/6/2008
Unpivot Data with a Cross Join in SQL Server	11/6/2008
Unpivot Data Using the UNPIVOT Function in SQL Server	11/6/2008
Performing Updates with Common Table Expressions (CTE)	11/6/2008
Manipulating Hierarchies with HIERARCHYID	11/6/2008
Shredding XML Elements with the Xquery Value Function	11/4/2008
Basic MERGE statements in SQL Server 2008	11/3/2008
Using Column Sets with Sparse column in SQL Server 2008	11/3/2008
Composable DML in SQL Server 2008	11/3/2008
Compound Assignments in SQL Server 2008	11/3/2008
Creating Hierarcies with HierarchyId in SQL Server 2008	11/3/2008
Filtered Indexes in SQL Server 2008	11/3/2008
Filtering XML Elements using the Exist Method	11/3/2008
The MERGE statement in SQL Server 2008	11/3/2008
Handling Division by Zero with NULLIF	11/3/2008
Using Indexes on Tables Variables in SQL Server	11/3/2008
Inline Variable Initialization in SQL Server 2008	11/3/2008
PIVOT using the CASE statement	11/3/2008
PIVOT using the PIVOT statement	11/3/2008
Row Concatenation Using FOR XML PATH	11/3/2008
Row Value Constructors in SQL Server 2008	11/3/2008
Shredding XML Attributes with the Xquery Value function	11/3/2008
Sparse Columns and Column Sets in SQL Server 2008	10/30/2008

Videos I've watched

Title	When Watched
Using a CTE to Update With An Aggregate Expression	11/5/2009
Manipulating Hierarchies with HIERARCHYID	9/18/2009
Creating Hierarcies with HierarchyId in SQL Server 2008	9/18/2009
Filtering XML Elements using the Exist Method	8/4/2009
PIVOT using the PIVOT statement	4/8/2009
Unpivot Data with a Cross Join in SQL Server	4/3/2009
Modifying SQL Server Settings with SMO	2/27/2009
The MERGE statement in SQL Server 2008	2/20/2009
Basic MERGE statements in SQL Server 2008	2/20/2009
Preventing SQL Injection With String Filtering	1/20/2009
Performing Updates with Common Table Expressions (CTE)	1/7/2009
Table Valued Parameters in SQL Server 2008	12/18/2008
Row Value Constructors in SQL Server 2008	12/15/2008
Shredding XML Elements with the Xquery Query Function	11/14/2008
Using FOR XML with SQL Server	10/24/2008
Clustering SQL Server 2005	10/20/2008
SQL Server 2005 / 2008 XML Data Type	10/17/2008

My Playlists