Steven's advice is good. Stop SQL Server and copy out your Data directory. I restored the servers twice using this technique. If the system databases are in this directory too and you are restoring to the same NTFS locations the restore is as simple as re-install SQL Server if needed, stop it, rename original Data directory, […]
2004-06-11
Hans,Backing up over two or more files (I assume you mean a striped backup here) is useful for speeding up large backups that otherwise might not be do-able inside a given backup window.Cheers, Chris
2004-06-11
Hello guys,I've been looking for solutions about this issue for quite a time now, but I can't figure one. My question is quite simple : Is there any way to shrink a primary file after using DBCC SHRINKFILE(filename,EMPTYFILE).I d'ont want tu delete it, only shrink it to an acceptable size.The fact is that I have […]
2004-06-11
133 reads
I just got done installing the Sybase client software and setting up a DTS package and it seems to be working. Thanks everybody for the heads up.
2004-06-11
Hi Tal,I rearrange the table slightly ( which can be done in #temp)Well. What I am trying to do is the following.Client_Rep Begin_Work End_Work Vitalio Arini 9.00 9.45 Vitalio Arini 10.00 12.00 Vitalio Arini 14.30 17.00 Nino Verto 8.30 11.00 Nino Verto 15.00 17.00 Ken Coles 9.00 12.30 Ken Coles 13.00 17.00Ken Coles has only half on hour break. […]
2004-06-11
That's quite interesting .. the probs I had were with a 4Gb ram cluster using zeon 3's. It was decided that adding the extra memory slowed down the server and caused severe locking .. I didn't really get enough time to run diags myself and every time we had the ms guys in we had […]
2004-04-02
It would be simplest to send the mail from within the same procedure that updates the password, however, that means notifications wouldn't be sent if the table were updated directly.A trigger would solve that problem. In this case it would be pretty simple, as a matter of fact I have done exactly this on one […]
2004-03-02
1 reads
Are you creating the dimension from the fact table or from a separate table/view? I've run into this when dimensions are sourced from the fact table (normally a view for me) and that view is complex and takes some time to return results. If you are sourcing the dimension members from the fact table, I […]
2004-02-24
I gave you a little extra context, Line 151 is where the error is at which there is nothing there, the code actually starts at Line 152. http://www.macrotransport.com/availableload.asp that is the error I am talking about, one out of the two I have, everything was fine untill the upgrade, seems like an MDAC thing, it's all new […]
2004-01-30
1 reads
Hi, I'm evaluating a service where I will need to call a stored procedure which will check available balance through a micro payment service which runs over a secure website. The call looks similar to:https://webpage.clearinghouse.com/app/?user=me&password=mypassword This returns a basic results like: ok;{credit available}; Does anybody know of an existing XP that would return the result of a web […]
2004-01-30
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