Viewing 15 posts - 5,461 through 5,475 (of 7,429 total)
If you are using the database like a data wharehouse then it is quite normal for the indexes to be larger than the table. My only thought is you may...
June 13, 2002 at 7:50 pm
Meant to test this today but have a project that I will be busy with. However what Steve is suggesting should do the trick.
"Don't roll your eyes at me. I...
June 13, 2002 at 7:47 pm
Ok folks, he is talking about another server. Which company version is this? (IBM??) I have never used but I have documentation from IBM on there stuff and you could...
June 13, 2002 at 7:45 pm
Or more so, the data is roll forward from the TL to data when the process is completed or a COMMIT is issued.
"Don't roll your eyes at me. I will...
June 13, 2002 at 7:41 pm
Also check out http://www.sql-server-performance.com , there are a lot of good tips there.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 13, 2002 at 7:02 pm
No, the reason is the new index still has to scan the table for values then it will use the PK (if clustered) or a rowidentifier as a pointer to...
June 13, 2002 at 6:58 pm
It will link the SPIDs in SQL based on the user name matching. It will not repair passwords, those have to be done by hand or possible pulling the password...
June 13, 2002 at 6:45 pm
I have never seen a way and as far as I know you can only say if a stepped failed and choose path of execute. DTS is a better solution...
June 13, 2002 at 6:40 pm
I generally use ALTER. I test it then see if what I expect is happening. If something is not happening right then I run sp_helptext theprochere or open EM and...
June 13, 2002 at 6:28 pm
Sounds right to me. However you may want to do a backup of the log or a differential right before issuing the truncate log just for a safety margin. Many...
June 13, 2002 at 6:18 pm
Steve is right, SQL is planning for the need again but if something else needs the memory the OS will reallocate and inform SQL to play nice.
"Don't roll your eyes...
June 13, 2002 at 6:14 pm
Just a note to add, security is only valid if the drive is setup with NTFS and not FAT.
"Don't roll your eyes at me. I will tape them in place."...
June 13, 2002 at 6:13 pm
Let's go back to the question. The answer for what is best is whatever you are familiar with or willing to learn that will make give you the required results...
June 13, 2002 at 5:53 am
Gotot http://www.microsoft.com/data and download a new copy of the MDAC. Install it first then try thr setup. Could be a file is locked when it tried to update or some...
June 13, 2002 at 5:42 am
When you say you installed 90 SQL 2000, did you do the upgrade or instance method? If upgrade then you cannot read the repository in 7 as the structure was...
June 13, 2002 at 5:40 am
Viewing 15 posts - 5,461 through 5,475 (of 7,429 total)