Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frallbert
Starting Member
1 Post |
 Posted - 2010-01-19 : 15:00:42
|
| Hi,Im new to SQL server but i have worked many years with Oracle db. And i have a few questions that i hope that someone can help me with.1. We have some preformance issues in a sqlserver 2005 and im thinking of implementing partitioning and is this possible to achive without Enterprise ed? 2. In oracle you can truncate a specific partition and work only with one partition if you want for example select * from tab1 partition(p_20091201) and you will get only the data in the partition is this possible in SQLserver.3. An alternativ to partitioning in Oracle is to use partitioning views and what I understand is this possible also in SQL-server?4. In Oracle you can use hints for example in insert statments you can use /*+ Append */ then you write pass some buffers and the insert statements is much faster. Is there any simular thing in SQL-server?5. In oracle pl/SQL you can use bulk collect and then make a bulk insert from one table to another is this possible in TSQL? Anyone has any examples of this?many questions at one time :-)Thanks!/Lasse |
|
|
|
|
|
Questions about SQLserver 2005