Viewing 15 posts - 43,936 through 43,950 (of 49,571 total)
J (10/9/2008)
Would you pleae humor my curiosity and give a short description of what kind of an application generates a terabyte of data ?
A bank's trading system for one. One...
October 9, 2008 at 10:20 am
Jan Van der Eecken (10/9/2008)
Good Luck, Gail! I wish there was a User Group in Cape Town as well.
There may well be in the future. Right now it's JHB, because...
October 9, 2008 at 10:18 am
samsql (10/9/2008)
Plz gail provide me some thing so that i can reduce the log size....
I'm trying to! That's why I'm asking so many questions to try and get to...
October 9, 2008 at 10:17 am
What does the following return?
select name, type_desc from sys.objects where object_id in (624252677, 640252734)
What other changes have you made to the system tables?
October 9, 2008 at 5:16 am
How are you planning to load balance 2 SQL server databases? (Or have I misunderstood your question)
Clustering isn't for load-balancing. It's for high-availability.
October 9, 2008 at 5:13 am
You can get SQL Server Developer for around $50. Search Microsoft's site, it's somewhere there. Developer has the full Enterprise features, it's just licensed only for development usage.
October 9, 2008 at 4:55 am
There's no easy way in 2005. The counters that keep track of changes are hidden.
SQL will automatically update stats on a column as soon as the number of changes to...
October 9, 2008 at 3:43 am
That is a topic that gets endlessly debated. There's no right or wrong side, just preferences.
Myself, I don't like 'N/A' or 'unknown' records scattered all over my DB, so I...
October 9, 2008 at 3:42 am
gpet (10/9/2008)
Yes it is in Oracle 10g.Am I in a wrong forum?
Yes. This forum is dedicated to Microsoft's SQL Server.
May I suggest DBForums[/url] as they have an Oracle section.
October 9, 2008 at 3:21 am
You'll probably have to call Microsoft's support people on this one. That kind of thign is usually an unhandled exception in the code and not something that we can fix.
October 9, 2008 at 3:20 am
sqlservertica (10/8/2008)
The old server had 8 processors and the new server has 16, but remember that our new server is a 64bit machine and the old one was 32bit.
The main...
October 9, 2008 at 3:12 am
Maybe, maybe not. It depends on how bad the corruption is. No way to tell without seeing the results of CheckTable or CheckDB.
In SQL 2000 I think it does take...
October 8, 2008 at 2:47 pm
Yes, it will take time. Probably a couple of hours. You still need to do it.
At this point you have an unknown amount of corruption of unknown severity in that...
October 8, 2008 at 2:39 pm
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic582886-148-1.aspx
October 8, 2008 at 2:29 pm
Viewing 15 posts - 43,936 through 43,950 (of 49,571 total)