Hi Venki

No silly question 😉

Just execute following line in SQL Server Management Studio (or Query Analyzer):

PRINT @@VERSION

Greets

Flo

Here you can see a comparsion of SQL Server 2005 versions:

http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx

I would advice to ask your manager for the Developer Edition. Here is the pricing:

http://www.microsoft.com/sqlserver/2005/en/us/pricing.aspx

... it contains all features of...

Ouch! So sorry for my wrong information... I never did use so I never noticed 😉

Thanks to Justin!

Flo

No this should not be a performance problem.

I would advice you to avoid "sp_" and "fn_". Microsoft is using this prefixes and you may run into ambiguous name problems if...

A perfect article about on the fly/high performance splitting would be this article of Jeff Moden:

http://www.sqlservercentral.com/articles/TSQL/62867/

Greets

Flo

Babar Javaid (3/18/2009)

---

Does this mean that i need to write my business logic in the sql and return only result set to the web server that need to forward to...

Which development language? win-apps or web-apps?

Hi Bruce

I complete confirm you! 🙂

I just thought about my own project. It's an 9 year old monster with over 80 processes and apps in c/c++/c#/java/vb/workflows and it's almost impossible...

Hello Bruce

Absolutely correct! The question just is...

timothyawiseman (3/17/2009)

---

Bruce W Cassidy (3/17/2009)

---

[font="Verdana"]The best way is to use gateway stored procedures to handle your inserts and updates. So they can insert and update into the various tables...

The best way to do the formatting...

Hi everybody

I'm one of the Devs but I definitely have to agree to your statements. Sometimes I see code (or here about performance) of other people, also within my company,...

By my knowledge, the software either requires SQL Server 2005 or has to run in SQL Server 2000 compatibility mode.

If you running SQL Server 2000 since now, you should consider...

Off topic

Wow... I'm currently starring at my previous posting.

SQL scripts look quiet funny if created with SQLPrettifyer since forum update this today. 😀

Hi

A Form, a ComboBox, a Button:

private void button1_Click(object sender, EventArgs e)

{

...