- Why do you think you need the cross join ??

- What's the relationship of that x-joined table to the other tables ?

did you read these good blog posts ?

By Jimmy May:

http://blogs.msdn.com/jimmymay/archive/2009/03/01/disk-i-o-microsoft-sql-server-on-san-best-practices-from-sql-cat-s-mike-ruthruff-prem-mehra.aspx

http://blogs.msdn.com/jimmymay/archive/2009/03/15/case-study-classic-case-of-san-over-subscription.aspx

just make sure they don't encrypt everything.

That would be total overkill !!

Every column that gets encrypted will be converted (implicit) to varbinary(max) !!

These columns cannot be indexed,....

Also mention, you...

veritas_86 (5/26/2009)

---

so I am creating a database where I have a parent table with multiple columns that I would like to have reference a single column in a child table....

at MS

- the general page: http://www.microsoft.com/sqlserver/2008/en/us/default.aspx

- "Upgrading to SQL Server 2008" msdn.microsoft.com/en-us/library/bb677622.aspx

Helps you with preparing and planning your migration

- "Microsoft SQL Server...

actually, you don't need another sql instance.

You might as well just create a new userdb (tools) and export your data from master to your userdb.

After that, it may be best...

Mayank Khatri (5/23/2009)

---

I would just run the S.P in ur management studio or Query analyzer window with taking off create S.P from ur query and assigning the @year value to...

can you post the DDL for [HSI].[usp_RaguTest_Reports] ?

"##report" is a global temp table that seems to be missing.

A separate instance seems the way to go, since you cannot exclude sysadmins authority, unless you are willing to pay the price of encryption.

And even then it is just a...

Thank you for the feedback.

By default sqlserver has a \backup folder in its installation directories.

It is being pointed to if you make a backup using the GUI (SSMS)

(object explorer / right click on the...

There are some other options :

from within sqlserver these settings can influence the number of cpus a query can use:

/* show the current settings */

exec sp_configure 'affinity mask' ;

exec...

I cannot see why simply posting the code is an issue ??

The error states you are trying to implicitly convert a NTEXT column !

from Books online SQL2000

varchar[(n)]

Variable-length non-Unicode character data...

DNA is right on top of your issue !

Golden rule is:

- pre-size your files as accurate as you can (prefer having to much allocated !)

- if autogrowth is enabled ,...

Off course SQLServer will only use multiple cpus if possible and needed.

If someone issues a query stating 'option (maxdop 2)' it will only use max 2 cpus to resolve that...