What is stopping you not to have a normalization, any business rule/your supervisor/anything? A table with non cluster index is called heap which will have many draw backs like fragmentation...

You may please look into the below likn:

http://msdn.microsoft.com/en-us/library/ms179855.aspx

only4mithunc (9/7/2011)

---

Hi All,

I know that there are two types of temp table local and Global ( singe and double # ) , and I know that local temp table is...

Ohhh Okei, I was not able to find a relation. Thanks for correcting me. My sincere apologies .I own my mistake.

As Grant suggested these are two separate . However you can think for something to get a relation...

Select A.name,OBJECT_NAME(A.parent_object_id),key_index_id,B.type_DESC From sys.foreign_keys a

INNER JOIN sys.indexes b oN a.parent_object_id = b.object_id AND...

When you make a computed column as persisted, it would consume more space in disk. If Persisted property is off then calculated column will be just a virtual column. No...

SELECT ROUND(((99999999 - 1000 -1) * RAND() + 1000), 0) ,ROUND(((99999999 - 1000 -1) * RAND() + 1000), 0)

Is this something you are looking for? Why do you want to...

If the statistics are not up to dat due to massive data skew in your large indexes, the rebuild index will not parallelize properly.

I would recommand you to update the...

Hi SQLSavy, here is a document for you.It would help you start with your preparations.

http://blogs.msdn.com/b/sqlcat/archive/2008/12/08/ultimate-guide-to-upgrading-to-sql-server-2008.aspx

As Grant suggested always do the maintenance activities like stats update, defrg, rebuild at the slowest time of your day, even taking the system down for some time for the...

Sorting will not be 100% ALWAYS unless you provide with an ORDER by.

You can force the index using option. However its not advicable to do so until you are very sure of the same. (I always believe SQL will do better job...

Did you check the test connection in ODBC driver? If not please test that first and try executing the same.

Few Questions...

1. How many records are there in the table?

2. Why cant you have only order_total alone in the included and see the usage of index rather than giving all...

Is this the below you looking for:

create Table tblEMPLOYEE

(ID int, FIRSTNAME Varchar(50))

Insert into tblEMPLOYEE Values( 1,'John')

Insert into tblEMPLOYEE Values( 2,'Lee')

create Table tblTRAINMODULE

(ID int, MODULE_NAME Varchar(50))

Insert into tblTRAINMODULE Values(...