This is a discussion Forum, all opinions are welcome. Care to share why not?

LIKE

Equals (=)

Both are used for comparisons.

This makes no sense:

And neither does what you tried to do:

Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1[/url]

Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2[/url]

Creating a 2 Node SQL Server 2008 Virtual Cluster Part...

It should be painless, should be. I have installed SQL 2005 SP4 many times and never had an issue, but know that it is not uninstallable, so your rollback plan...

jitendra.padhiyar (4/27/2012)

---

Thanks a lot.

For testing purpose I have Windows server 2008 Standard version too on my virtual machine with SP1. And I think it also does not support clustering. Bcos...

Your Version (Windows Server 2003) supports Clustering, but your Edition (Standard) does not:

Comparison of Windows Server 2003 Editions

If you stay with Server 2003 you would need to upgrade to the...

My guess is the VIEW is defined WITH SCHEMABINDING, meaning it has a link to the referenced table in the metadata and SQL Server ensures you cannot drop the underlying...

Sean Lange (4/27/2012)

---

I have worked with a few EAV systems in the past and I can tell you from my experience I would run away from this as fast as...

Tripz (4/27/2012)

---

Hi,

Thank You for the suggestion of using AND instead of WHERE in the LEFT JOIN, I updated my sp with those changes and the stored proc execution time reduced...

These three give the same result:

USE AdventureWorks2008R2

GO

SELECT sp.BusinessEntityID AS BusinessEntityID,

CASE WHEN sp.TerritoryID IS NOT NULL THEN e.OrganizationLevel

...

:w00t: yikes! Are you just writing this code and are done with the project, or do you also have to support the system after it is in production? Rethink, redesign!

mark.tait (4/27/2012)

---

Once again, thank you - I can understand the reasoning - and I suppose granting rights to insert/delete table data, opens you up to sql injection (something else I've...

dwilliscp (4/27/2012)

---

I found the following on MS site (http://msdn.microsoft.com/en-us/library/ms178067(v=sql.90).aspx)

"Allowing SQL Server to use memory dynamically is recommended; however, you can set the memory options manually and restrict the amount of...

From msdn

Server Memory Options

Use max server memory to prevent the SQL Server buffer pool from using more than the specified amount of memory, thus leaving remaining memory available to start...

dwilliscp (4/27/2012)

---

My boss states that he has always seen that you have to set the SQL server to Max RAM.. does anyone know of any links from MS (MSDN) that...