Ars Technica

Weird Sql Server Stored Procedure Timeout Problem

We've got a strange problem here and I'm hoping someone has some kind of idea as to what could be causing it.<BR><BR>We've got a stored procedure in Sql Server 2005. It's not terribly complicated but ...
Ars Technica

SQL Server stored procedure assistance needed... (looping?)

I'm not Mr. Stored Procedure so this is (almost certainly) elementary, but I obviously rode the short bus today and need help figuring this out...<BR><BR>I have a stored procedure that updates counts ...
TechRepublic

Understanding roles in SQL Server security

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...
InfoQ

Agoda Leverages ChatGPT in the CI/CD Process for SQL Stored Procedure Optimization

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. In this episode, Thomas Betts chats with ...
Simon Fraser University

Passing Joins to the DBMS

Although the SQL Procedure Pass-Through Facility has always passed joins to the DBMS, it is now possible to pass joins to the DBMS without using Pass-Through. Beginning in Version 7, the LIBNAME ...
Simon Fraser University

SQL Procedure Pass-Through Facility: Teradata Specifics

You can use the pass-through facility of PROC SQL to build your own Teradata SQL statements and then pass them to the Teradata server for execution. The PROC SQL CONNECT statement defines the ...