|
|
-
IvanFroilan Question Received 9 Months ago through ASK
Hi, I want to insert sql server 2000 data into dbf file
insert into openrowset ( 'Microsoft.Jet.OLEDB.4.0',
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;',
'Select * from [item.DBF]')
select * from itemfact
...
|
-
dave ballantyne Answered 3 Years ago through Quizzes
IMO , the worst problem with scalar UDF's is that it will turn the operation into a nested loop as the engine is unable to optimize the logic within into a hash (or merge) join if deemed appropriate.
When used in a join condition matters can be even ...
|
-
dave ballantyne Answered 3 Years ago through Quizzes
I believe the answer to this lies in the contradiction removal of the optimizer.
Consider these two queries based on the same data
SELECT PeopleID,
Low,
High
FROM dbo.Guesses
WHERE High NOT IN(SELECT Value FROM dbo.Res...
|
-
dave ballantyne Posted 3 Years ago through Blogs
In a previous blog entry (Inconsistent NullIf behaviour), Jeff Moden and Dan Halliday(twitter) both made a very similar observation.
When executing this code
Code Snippet
<ol style="background: #ff......
|
-
dave ballantyne Posted 3 Years ago through Blogs
In a previous blog entry (Inconsistent NullIf behaviour), Jeff Moden and <span class=...
|
-
dave ballantyne Posted 3 Years ago through Blogs
Well , that was an experience. It was my first time arranging anything like that and it seemed to me that everything came together in the end ok. Things didn't quite go according to plan when I was delayed setting up by the filming of a Ja...
|
-
dave ballantyne Posted 3 Years ago through Blogs
Well , that was an experience. It was my first time arranging anything like that and it seemed to me that everything came together in the end ok. Things didn't quite go accordi...
|
-
dave ballantyne Commented 3 Years ago through Blogs
Hi Roby,
Very interesting...
doing a select sum(1) from <table> also causes a count(*) to be executed for the null test.
Very odd , im sure there are reasons , i feel another blog coming on...
...
|
-
dave ballantyne Commented 3 Years ago through Blogs
Hi Roby,
Very interesting...
doing a select sum(1) from <table> also causes a count(*) to be executed for the null test.
Very odd , im sure there are reasons , i feel another blog coming on...
...
|
-
dave ballantyne Commented 3 Years ago through Blogs
Hi Jeff /Johnny,
Johnny is right , but ,IMO ,newid() should give a different value on each execution. Otherwise "Select newid(),newid() " would be the same.
Jeff, If you look at the compute scalar operation in the query plan, this is what it is ...
|