Dave,

I do agree with you and its OK to enable /3GB switch on server with less than 16GB memory. Its what recommended by M$ as well. I'd say the 3GB...

Hi Dave,

I've done this settings once too many times and not ever encounter any issue. Where's the place where you add the switch?

Below is the snippet of boot.ini from one of...

Hi ricwid,

I didnt say and dont believe the dynamically configure was the cause of problem too. I just didnt agree on fixing the memory as per your advice because its...

SQLGuru,

when you hit this issue, it means something is already wrong with your sql server whether its fixed or dynamic. do you mean if you fixed the memory, you'll avoid...

Kaushik,

Are you trying to look at what stored procs are available in the cache buffers?

Not sure if you're trying to look for this

select * from master..syscacheobjects

Simon

rickwid,

Based on the info given by AlexSQLForums, i dont think its necessary to fix the sql memory in his case. Its a dedicated SQL server and AWE is not being...

Karthik,

Based on my experience, giving a definition for hash join, merge join, nested loop join isnt usually very hard. but if you really wanted to impress your interviewer, you should...

Hi Karthik,

I was just guessing that they're from Sybase background because 2 of their questions catches my eyes.

Their 3rd question on "cartesian product" in view is not a typical question...

I guess i'm trying to summarise the answers here. i'd reckon the answers could vary.

1. Tell me about Physical read and logical read and give me an example.

which value would...

Steve,

Not to mention also there are now standard reports that comes with SQL2005 that allows shows server activities (CPU, memory, etc) on the server. SQL2005 SP2 even lets custom reports...

John,

Apparently your server config does only allows you to use the memory up to 2GB for the SQL.

AWE should not and will need not to be enabled for any...

Oh yes, by the way, I was talking to M$ in regards to the blog article and below was a copy and paste from part of our correspondence:

2nd...

Just to make things clear in regards to 64-bit and AWE, I've checked multiple times with M$, all answers are nonono, do NOT do it, its unnecessary. If you get performance...

Right on, mate. and I was pretty sure on this because I personally spoke to the program manager (who code the SQL 2005 storage allocation) at M$ saying SQL...

i go agree with your disk theory, and i'm not confused about Gbps and GB bytes. it sounded to me your point of view are from hardware/disks perspective and mine...