Viewing 15 posts - 301 through 315 (of 327 total)
Just an FYI - I have found that shrinking in smaller amounts will speed things up considerably. No more than 2GB at a time seemed to be optimum for our...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 2, 2005 at 7:13 am
Thank you. I missed it completely!
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
October 27, 2005 at 4:21 pm
you might also try sp_helprotect.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
May 4, 2005 at 1:17 pm
Thank you all for your suggestions. We sized the archive database for 2 years of data and the initial load will be for 1 year. I completely blanked out on...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
April 7, 2005 at 6:26 am
You might try creating an sql script that will format your selection and use it with OSQL and an output file.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
February 9, 2005 at 1:45 pm
nope - no errors at all.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
February 3, 2005 at 6:34 am
You may want to check this out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 22, 2004 at 12:46 pm
Another option might be to save the packages as VB files (.bas, it's an option in the Save As) and compile them into executables.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 22, 2004 at 12:37 pm
Yet another way:
use Northwind
go
Select top 2 rownum = identity(int,1,1),
productid, quantity
into #tmp
from [order details]
order by quantity desc
select * from #tmp
where rownum = 2
drop table #tmp
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 16, 2004 at 7:13 am
The maximum value that an integer data type can contain is 2,147,483,647. Try using a bigint data type.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 9, 2004 at 8:00 am
Thank you for the input. I just finished reading todays' article on DTS Logging and I think using SQL-DMO would be the way to go. Now I just need to...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 9, 2004 at 7:43 am
The packages I need to update with new connection information already exist in an SQL Server. Currently, I open the package in designer and modify the connections. I would like...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 7, 2004 at 7:51 am
Just one installation - Advanced Server on C. The SQL binaries are currently on E.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
August 31, 2004 at 11:04 am
Unfortunately, I don't know. You would have to contact support for your disk controller manufacturer and find out from them. It's done at the controller level.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
August 30, 2004 at 1:52 pm
This very much like the 605 error. Microsoft advised us to turn off read caching completely. Generally, you will need to turn the write cache up to 100% in order...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
August 30, 2004 at 7:36 am
Viewing 15 posts - 301 through 315 (of 327 total)