Skip to main content
Tag

#linked server

Browse all articles tagged with #linked server. Find expert insights and practical tutorials from our PI System community.

2 articles
PI System
Troubleshooting
+1

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.

#PI OLEDB
#linked server
#PIInterp2
+4

Roshan Soni

PI System
SQL Server
+2

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.

#PI OLEDB
#PI SQL
#ROUND5
+4

Roshan Soni

About #linked server

Explore our collection of articles tagged with #linked server. Our expert contributors share their knowledge and experience to help you succeed with PI System implementations.

From configuration tips to advanced development techniques, these articles provide practical guidance for PI System professionals at all levels.