Anything with similar power will probably have similar liabilities. I'd recommend against Query Analyzer, for some reason users find it pretty daunting. When you say edit, is it just find a single row and edit, or they apply update queries? If the requirements are simple enough, you could throw together a small custom app that […]
2003-07-23
1 reads
I am not at all using any kinda of Transactions. Cursors are important for me as I need to fetch rows, calculate the output and update them. It would not be possible to send you the codes at this hour as the codes are at my office server. quote: I hat eto say it, but […]
2003-07-23
1 reads
Problem solved after reading ghicks1's post re:MS Knowledge Base Article 814113. Downloaded/installed the fix and now it works.
2003-07-21
2 reads
Actually, sounds like you need an OLAP solution since the data is for reporting only and will be read-only after the initial load. Check out MS OLAP services or the forum on this site for Analysis Services. -- If you don't want to go that route, I'd post the schema and a little clearer explanation […]
2003-07-21
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-21
Hi Jigsam, quote: So it is possible its just hard to do and time consuming? An SQL insert statement couldnt just chuck it where i want it? so you want to maintain some kind of identity. It is possible to do the job on your own or let SQL Server manage this. Some days ago […]
2003-07-21
Create a temp table with same columns as your original table and additional identity column. Use insert into #temptable select column1, column2 ... from originaltable and query the temp table.
2003-07-18
1 reads
quote: RESTORE LOG test_1c FROM disk='D:\ONEC\ONEC.TLF' WITH RECOVERY -- restore failed: The problem comes from last restore log statement. You have to add "FILE = file_number" option to indicate which backup set from 'D:\ONEC\ONEC.TLF' to be restored. You can use RESTORE HEADERONLY to find out. In your case, it should be 5. The complete restore […]
2003-07-18
1 reads
Agree with NPeeters , sounds like an identity column will do the job.
2003-07-17
Procrastinators - here is your justification for postponing installation of W2K SP4: http://www.w2knews.com/anecdotes.htm. Note that 2 post SP SQL Server problems are mentioned along with a successful multi-server upgrade. I guess I should never entertain the thought of installing a MS SP unless it ends in a letter. Regards, Sandman
2003-07-16
2 reads
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...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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