We have a SQL Server that we use for the test Enviorment. I am using VB 6.0 with ADO 2.7 to connect to this SQL Server 2000 instance. Ocassionally the Service hangs and during this time, the connection takes for ever to throw an Exception. Sometimes as long as 15-20 minutes and during this time, […]
2004-12-21
3 reads
I have an SQL joining more than 5 tables. The results set contains over 10,000 records. First time the SQL has to fetch only the first 25, then 2ed time with some parameters I should be able to fetch the next 25 and so on How this can be done? Now every time I execute […]
2004-04-27
I ended up having to first move the data into a table with all the date columns typed as Char. Then, you can check the dates to make sure they will fit into the datetime/smalldatetime ranges. E.g. if the date in the foxpro table is 1215-01-01, SQLServer won't like it. Teague
2004-03-10
Corrupted cluster index on a replicated table. I can fix the problem - I/O error (bad page ID) detected during read at offset. DBCC checkdb shows a corruption on an index. Normally I would drop/recreate the index or run checkdb with a repair_rebuild, but this table is replicated. What steps are needed to fix the […]
2004-01-29
2 reads
I have applied a trigger on inserts of a table. The triger might execute for 10 or more seconds depending upon the data in the table. The trigger might affect other tables as well. When a record is inserted into the table, the triger fires and starts executing. Now suppose that as soon as the […]
2004-01-29
Take a look at BOL for joins-SQL Server ->outer -> Using outer Joins. I bet there is also something here in the script section Frank http://www.insidesql.de http://www.familienzirkus.de
2003-11-26
quote: Could you please give me some insight/examples of how to write a stored procedure that joins data from a table in one database with data in another database? Like Allen said, use the fully qualified name: SELECT d1.Field1 AS "Database 1 Field 1" , d2.Field3 AS "Database 2 Field 3" FROM MyDatabase1.dbo.MyTable d1 INNER […]
2003-08-20
1 reads
The only alternative that comes to my mind is to update all the rows that got missed and then replication will replicate them. Of course if there are too many missed rows then that won't be a good alternative. Robert W. Marda SQL Programmer bigdough.com The world’s leading capital markets contact database and software platform.
2003-06-23
quote: sp_password will allow people to change their password, but they need a way of running it eg isqlw, osql or an application.
2003-06-04
1 reads
Well, he is honest quote: What a professional advertisement and first impression of your "company." Check this out http://dbforums.com/t803315.html Cheers, Frank
2003-06-03
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
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