sandman8301 (2/17/2009)

---

I've been wondering recently,

if you have applications that reference the same set of data but have their own subsets of information that they use to run what would be...

Yin Halen (2/12/2009)

---

We are redesigning our databases and are now going to be using all of the aspnet_XXX tables. We are running to the problem of how to insert the...

Yeah.. that would go over like a lead zeppelin!

I think you'll have to better describe what you want.

Are the two tables related? What field are they joined on? Why not UNION ALL?

Sagar,

Those CTEs are tricky.. I find that anything recursive is not so easy to debug.

Just curious, are you familiar with Sammy Hagar?

SQAPro (2/11/2009)

---

thanks for the update, that's the kind of thing that can be very helpful to someone else who comes along later, in the same situation, and is looking for...

An update for the curious:

I removed the /3GB switch from the boot.ini, and added /PAE, although from what I've read, it's not necessary.

I enabled AWE on SQL Server, and set...

It's been in service for over a year now, and it's used as our data warehouse and reporting server, but additionally functions as our intranet server.

Are you the interviewer.. or the interviewee?

If you are the one being interviewed, and these questions are for you to answer, then you alone must answer them, as best you...

What about /pae switch in boot.ini? Is that needed for AWE to be enabled?

There's just one instance of SQL Server on the box. It can handle 64-bit, which I think would be the way to go, but I'm not too excited about rebuilding...

This could be a problem..

BOL: "Support for AWE is available only in the Enterprise and Developer editions.."

I'd still like to hear some comments/suggestions..

You should also consider if a Technet subscription would fit your situation. They are not for production systems, just as trials that don't expire:

http://technet.microsoft.com/en-us/subscriptions/bb892759.aspx

The Technet Plus subscription includes...

laubenth (12/6/2008)

---

Do you know which part is slow? Are the first 6 fast and just the last 2 are slow? How fast are the queries? Can you capture them in...

cavo789 (12/3/2008)

---

Image two parameters : Country and the City.

If the user select "Belgium" in the Country Dropdown, then the SQL for City should be

SELECT City FROM tblCities WHERE Country=@Country...