Hi,Thanks for your reply.Actually there were only 1600 records in that table and only 15 small columns were there in that table. And SQL Server as such was not hang. only that particular table is not accessible in any ways. Other tables in that database and other databases were working fine without any problem. And […]
2004-01-28
1 reads
sometimes the best solution is the simplest CREATE PROCEDURE Usp_MoverItemTest1 (@id char(1),@Direction char(1)) As SET NOCOUNT ON DECLARE @sort int, @id2 char(1) SELECT @sort = sort FROM testsort WHERE id = @id IF @direction = 'U' BEGIN EXEC usp_moveitemtestup @sort , @id2 output END IF @Direction = 'D' BEGIN EXEC usp_moveitemtestdown @sort , @id2 output […]
2003-12-01
1 reads
Not that I am aware of. Anything you need to configure can be done with sp_configure if you don't want to use EM. Wes
2003-09-02
2 reads
Just for the heck of it I typed the url http://www.db2central.com. I came up with a plain looking Login/Password page. It makes me wonder... Are there DB2 sites like this out there but you have to know some sort of secret handshake to get in?
2003-08-22
1 reads
Hi uitforums, quote: Emails are down again... Seems to work for about 12 hours then it quits. not noticed yet. My previous mail came in as expected. ??? As for your hint on a RSS reader, your link isn't really an option for me, because it requires IE6. Here at work we have IE5.5 But […]
2003-08-12
1 reads
FMS and DBMS are moving together. Oracle has already tried it. Microsoft is now doing so as well (note the date is 2002 on the following article): http://news.com.com/2009-1017-857509.html It's been talked about for awhile about Microsoft going to a SQL Server based file system. Longhorn may bring about that reality. More (from an article dated […]
2003-08-04
Hi there The advent of OO databases has been a bit of a shammozel really, and to some degree the main architects (Microsoft, IBM, Oracle) have been guilty of not persuing the technoligies heavily enough. I have a OO DBMS book written some 8 years ago with very thorough mathmatical models and associated structures, so […]
2003-08-03
1 reads
You could try but you really have to know your data to have a clue. Do SELECT db_name(dbidvalue) to get the database name. Then do DBCC TRACEON(3604) GO DBCC PAGE('dbnamehere',filegroup,pagenumber,3) The output is the page data itself (3 is one option and the easiest to read) but again you have to know you data and […]
2003-07-29
1 reads
Hi accent-atlant, quote: Do you test it on 1000000 row??? I have slow perfomance... I guess it should only be a work around for a missing ident column. Sure, that you will run into performance issues with million row tables. BTW, interesting homepage (not, that I have understood too much ) Cheers, Frank
2003-07-21
1 reads
I work with Tom and the "stovepipe" problem is something I've seen here as well as other places. Having projects like this centralized, even with a steering committee of one can help to prevent inconsistencies. Also, a good look at some of the pitfalls. ETL is a great tool, but not the solution for bad […]
2003-07-15
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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