That's exactly what I do, any that just can't be moved for whatever reason, I consolidate to a centralised instance. Make 2...

Character set conversions! In fact Unicode and instance version may have a bigger effect, I may well be wrong...

presumably your Windows page file occupies the C drive also?

Ola's scripts are indeed great, Michelle Ufford over at SQLFool[/url] also has a great index maintenance script. Check them both out and go with whichever you prefer!

you may upload the report via the report manager website!

have you profiled the database to ascertain why data retrieval is slow?

how many rows do the tables hold when performance is slow?

what indexes have been implemented to aid data retrieval?

MonsterRocks (11/14/2010)

---

declare @x1 varchar(10)

declare @x2 decimal(38,7)

set @x2 =22225655.95163

set @x1=convert(nvarchar,@x2)

set @x2=convert(decimal(38,7),@x2)

print @x1

its output is 22225655.9

wht shud i pit in scale if i want to display 7 digits...

Use the following to pre size the primary data file

alter database MYDB modify file (name = MDFLogicalFileName, size = SizeInMBorGB)

e.g. size = 100MB or size = 100GB

to check the last\current id column value used execute the following query

dbcc checkident('tablename', noreseed)

casting binary or varbinary can be unreliable depending on the collation, you would probably want to use sys.fn_varbintohexstr

The best method is detailed at this link and converts to all bases

switch to bulk logged rather than simple recovery, alter index rebuild is minimally logged in this mode too!

download my guide at this link and check section 4.2 "add a cluster node".

If you look closely at the installer you'll see 2 options, one for create a new SQL server failover cluster and one for add a node to a SQL server...

with all that's mentioned here, this is why you test before migrating Live. Check with internal devs\vendors whether they support the RDBMS platform or not!

One thing that can issues between...

not problematic, but does require downtime of the other nodes in order to patch the new passive...