Viewing 15 posts - 3,586 through 3,600 (of 7,429 total)
First you have to clear all transactions from the TL with a backup of the log.
Then you can use DBCC SHRINKFILE to shrink it in both 7/2000. But in some...
January 15, 2003 at 4:45 am
Actually just to throw in on that. RAID10's strong point in writes in comparison to RAID5. The reason is the number of reads and writes that occurr. With a log...
January 15, 2003 at 4:38 am
When you stopped SQL Server did you goto the location on the file system to make sure the tempdb log and data file were delete. I have seen on a...
January 14, 2003 at 8:42 pm
Also, if going to store passwords I suggest using one way encryption of item agaists itself as encryption key as you do not leave potiential keys like this in your...
January 14, 2003 at 3:19 pm
What is the address? Maybe 127.0.0.1 which is the loopback address or something similar.
January 14, 2003 at 3:14 pm
I agree, this sounds like someone making comments out there backend without checking things. Have him provide you how he has determined this first off. I mean what bandwidth is...
January 14, 2003 at 3:13 pm
I suggest using a known encryption method with high reliability such as 3DES. CAPICOM is a free set of APIs from MS that supports various crypto formats including certificates. Check...
January 14, 2003 at 3:05 pm
Ok first a little bit of disclaimer since of course this can be used for malicious intent.
The information provided is done so for educational purposes only. I in no way...
January 14, 2003 at 2:59 pm
TempDB is not really supposed to be shrunk for the simple reason it is where a lot of work occurrs and it sizes itself. If stopping, (sometimes deleteing the .mdd...
January 14, 2003 at 2:44 pm
Can you post what the expected results would be for the data. I see you would add an end date range as described by Andy. As for your statement as...
January 14, 2003 at 2:36 pm
Did you check the Event Viewer logs, cometimes the error message is better there.
January 14, 2003 at 2:29 pm
Yes, truncate actually doesn't even remove the data when it works. It just marks a truncate in the logg and invalidates the poitner to the tables actual data in the...
January 14, 2003 at 2:26 pm
I have never heard this either. Have you check with the coworker to find out what they are referring to?
January 14, 2003 at 2:24 pm
First just about any data related concept is capable of being expressed in SQL. However, what is your goal, what are you expecting the data in the table to look...
January 14, 2003 at 4:18 am
Have not looked at a Compaq in a while. However performance issue around read and writes should be looked at. I assume from Large TL lots of writes and RAM...
January 13, 2003 at 8:24 pm
Viewing 15 posts - 3,586 through 3,600 (of 7,429 total)