Viewing 15 posts - 301 through 315 (of 502 total)
Lynn is correct. They are at different CU levels.
Microsoft SQL Server 2008 (SP1) - 10.0.2714.0 (X64) - SP1 CU2
Microsoft SQL Server 2008 (SP1) - 10.0.2740.0 (X64) - SP1 CU4 with...
January 29, 2010 at 4:34 pm
Rebuilding the clustered index does distribute the data to the additional data files however if you want the data to be filled equally across the data files you have to...
January 26, 2010 at 5:04 pm
Yes, you just need to create the data files that belong to the filegroup on each of the 4 drives.
January 26, 2010 at 4:40 pm
would the file format revert to SQL 2005 format and thus make a database interchangeable amongst a SQL 2008 and SQL 2005 instance.
If a database is attached to SQL 2008...
January 26, 2010 at 4:32 pm
Running DBCC OPENTRAN in tempdb may give you a starting point if there is a long running query in tempdb.
January 25, 2010 at 4:48 pm
This cannot be done in SQL 2005 but can be done in SQL 2008 Enterprise Edition using the Resource Governor.
January 19, 2010 at 4:41 pm
Also, is there a way to establish a threshold in order to fail over (not to send alerts), the reason I'm asking is because sometimes the WAN has small 'hiccups'...
January 15, 2010 at 4:01 pm
Gotcha. I was a little confused. My previous post is still valid for your setup although I would do a detach/attach since you are not changing servers. Do a final...
January 15, 2010 at 1:04 pm
It should be fairly straight forward then if you are doing to side by side migration.
1. Copy logins and jobs from old server to new
2. Backup databases before the migration
3....
January 15, 2010 at 9:38 am
I thought only the option Auto Update Statistics would generate the statistics changes.
Does any one know?
Auto create statistics will create column statistics automatically if a query is hitting the column...
January 14, 2010 at 4:49 pm
[We are not going to completely move to 2008 overnight. So, an instance is going to be created and on top of that we are also going to add another...
January 14, 2010 at 4:22 pm
You are correct. There is no cost difference.
January 13, 2010 at 5:30 pm
Sometimes the cost of running queries over many processors is more expensive because SQL has to split the load across the processors and then gather the steams back up to...
January 8, 2010 at 5:20 pm
Nice! Thanks Jeff. Guess I glossed over that.
January 8, 2010 at 12:34 pm
You need to connect to the site using a 64 bit machine and IE, then the 64 bit versions will display. MS in their infinite wisdom thinks everyone connects with...
January 8, 2010 at 12:23 pm
Viewing 15 posts - 301 through 315 (of 502 total)