Viewing 15 posts - 136 through 150 (of 317 total)
I prefer to use DBCC ShowContig and utilize the following criteria as to rebuild or reorganize.
On indexes with more than 10,000 pages
Rebuild when Logical Scan is 20% or higher
Please...
March 22, 2011 at 11:12 am
It depends on what SQL services you have running. The upgrade will inform you of which services are running and which will require a reboot if they are not...
March 18, 2011 at 10:33 pm
On Wednesday evening I went from Service Pack 2 to Service Pack 4 in under thirty minutes.
March 18, 2011 at 3:07 pm
Recently applied SP4 to our Development server and tested by moving a database from that particular server to our QA (which is still SP3) all worked fine.
March 18, 2011 at 3:04 pm
You can use a file splitter application to make smaller chunks - thus allowing you to even email yourself the file.
Another option would be to use a FTP...
March 10, 2011 at 10:23 am
srpd.m123 if you are new to Admin role and you are unfamiliar with where to run the code, maybe a Maintenance Plan would be best for you. You can...
March 7, 2011 at 12:56 pm
Have you attempted to remove the Microsoft SQL Native Client prior to applying the Service Pack 2? There is a good chance that this is corrupt.
March 4, 2011 at 10:40 am
SKYBVI is correct, the easiest way to address linked servers after an upgrade is to use the SSMS and script the linked servers. Be aware, unless you copied the...
March 1, 2011 at 8:59 am
A company I worked for in the past was a certified SQL Server resellar. Unfortunately I never found the proper/correct way to answer this exact question. My work...
March 1, 2011 at 8:47 am
SQL Distributed Management Objects is the original COM API which was used to manage SQL Server. Your challenge will be to figure out which program the API is using....
March 1, 2011 at 8:29 am
Please review the following forum thread - http://www.sqlservercentral.com/Forums/Topic491773-146-1.aspx#bm491978
February 28, 2011 at 4:45 pm
Shouldn't be a problem, please have a look at this MSDN link - http://msdn.microsoft.com/en-us/library/ms143393(v=SQL.90).aspx
February 28, 2011 at 2:05 pm
As Lowell mentioned, for the executable and services, you don't have a choice. However, during the installation process, when you get to the step regarding file location, this is...
February 28, 2011 at 9:57 am
Find a copy of the ODBC32.dll file and replace it on the affected machine. More than likely it got overwritten.
February 23, 2011 at 12:26 pm
Please review this MSDN link, it should answer all of your questions.
http://msdn.microsoft.com/en-us/library/ms143293(SQL.90).aspx
Good luck
February 23, 2011 at 12:21 pm
Viewing 15 posts - 136 through 150 (of 317 total)