Can you please elaborate on this? I have not worked with data warehouses so am only somewhat familiar with how they work. What I am envisioning (with no...

Anye Mercy (7/13/2010)

---

Each job has its own database. The schema of an individual job database is about 98% the same between jobs, with a couple of tables that are...

sql will generate a new plan since the index that was there isnt there anymore

=========

http://lloydom.blogspot.com/

Can we get more details please

============================

blog: http://lloydom.blogspot.com/

yes actually i had that question with default settings in mind, but its good to see so many responses as i know it has actually set minds thinking and after...

. some of the fields in the table are of size greater than 8 kb and most times it cause page splits which causes slow performance.

. Normalizing a table without...

Thanks for the help guys

this is what i did i wrote a script that will search for the first occurence of the key word

'AS' and then replace that with 'AS'...

Hi Remi,

i could not understand the logic of your code, could you please explain it to me? sorry for being such a dud head.

Also how can the query be modified...

so graeme , did the suggestion work?

please let us know

This is the classic mm/dd/yy versus the yy/mm/dd format.

As steve jones said when you do a convert(variable,101) it will cast to a string and hence it will bring 12/31 which...