in which situation you received this error ?

if you need some books you can read "MS SQL Server Step by Step: Analysis Services" and ""MS SQL Server Step by Step: Reporting Services"

BIDS has some limitations but you can install Express version of Visual Studio (it is free software)

guys are right!

on separete machines you can only install client tools ;////

hi MrT-SQL, please give us some more information:

- single row size in these table ?

- do you need that (id,date) index? maybe better will be (date,id) ?

- how are checking...

GilaMonster - good point!

Paul ant others - there is a great webcast about "max memory" settings: http://www.sqlbits.com/Agenda/event3/A_walk_down_memory_lane/default.aspx

Sergiy (9/7/2009)

---

Marcin Gol [SQL Server MVP] (9/7/2009)

---

Sergiy - the paragraph you mentioned change nothing. hash is a hash - and for a given string should always return the same value....

hi

there are some backup settings that you can use to be sure that your backup is ok 😉

1) checksum

BACKUP DATABASE TO DISK = WITH CHECKSUM

BOL about checksum:

CHECKSUM

Enables...

if you need you may stay play with this index - but you should set a proper fillfactor and maybe padindex;

if you dont need clustered index there - you...

how many rows you were inserting ? 1 or 1 milion ?

changing collation is a VERY complex subject:

1) differences between server/database collation will cause errors

2) after altering column collation you will only change collation for new rows - old will still...

what about virtualization ? you can do simple P2V (physilcal to virtual) you will get EXECTLY same machine. It is a very good solution for testing and so on..

thnx drew :)))

so the question is - i have a very big number of rows in my report - and i got a "out of memory exception" what should i...

maybe there is a problem with "." and "," - last week i was geting some strange errors during import a numeric data.

my column has dot instead of comma ;///...