It totally depends on the applications that you have on each server. When you fire up the first server and it just right to 1.4GB, there are most likely...

What do "YOU" want to do? Which do you enjoy most? This isn't a question the community can answer for you. You have answer it yourself.

Make sure firewall on your Win7 client is either disabled or allows port 1433 traffic.

-

Jason

Why rule it out because it's a production server? I would rule out running the Profiler GUI on the production server, but I wouldn't rule out running a server side...

You can also use SQL Profiler to setup a trace via the GUI, or as a server side trace to capture the deadlock information. With this method, you don't...

The ghost cleanup task generally takes care of the ghost records. However, on extremely OLTP-busy systems such as one of our customers, the ghost cleanup task cannot keep up....

DB Snapshot or backup/restore.

Well....I would say "MOST" humans...I believe Chuck Norris can do it!

Perhaps the instructor did not explain the directions properly? Or someone needs to re-read the assignment..

:w00t:

Of course it will be slow. That is a lot of data!

As Gail stated, your client app will also most likely puke. Why do you need to return...

You're prolly trying to execute the query in SSMS. Set your output to a file, then execute.

You can try using Plan Guides. With SQL Server 2008 , you can create a plan guide based on a query plan handle. Execute the query manually,...

Great to know! I do see the parameterized plan in the plan cache.

I'm checking out the ad hoc workload option. Looks like it will help. We also...

There are many ways to archive data in SQL Server. I would suggest you look here for a good start:

http://lmgtfy.com/?q=archive+data+in+sql+server+2008

I believe the first will be when you remove the PK. Since it's a clustered index, the non-clustered indexes use the PK as the unique identifier. By removing...