Seems about 1 out of 5-10 tries let's me type.When I can not type, the Explorer status bar shows 1 out of 1 items remaining.... seems to hang forever.When I can type, status = "Done" pretty quickly.
2004-01-05
1 reads
Sorry - I must have closed the browser before my last response registered. I would do two thing: 1) Start with the table that reduces the result the best. In this case I would guess that is either service or episode. SELECT ep.closure_date... FROM episode ep WHERE ep.closure_date between '04-01-2003' and '06-30-2003' gradually add files […]
2003-07-17
Executing the stored procedure sp_help with no parameters will return a list of tables and objects in the database. Running sp_help followed by by the table name will return schema info about that table; for example, "exec sp_help myTable"...
2003-06-26
To leave the database in a consistent state. If the trigger detect an error a rollback / undo of the 'insert' is automatically performed. Read about Codd and his 10 relational commandments.
2003-06-23
I have used dynamic sql to create the required query ( as transio listed ) based on the values to be transposed. Still have not found a way to do it in single written sql statement
2003-06-20
2003-06-19
If you're planning to use QA then the user need permission to exec. xp_cmdshell otherwise just the appropriate permissions to write data. for bulk insert: Your user has to be a member of the "Bulk Insert Adminstrators" role which is a server wide role Refer to "Bulk Insert" section "permissions" on BOL MW Edited by […]
2003-06-13
2 reads
quote: PC, you are missing out on a lot since dynamic sql used correctly can yield very good results. Although I did not use it in my example, properly parameterized dynamic sql using sp_executesql is sometimes much better than a proc that has tgo handle multiple scenarios. Plans are cached when using sp_executesql and the […]
2003-06-04
Hi winash, only thing I can think of is SET ANSI_WARNINGS ON/OFF, but that's something different. I'm pretty sure, I haven't changed settings since I have installed QA. Cheers, Frank
2003-06-03
1 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