The tag has no wiki summary.

learn more… | top users | synonyms

11
votes
1answer
280 views

How deterministic is execution plan creation in SQL Server?

Given the following constants: The same database with the same structure (tables, indexes, etc) The same data The same SQL Server and hardware configuration The same statistics The same SET options ...
0
votes
0answers
62 views

Figuring out determinants when converting table into 1NF form

I have to figure out the determinants in the region for the following table. St ID L Name F Name Phone No St Lic Lic No Ticket# Date Code Fine 38249 Brown Thomas 111-7804 ...
4
votes
2answers
4k views

MySQL Deterministic Procedures

As a general rule, should I be declaring all my stored procedures with the DETERMINISTIC keyword if they are indeed deterministic? It seems to me that the majority of stored procedures will be ...
5
votes
1answer
172 views

Is my function nondeterministic one

I have two functions: fn_Without_Param and fn_With_Param CREATE FUNCTION [dbo].[fn_Without_Param] ( ) ... INNER JOIN .. ON .. AND SubmitDate = CONVERT( varchar(10), GETUTCDATE(), 101 ) and /* ...