Viewing 15 posts - 45,856 through 45,870 (of 49,571 total)
So, what did sysprocesses and the perfmon counters show?
Check this and see if it maybe matches your problem - Memory and SP2[/url]
July 9, 2008 at 6:52 am
Jeff Moden (7/9/2008)
July 9, 2008 at 6:26 am
Welcome.
First, please read this - http://www.sqlservercentral.com/articles/Best+Practices/61537/
If you can give us your table structure, a sample of the data in it and an indication of the results you want, I'm sue...
July 9, 2008 at 5:24 am
I don't know if the x86 quads will beat the itaniums (can you even get x86 quads?) but the x64s could quite easily beat the performance of the Itanium servers,...
July 9, 2008 at 5:08 am
Look up ALTER TABLE in Books online and check the section on foreign key constraints.
You set the cascading properties when you create the foreign key. If the constraint is set...
July 9, 2008 at 4:54 am
ltoso (7/9/2008)
do you mean to say i should shrink it to 27mb or something else the current size of transaction log shows as 27MB and which is also set as...
July 9, 2008 at 4:50 am
That is the entire command. EXEC sp_cycle_errorlog
You can get full info on it in Books online.
I would suggest you cycle the error log, then watch the new log file to...
July 9, 2008 at 4:48 am
umailedit (7/9/2008)
What are "all the benefits that come along with it"?
The prestige of the title for one and the industry recognition that comes with it. I'd consider that one of...
July 9, 2008 at 4:46 am
Those are SQL's latest 2 error logs. How often do you restart the SQL Service there?
Do you ever check SQL's error logs? I can't think of any reason they should...
July 9, 2008 at 1:45 am
Please edit your post to fix the scrolling. use [ quote ] rather than [ code ] (removing spaces)
If the log is only 27 MB, leave it alone. It's small...
July 9, 2008 at 1:39 am
You can, but you shouldn't need to. SQL only keeps a certain number of log files (default I think is 6).
Every time the service is restarted or the log is...
July 9, 2008 at 1:21 am
ltoso (7/9/2008)
Hi,shrink file to 27mb(what should be mentioned here)
That's the option you want. To know how big to make it, you need to know how much space the log typically...
July 9, 2008 at 1:17 am
You can do it through management studio. Go to the database properties and to options. It's at the top of that screen.
You can shrink the log file there also. Right...
July 9, 2008 at 12:51 am
Those are .net errors, not SQL errors. Looks like you have a table missing.
Did the installarion give any problems?
July 9, 2008 at 12:40 am
debraj.behera (7/9/2008)
You can create DTS in sql 2005 using integration services.OPen Visual studio 2005
File > New > Project > Bussiness Integence Project > Intgration Service Project
That creates an SSIS project,...
July 9, 2008 at 12:37 am
Viewing 15 posts - 45,856 through 45,870 (of 49,571 total)