SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Classes
About Us
Login / Register
Subscribe RSS Feed 

Idera Virtual Database


Member for 684 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.
Videos I've made
TitlePublished Date
Shredding XML Elements with the Xquery Query Function11/6/2008
Solve Parameter Sniffing By Using Local Variables11/6/2008
Solve Parameter Sniffing By Using Optimize for Unknown11/6/2008
Solve Parameter Sniffing By Using OPTIMIZE FOR11/6/2008
Solve Parameter Sniffing by Using OPTION RECOMPILE11/6/2008
Solve Parameter Sniffing by Using A Plan Guide11/6/2008
Solve Parameter Sniffing by using RECOMPILE11/6/2008
Sparse Columns in SQL Server 200811/6/2008
Preventing SQL Injection With String Filtering11/6/2008
Table Valued Parameters in SQL Server 200811/6/2008
Unpivot Data with a Cross Join in SQL Server11/6/2008
Unpivot Data Using the UNPIVOT Function in SQL Server11/6/2008
Performing Updates with Common Table Expressions (CTE)11/6/2008
Manipulating Hierarchies with HIERARCHYID11/6/2008
Shredding XML Elements with the Xquery Value Function11/4/2008
Basic MERGE statements in SQL Server 200811/3/2008
Using Column Sets with Sparse column in SQL Server 200811/3/2008
Composable DML in SQL Server 200811/3/2008
Compound Assignments in SQL Server 200811/3/2008
Creating Hierarcies with HierarchyId in SQL Server 200811/3/2008
Filtered Indexes in SQL Server 200811/3/2008
Filtering XML Elements using the Exist Method11/3/2008
The MERGE statement in SQL Server 200811/3/2008
Handling Division by Zero with NULLIF11/3/2008
Using Indexes on Tables Variables in SQL Server11/3/2008
Inline Variable Initialization in SQL Server 200811/3/2008
PIVOT using the CASE statement11/3/2008
PIVOT using the PIVOT statement11/3/2008
Row Concatenation Using FOR XML PATH11/3/2008
Row Value Constructors in SQL Server 200811/3/2008
Shredding XML Attributes with the Xquery Value function11/3/2008
Sparse Columns and Column Sets in SQL Server 200810/30/2008

 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions