Congrats!!!! and thanks for being a part of the community. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-12-05
1 reads
2003-12-05
The DBA as a DB Developer is integral to the good design of an app, so DB Developers should always be part of a project. Admin DBA dont need to be in the meeting but do need to know whats down the pipe so they can scale for new projects.
2003-12-02
1 reads
2003-11-30
1 reads
Hi Steve, I just spoke to the systems administrator and he failed to install SP3. Thanks for your help, Pete
2003-11-24
Do you mean Windows 2000 Professional or Server? My understanding is that it can't run on 2000 Professional. Edited by - amackay_1 on 11/18/2003 08:09:52 AM
2003-11-18
1 reads
look at bcp in bol Other methods http://www.nigelrivett.net/WriteTextFile.html Cursors never. DTS - only when needed and never to control.
2003-11-15
2 reads
Hi buntyHunter, quote: I'm currently thinking of changing one of my nvarchar columns to ntext - I need to store large documents that may be a two to ten Megabytes in size. I've been researching and performing tests, but I'm still a little confused about what I can and can't do with ntext fields. I've […]
2003-08-28
There is no easy way to do this in a single operation. What possibilities exist? 1. Use a trigger on the table. If you have cascaded triggers, you are sure to change all the records (up to 32 levels), but this can be quite some overhead. If you have the same child for different parents […]
2003-08-26
himan0110, I'm not quite with you ... Let's try it with an example. say: 1 row = 1000 bytes insert into ADStable select * from ODStable1 a where exists (select PK from ODStable2 b where a.PK = b.PK and b.a_key_field='SOMETHING') (b.a_key_field='SOMETHING' is less then 5% of the rows, so no table scan) both ODStables have […]
2003-08-25
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