Yeah, people with a clue. By the way speaking of MS and AV, did you see where they are finally going to start offering an AV product themselves. Personal opinion, the darn thing should be free to keep 90% of the problems they create from bugging (yes PUN time) us.
2003-07-01
1 reads
2003-06-27
If you are stuck with having to use a cursor, then making them read only and static should help. You would have to test it for your situation, but I have had luck in the past with static cursors. Sometimes I have realized performance gains that were as much as 50 times faster. Generally it […]
2003-06-17
1 reads
Your proposed solution will not work, because the DELETED table is only a psuedo table available to the trigger. Your BCP will start using another thread and will not have access to the DELETED table. You could copy the contents of the DELETED table to another permanent table, and then run your BCP against the […]
2003-06-12
1 reads
yes, it's started, I have several sql 2000, most of them working with "isql -S" and "bcp -S", only one that running named instance is not working. I changed registry on this server before, but don't know what's wrong I did. It's not a big deal, I just wonder how sql2000 working with isql and […]
2003-06-11
2003-06-06
Jay, i am using SQL server 7.0 Here's the query and the error results: DELETE FROM WTRDET INNER JOIN ( SELECT Order_NBR ,Line_NBR, MAX(Ship_Date) as MaxShipDate FROM WTRDET GROUP BY Order_NBR ,Line_NBR ) AS dt ON WTRDET.Order_NBR = dt.Order_NBR AND WTRDET.Line_NBR = dt.Line_NBR AND WTRDET.Ship_Date < dt.MaxShipDate Error result: Server: Msg 156, Level 15, State […]
2003-06-05
satish, the AS is technically optional, so you can remove it if you want. Other than that, my colleague and I can't see anything wrong with it. However, to make the query more efficient, I suppose the last line doesn't need to be: AND Orders.Ship_Date <> dt.MaxShipDate. It could be better written: AND Orders.Ship_Date < […]
2003-06-05
Thanks for that, I particularly like the closing statement "...and pray!". It mentions three or four extended stored procs to block. I notice xp_dirtree isn't documented anywhere. Come to think of it there are a hell of a lot of stored procs that simply aren't documented. I am tempted to create a role in the […]
2003-06-05
1 reads
Can you check whether you can access sql server from your IIS server using OSQL/ISQL or ODBCPING.exe utilities with same login ID and password? If you use ODBC DSN to connect SQL Server, enable SQL Trace from ODBC administrator to see any errors. Make sure you use correct authentication method, ie you may have to […]
2003-06-04
1 reads
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
By Steve Jones
The survey is out now and you can share your experiences for a chance...
By Rob Sewell
"We can really be dangerous if we want, without being too afraid of it."
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