Hi, I have an error I am trying to understand. First I am a programmer/developer who has mostly worked with DB2 (20 yrs). I have a database on a server. I was able to use BCP to create a format file for a table. Since the file being loaded has extra fields, I did what […]
2002-01-10
1 reads
Which do you prefer to use in stored procedures? Building a string dynamically and then executing it or creating static SQL code? Do you ever mix these two techniques in the same stored procedures? For me, I prefer building a string dynamically and then executing it. Too me this allows much more flexibility and is […]
2002-01-08
4 reads
I know there are details regarding sizing SQL Server but would like to know if there is any information available regarding the sizing of an MS Analysis Server.
2002-01-08
2 reads
Does anybody know how to set up an AutoNumber field in SQL Server, like in Access? I want a field that simply increments a number by 1 with each new record, and so creates a unique field. Thanks!
2002-01-07
47 reads
Background: We have database maintenance plans to do our backups. Our backup file system filled up so the database backup failed. It generated a warning in the event log with the following text: "BackupMedium::ReportIoError: write failure on backup device '...'. Operating system error 112(There is not enough space on the disk.)." which is the standard […]
2002-01-07
One user has a 13GB partiton on his D drive. The Database backup job failed letting the trans log grown to 8GB! I fixed the db dump problem but the trans log is still 8GB in size and won't let me skrink it. What can I do?
2001-12-21
2 reads
Hi there, Can someone tell me if there are any free libraries/drivers that I could download to make my solaris 2.6 client talk to a ms sql server 7.0 regards Uday
2001-12-11
1 reads
Is it possible to monitor the updates made by an immediately updating subscriber and applied at the publisher - can't seem to see where this history is shown. Paul Ibison Paul.Ibison@btinternet.com
2001-12-04
2 reads
This is the scenario: 1. Merge replication between B <-> C 2. Trans replication from A -> B 3. This is with the same table x in both publications. 4. A change made on x in A replicates to x in B, but the merge replication do not register the change and therefor do not […]
2001-12-04
1 reads
posted from user: How can I solve this problem, Example: Create Table Test (ID integer, address char(40)) I like insert a data like this ID=1 address=O'donnell 74 or ID=2 address=2" size insert into test(ID, address) values(1,'O''donnel')? Brian Lockwood President LockwoodTech Software
2001-12-03
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