Thanks guys....I am using SQL2000 and currently running the statement that Borislav gave me....if I have enough disk space for it to complete I think I'll be ok. I'll update this shortly to let you know how I made out
Thanks
Hi there
I am in need of creating a subset of our data. I would like to delete all rows from all tables that have a date earlier than 2007-01-01. Does anyone know of a simple way to do this?
I was hoping a simple statement like the one below would do the trick
delete from (select table_name...
we just went through this in house and was told that the licenses count against the number of physical processors so therefore a dual core or quad core processor is only one license
Just wondering if anyone has any thoughts about migrating a domain controller to vmware using the p2v converter? Are there any issues I need to be concerned about?
Thanks
we ran into a similar problem. It was resolved by the 2 following MS KB Articles
http://support.microsoft.com/kb/275171/EN-US/
This first article talks about the GUIDEN program and assigning a new ID to the sitefolderguid setting
The second article...
We are currently migration from NT 4 to Windows 2003 as well as Exchange 5.5 to Exchange 2003. We have completed the Windows 2003 migration and are currently running AD with no issues. We installed the ADC connector via the wizard and ran through all the tools (mailbox resource wizrd, etc)...
We are soon to be migrating our Exchange 5.5 Environment to 2003. Our layout is a follows
Bridgehead Server and Mailserver in site 1
7 other sites running Exchange 5.5 connected to the Bridgehead with x.400 connectors
We plan on migrating our bridgehead server first and then upgrading all the...
Does anyone know of any NT management tools that would perform the following:
- last logged in time for user
- total space used (user files) for user
- When files were last accessed
- files that are duplicated on the server
(same file stored multiple times)
We're also looking for...
We have an issue that users, when looking to select another one of their printers, sees a list of all mapped printers on the server from other clients. Is there a way to display only that clients printers? Our environment is Windows Nt 4.0 SP6a, Metaframe XP FR1
Thanks
I just found some information on defrag and re-index. We're going to run those this weekend hopefully and see if it makes any difference. Do you have any other suggestions?
I'll definitely check out that site. We actually already had someone come in to do just that. They re-indexed all the tables last year and we saw a huge performance increase. Since then however, our database has grown in size and the number of users has increased as well.
the disks that we are using are 15K drives. We do have it running on a hardware RAID controller for RAID 10(ten). Our current RAID controller does not support disk write caching and we were considereing purchasing a new controller to replace that one but I'm wondering how much of a performance...
We are trying to deal with complaints of slowness in our SQL server environment. We have the following
IBM x440
8 Way P4 1.6
6 GB RAM
12 - 18 GB HD configured to RAID 10
Windows 2000 Advanced Server
SQL 2000
CPU usage is low on the server and memory usage is also low (2GB used out of 6GB)...
I'm having problems sending auto-replies to the Internet. I've removed the check box on the IMC connector to allow replies to the Internet. I've stopped and started the IMC service. and I've also created a rule on the server which works for internal mail users...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.