RE: Temp Table results
Sounds like you are using an ADO object to open a file. Try reading the result into a DataSet object instead. If you must read using adoObject.Open, you will need to have a permanent table. Guarddata
2003-07-08
DMV
2003-07-07
RE: Header/Detail Stored Procedures
Always better to make one trip instead of two if you can. You can handle it by supporting 'x' sets of detail parameters in your proc, or you can build up a XML doc, send that over as a param, then use OpenXML (SQL2K only) to rip it up and do the insert/update. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-06-30
RE: Server Performance
We had this same problem a while back and did a quick test (transferred a 4gig file) from server a then server b. There was a significant difference and thus eliminated SQL and pointed to a networking/OS issue. Just another trick to put in your troubleshooting bag-o-tricks.
2003-06-25
RE: Do you think education matters?
Hi Dale, quote: How do you measure the employee's/fellow worker's thirst for knowledge and continuous improvement? I find that very hard to quantify sometimes, and other times, I find that there can be gaps in knowledge. as Patrick said, talk to them. Simple as that, is it also the biggest hurdle. In most cases the […]
2003-06-25
RE: group by optimize
quote: but as long as new rows are inserted into tShortTerm sequentially by date then you should add an identity column to tShortTerm and use that instead. Good point! unless he also frequently has to query on a date-range, in which case I'd think you would want the clustered index on the date column, but […]
2003-06-20
RE: How much do you earn?
quote: I'm often in meetings with senior mgmt, and they don't care about SPID's, locks etc. They want business solutions. That's what I do. I have to diagree here!!. When a critical system is down because of locking & blocking etc, there is ALWAYS a post mortem, and possibly a witch hunt follows. The world […]
2003-06-19
1 reads
RE: SQL and XML format
The problem you have there is lack of a root node. Not to serious though. To get exactly what you want, have a look at EXPLICIT. You can do it with that. There is an example in BOL which does that useing Pubs DB. That is what I used and hacked it apart. Another solution […]
2003-06-17
RE: HELP!!
Hello. From BOL (Books Online which can be found under Programs - Microsoft SQL Server)... Updates an existing text, ntext, or image field. Use UPDATETEXT to change only a portion of a text, ntext, or image column in place. Use WRITETEXT to update and replace an entire text, ntext, or image field. Syntax UPDATETEXT { […]
2003-06-16
RE: QOD 6/13
Hi David, quote: If you check out this link http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B196909 it states thet the configure option is on 2000 EM. you mean this passage? NOTE: In SQL Server 2000 Enterprise Manager, the number of error logs that are created before they are recycled is configurable through the context-sensitive popup menu for SQL Server Logs. For […]
2003-06-13
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers