Viewing 15 posts - 27,016 through 27,030 (of 39,793 total)
Shouldn't, but it will wreck your indexes and create fragmentation. Why run it?
September 16, 2008 at 9:22 pm
Once you start restoring, you're applying log records to the database. The log itself doesn't get restored, but I believe that it's marked as truncated to the restore time.
To get...
September 16, 2008 at 9:20 pm
Patches are cumulative of other patches since the last service pack.
September 16, 2008 at 9:15 pm
Which results?
The alias ones? Use
where [10%] > 1000
September 16, 2008 at 9:13 pm
I'm not, but I was there last year and thought it was great.
September 16, 2008 at 8:33 pm
364k records might be more than 10GB. Have you tried sp_psaceusde to see the size of the table?
September 16, 2008 at 3:38 pm
I'd make it large and see.
Shrinking the database shouldn't matter, but it does mess up your indexes (fragmentation)
September 16, 2008 at 3:14 pm
I'm trying to get them to. If I get the time, I might go spend some time with them and see what I can document.
September 16, 2008 at 2:31 pm
There must be more to the error. Perhaps file permissions?
September 16, 2008 at 2:10 pm
What's the problem?
Splitting the file must be done with some programmatic code (VBScript or VB or C#). You can commit the file in smaller batches (options in the transform data...
September 16, 2008 at 2:09 pm
Most of our videos here are from Jumpstart, and I own part of the company.
Microsoft has a series of webcasts and screencasts as well on MSDN.
September 16, 2008 at 2:08 pm
Hey, an agreement with me! Usually I'm the one agreeing.
September 16, 2008 at 2:04 pm
Is this read only data? If so, shared scalable databases can work.
If not, I'd look at database mirroring instead of clustering, less complex.
No real scale out solutions for SQL Server...
September 16, 2008 at 2:02 pm
Viewing 15 posts - 27,016 through 27,030 (of 39,793 total)