Thank you for a reply, but it doesn't work. On EM I get the same error as earlier:Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ]. Trying to execute select statement through QA I get the following: Server: Msg 7399, Level 16, State 1, Line 1 […]
2005-05-26
3 reads
What is the difference in performance/response time if I query by;Select * from customer where cust_id='ANNE'or Select * from customer where cust_id like 'ANNE%'or Select * from customer where cust_id='ANNE'Assumption : 500,000 records in table customer : record length=500 : cust_id is not unique
2005-05-25
Comments posted to this topic are about the Question of the Day for 21 Apr 2005 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=490.
2005-04-06
2 reads
Carl,you can also use the -p parameter to give you statistics.If you find anything, let us know.Thanks,JA
2004-11-08
If the contest is still on why does the email address no longer work?Hi. This is the qmail-send program at lance.cordhosting.com.I'm afraid I wasn't able to deliver your message to the following addresses.This is a permanent error; I've given up. Sorry it didn't work out.<contest200401@sqlservercentral.com>:This address no longer accepts mail.
2004-02-13
But Somehow i am again where i was before when i create the function using same statements Example: Create Function fnTest123() Returns varchar(255) As Begin declare @SQL nvarchar(4000) declare @Params nvarchar(4000) declare @name varchar(255) select @SQL = 'Select @nm = name from sysobjects where id = 1' select @Params = '@nm varchar(255) output' EXECUTE sp_executesql […]
2003-12-15
2 reads
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers