SQL Server
Sample description for SQL Server
OSIsoft PI OLEDB: Why Joining SQL Tables to PIInterp2 Can Fail (and How to Fix It)
Running into trouble joining SQL tables to PI OLEDB's PIInterp2 table using linked servers? Learn why query length limits and provider quirks matter, and how sp_executesql can help you query thousands of tags efficiently.
Roshan Soni
Using PI OLEDB's ROUND5 Function With SQL Server Linked Servers: Challenges and Best Practices
Learn how to use OSIsoft PI's ROUND5 function through PI OLEDB with SQL Server linked servers for timestamp rounding, workarounds for common issues, and whether you actually need to round your PI `piinterp` timestamps at all.
Roshan Soni
About SQL Server
Explore our collection of expert articles about SQL Server. Our content is written by experienced PI System professionals and covers everything from basic concepts to advanced implementation techniques.
Whether you're new to PI System or an experienced engineer, you'll find valuable insights, tutorials, and best practices to help you get the most out of your industrial data infrastructure.