RE: Multiple inserts in ADO.NET
Are you using a stored proc? That would speed it up some. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-11-18
1 reads
Virtualization
RE: Licensing mode
Of course you have to purchase your license. Paper work is one thing and how to change it is another thing. Call Microsoft if you like to confirm whether it is an 'offical' procedure.
2003-08-22
2 reads
2003-08-21
1 reads
RE: Problem with linked server (dBASE)
I'm not real big on DbaseIV linked servers, but I have used the following syntax to read the EMPLOYEE.DBF file out of the MS Office directory. You may be able to massage it for your purposes: SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source="D:\Program Files\Microsoft Office\Office\1033\";Extended Properties=DBASE IV')...[Employee] Cheers, - Mark
2003-08-05
RE: new Cumulative Security patch for sql2000
quote: Has anyone applied this yet? If so, any adverse affect to processing? Terry I've applied this to all of my servers in development, test, and production. We're still running SQL Server 7.0 on NT4. The only things that I've noticed with the install in our environment is that sometimes the hotfix wouldn't restart the […]
2003-07-30
2003-07-30
RE: Can't Open Default Database
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-28
RE: re-index
Andy, According to the article at http://www.sql-server-performance.com/statistics.asp : "If the number of rows in a table are greater than 6, but less than or equal to 500, then statistics are automatically updated when there have been 500 modifications made. If the number of rows in the table are greater than 500, then updates are automatically […]
2003-07-28
1 reads
RE: Numbering the ResultSet - Equivalent of Rownum
Hi anilg, quote: Thanks, but the problem is i cannot add a column to the database. All i can do is change the queries to get an equivalent of Rownum as Rownum is not available in SQL Server. if I understand roght, you're looking for a consecutive numbering without a identity column? Somewhere I found […]
2003-07-18
1 reads
RE: DTS fails with Oracle 9 due to multiple LONG field
Have you messed around with using DTS to manually import these tables. You may have to transform the data using VB Script for the data types it is not handling. BOL has information on using VB Script to transform data. Darren
2003-07-01
1 reads
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