Hi dickersonka,
Thanks for the info. If you don't mind me asking, how many connections does your VMs get on average and how big are your databases? I'd like to know, because our connections will...

Has anyone moved their SQL Server's into a virtual environment using VMware? If so, what has your experience been like?

thanks,
GM

You really didn't need to create a new thread since this still relates to your previous one.

Looking at the error message about NOLOCK, I came across this article from Microsoft http://support.microsoft.com/kb/815008. But, this is for SQL Server 2000, which you said you are using 2005....

Sounds more like you need to update the existing records that have a group id of 7 and change those to 12, but if you need both groups to be related to the same products as ID 7, then an insert...

I remember with SQL Server 2005 Express, Microsoft had a separate install package that did not include the Full-Text support. You may want to check for a SQL Server 2008 package that includes...

Personally, I would refrain from using any data transformations in this manner. Changing the data being inserted by the user does comply with the check constraint, but it alters what the user is...

Ramy's and MSI's solutions work perfect if you have to use the LIKE clause, but DATETIME data types need to be handled differently. I would recommend not using the LIKE clause and going with the SQL...

I haven't ever looked at creating constraints yet, most of my time has been looking at maintenance plans. So this is still new to me, but all of the examples I have seen are a static pattern. None...

If your table has multiple records per employee as in

EmployeeID, EmployeeName
------------------------------------
12345, John Smith
12346, Jane Doe
12345, John Smith
12347, Bob Smith

You...

Take a look at the PIVOT command in Books Online.

Most likely you will not be able to do this using a simple insert or update sql statement, so you will need to create a stored procedure to handle this task. I'm not exactly sure what functions exist...

If you have any basic questions, most of them can be answered by reading SQL Server's Books Online at http://msdn.microsoft.com/en-us/library/ms130214.aspx. This is a must have for anyone working...

Using the like constrait with '%00' would work for this sample, but would still require the human eye to make the associations with each possible duplicate. I'm not exactly sure what the solution...

In both SQL 2000 and 2005 you can run this query using the information_schema.columns

SELECT
data_type,
column_name
FROM information_schema.columns
WHERE table_name = 'table'

This...

This is just a suggestion, but you might want to normalize that table into two separate tables: TicketMaster and TicketMessages.

TicketMaster
id (int)
inserted (smalldatetime)
lastUpdated...

It is rare that you would want to give someone complete access to all the objects pertaining to a schema. An example would be the HumanResources schema which has sensitive material that not all...

I'm not sure if this will help your case but from what you are asking it sounds like you want to group records based on an attribute and determine the maximum value of each attribute.

If you have...

But 2005 allows you to grant users the right to run SQL statements to individual schemas. I do understand that schemas are collections of database objects, but it seems SQL 2005 is mixing the...

In this example I'm using the AdventureWorks database in MS SQL Server 2005

I was wondering what other people thought about Schemas vs. Roles when it comes to security access. If you have an...

For Artificial Intelligence

Book Title: Programming Game AI by Example (Paperback)

http://www.amazon.com/Programming-Game-Example-Mat-Buckland/dp/1556220782

For Everything Game Development
...

I agree that Allegro is an awesome API for 2D gaming. I'm using Allegro and FMOD together to create a simple Mario clone. I've just started using FMOD, but I have been using Allegro for a while now...

I've ran into that GridView bug with sorting data. My fix was to create a global variable boolean data type for the page and then just toggle it whenever the event was shot off. Just like you said...

I've searched every where for any code examples for a manual sorting routine, but the only ones I can find are in C#. I've been able to convert it into its VB counterpart, however I'm having trouble...

Actually this doesn't fix what I'm working with. However it does fix that extra line that is created when hitting the enter key. We had another fix, which is to change the style to use word 2003...

I noticed that I can also default that setting for future documents.

Thanks I'll try it out.

Hey Narue,

Where does the pointer exist once it has been created, in RAM or the CPU?

The problem that I am facing is that Word 2007 is adding spaces in a mail merge when there isn't a value from an excel document.

<<FirstName>> <<MiddleName>> <<LastName>>

I've placed spaces in...

I agree that AJAX alone isn't for database access, but ASP.NET + AJAX makes for some great interactive online forms to work with databases.


ShawnCplus, you are correct about using C++ for CGI....

If you are any good at Python than I would recommend Blender. I have been using Blender for the past two years and really like the program. I would have to agree with the others that it comes down to...

You might also want to check for any updates for the game.

If you are going to be a MySQL admin or developer you will need to familiarize yourself with their website. You can find the install for MySQL Community Server (free version) and it's documentation....

I may be wrong but I've never heard of C++ being used for the web. Unless its for some web app DLLs and not server side scripting. C# would be something you'd use, which isn't a variation of C or...

That does make since for accuracy calculations to be executed first before damage is even considered.

A game editor or level editor allows you to place objects within your world like trees, houses, skybox and terrain. If you ever played Dark Cloud you earn "objects" and can place them within the...

I've only been using ASP.NET mostly for web apps and there are some great things coming out of AJAX. One of the cool things about AJAX is that it allows you to set a portion of the web page to update...

Well if you are only focused on creating puzzles or word games, that road isn't so long. If you were going to create something that has a bunch of movement, graphics and sounds, that would be...

I would really like for this thread to discuss all aspects of "RPG math" i.e.(Attack, Magic, Defense, Magic Defense, Agility, etc...)

So lets start off with Attacking. I am going to dismiss what...

So is the second line a re-allocation of the queue?

I think it is pretty said that I am finally getting around to what 1o0oBhP was pointing me to back in 2005. I have been looking into data structures using linked lists, binary trees and B-trees...