Viewing 15 posts - 27,826 through 27,840 (of 39,769 total)
tony,
SQL Server Express 2005 is the same as SQL Server 2005 for database formats, so SQL 2000 won't work.
You could install SQL Server 2005 Express as a named instance on...
July 12, 2008 at 5:04 pm
Really think about this. Everyone says they need real-time reporting, but very few people need it. Often every hour is fine.
July 12, 2008 at 5:01 pm
It's got to be a Groupwise thing then. I had someone say that Outlook 2003 might be problematic as well.
Are you sure you're pulling down pictures and that your image...
July 12, 2008 at 10:21 am
I'd argue against the marketing comment for the most part. There are people that fit that category. Without a doubt.
But most of the MVPs I know, and I think I...
July 12, 2008 at 10:15 am
I'd say it's appreciating what you have, striving to get more, but understanding that things are things, and not nearly as important as other things in your life.
July 12, 2008 at 10:11 am
Now, now, Jeff. We typically spread manure, not haul it. I think it's more like using a handheld grass spreader to distribute manure 😉
July 12, 2008 at 10:06 am
They'll certainly give us lots of questions to answer!
July 11, 2008 at 3:27 pm
checkpoints are roughly every few minutes. Not sure how this impacts what you're trying to do.
July 11, 2008 at 1:55 pm
You need to set it to get a subquery to get the aggregate.
So
create table MyTable
( myID int
,salesdate datetime
, myval int
)
go
create table NewTable
( myID int
...
July 11, 2008 at 1:54 pm
One time thing or a process?
One time, use QA. run the query, right click the upper left, save as.
Process, use DTS. The data export wizard will help you build the...
July 11, 2008 at 1:24 pm
And run Profiler to see if things are moving while it's executing.
July 11, 2008 at 1:23 pm
It's a syntax error, you need to see the query to figure out what's wrong.
July 11, 2008 at 1:21 pm
It's going to be one or the other all the time.
They're planing SQL 11, or about to, so I'd encourage Jeff to hit the MVP groups and post suggestions for...
July 11, 2008 at 10:45 am
Space might be available for new rows, but they aren't necessarily reused. Your clustered index might cause things to be more spread out, and depending on the values, pages might...
July 11, 2008 at 10:31 am
Terry has it correct. The backup process is optimized to throw pages out as quickly as possible and it has no tolerance for IO delays. So if the network hiccups...
July 11, 2008 at 10:23 am
Viewing 15 posts - 27,826 through 27,840 (of 39,769 total)