Forget my last statement. I think you were alone the right lines about multiple log files. I have tried to attach the db to a test sql2000 box and noticed the 'Device activation error' appears twice for the log files, where there was only one log file on the database. Looking at the database sysfiles […]
2002-03-20
To do thru cmd line you can use isql. SOrry I don't generally use myself but for a list of the paramteres type isql /?. Otherwise, I know you can do thru any languag that supports making database connections. In VBScript you can make an ADO connection to the database and execute on the connection […]
2002-03-20
I believe the only way a temp table can take advantage of a user-defined datatype is for it to exist in the tempdb. The problem with this is each time the server restarts the tempdb is rebuilt so your datatype will dissappear. However if you need this datatype you can add it to model and […]
2002-03-20
Not any great benefit for 2 partitions. The second thread's gains may be lost with the movement of the heads. Hard to quantify any gains. Steve Jones steve@dkranch.net
2002-03-19
I vote 1 partition also. "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
2002-03-19
1 reads
Try This. I did it with two tables (tbl_new_1 and tbl_new_2) both containing columns for stock_id VARCHAR(10), description VARCHAR(20). Primary key on stock_id INSERT dbo.tbl_new_1( stock_id, description) SELECT stock_id, description FROM dbo.tbl_new_2 a WHERE NOT EXISTS ( SELECT stock_id FROM dbo.tbl_new_1 b WHERE a.stock_id = b.stock_id) The correlated subquey in the EXISTS statment will find […]
2002-03-19
1 reads
YUP I use DELPHI 5 accessing SQLSWERVER through ADO (direct ADO TLB not ADO Express) Works uncommonly well! But I have to admit to being an MS person as well my principal languages are DELPHI, VB, JAVA and I'm a C# initiate.
2002-03-19
1 reads
I use VB primarily, some Access, HTML. Probably will move to .Net shortly. Andy
2002-03-19
First the only way I know of to reinstall Agent is to reinstall SQL (which I would make a backup of the databases beforehand). Next reinstalling may not help as I have seen this problem before on one of our servers. The problem is that when SQL Agent starts it is trying to access an […]
2002-03-19
I have dabled here and there with delphi and own version 1 and 2, but I am (not necessarily pure MS) VB, C, C++, VBScript, JavaScript, JAVA (Not too much), HTML, SQL (Oracle, Sybase, Informix, Access, Paradox, SQL Server) kind a guy (a few others but these are the most experience). And I keep trying […]
2002-03-19
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