3
5
The ORDER BY clause in the SELECT statement is redundant.
It is redundant because the rows that will be inserted must be sorted anyway.
Let us create a test case.
CREATE TABLE #Test (
id INTEGER NOT NULL
);
CREATE UNIQUE CLUSTERED INDEX CL_Test_ID ON #Test (id);
CREATE TABLE #Sequence (
...
Working on optimizing some stored procedures, sat down with DBA and went through some sprocs with high blocking and/or high read/write values.
One thing the DBA mentioned was I should declare all variables (especially TABLE ones) at the top of the sproc to avoid recompiles.
This is the first I ...
"Bollocks" is a word of Anglo-Saxon origin, meaning "testicles". The word is often used figuratively in British English, as a noun to mean "nonsense", an expletive following a minor accident or misfortune, or an adjective to mean "poor quality" or "useless". Similarly, the common phrases "Bollocks to this!" or "That's a load of old bollocks" generally indicate contempt for a certain task, subject or opinion. Conversely, the word also figures in idiomatic phrases such as "the dog's bollocks", "top bollock(s)", or more simply "the bollocks" (as opposed to just "bollocks"), which will refer ...
