Gift Peddie (4/28/2011)

---

Lowell (4/14/2011)

---

I'm just like you...i used to have a Dell , upgraded to an HP win7 64 bit with an I5 processor & 4Gigs , and have had...

Standard edition can support up to 64 GB of memory: http://msdn.microsoft.com/en-us/library/ms143685.aspx

As far as deciding CPU vs Memory it depends on what your systems are doing. Are your processes CPU bound...

For all things hardware regarding SQL Server, you can't do much better than Glen Berry. Check out his min/max memory settings post: http://www.sqlservercentral.com/blogs/glennberry/archive/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008.aspx

Don't set the max SQL Server can use...

I know it's a Redgate site and all but I really do like the SQL Monitor tool (you can try it out online here[/url]). Simple interface, web-based so you can...

You could use SSIS to move that data from one database to another, and you can make the process repeatable if need be. If you want to quickly just pull...

You can stripe backups in SQL Server by adding additional files:

However if you try to do a restore without all of the files from the backup set you'll get this:

Alternatively...

When you virtualize you still want to follow best practices (i.e. data, log, backups and tempdb on separate drives). However, this is where understanding the abstraction of resources becomes critical...

I put a form of this answer here, but I can add a bit here as well. As much as I hate to say it, this is a giant "it...

I'll tell you up front I used to be a sysadmin and VMware was the platform I used to administrate so I'm a tad biased. First, in regards to virtualizing...

Ah ok, thanks. I knew the lower ones were system, can never...

I actually created SQL University to help folks learn SQL Server from the ground up from experts all around the world. You can check it out here, it's all free....

Does the SQL Server service start at all or does this occur when you're trying to access a specific database? Offhand I'd say it looks like you have database corruption...

For a REALLY good primer on data warehouse design for absolute beginners, check out David Stein's Data Warehousing week (Spring 2011) at SQL University[/url] . He does a great job...

Check out the Profiler portion of DTSxChange (note:I work for Pragmatic Works).

Profiler is made to tell you how much time our tool will save you in automatically converting said package...

Is it possibly bad records coming from the source? Can you split off invalid records to an error output? (see picture)