|
|
-
mrajesh Learned 2 Years ago through Just Learned
Assume that there are two tables table1 and table2 which have same structures and table1 has 10 millions rows and you want to move all rows from table1 to table2. The quickest method that I have learnt is to use Partition Switching
[code]
alter table...
|
-
mrajesh Liked 2 Years ago through Just Learned
Assume that there are two tables table1 and table2 which have same structures and table1 has 10 millions rows and you want to move all rows from table1 to table2. The quickest method that I have learnt is to use Partition Switching
[code]
alter table...
|
-
mrajesh Learned 2 Years ago through Just Learned
Assume that there are two tables table1 and table2 which have same structures and table1 has 10 millions rows and you want to move all rows from table1 to table2. The quickest method that I have learnt is to use Partition Switching
[code]
alter table...
|
-
mrajesh Liked 2 Years ago through Just Learned
Assume that there are two tables table1 and table2 which have same structures and table1 has 10 millions rows and you want to move all rows from table1 to table2. The quickest method that I have learnt is to use Partition Switching
[code]
alter table...
|
-
mrajesh Commented 2 Years ago through Blogs
Query 2 : select top 1 1 from syscolumns,syscolumns where 1=1...
|
-
mrajesh Commented 2 Years ago through Blogs
Query 2 : select top 1 1 from syscolumns,syscolumns where 1=1...
|
-
mrajesh Liked 2 Years ago through Blogs
Table and Database designers
and uncheck......
|
-
mrajesh Liked 2 Years ago through Just Learned
When I viewed the code written by co-worker, I found this. To find sales made in 2009, the where clause was written as
[code]
Where year(sales_date)=2009
[/code]
But beware that this will not make use of index available on sales_date column. The ef...
|
-
mrajesh Learned 2 Years ago through Just Learned
When I viewed the code written by co-worker, I found this. To find sales made in 2009, the where clause was written as
[code]
Where year(sales_date)=2009
[/code]
But beware that this will not make use of index available on sales_date column. The ef...
|
-
mrajesh Liked 2 Years ago through Just Learned
When I viewed the code written by co-worker, I found this. To find sales made in 2009, the where clause was written as
[code]
Where year(sales_date)=2009
[/code]
But beware that this will not make use of index available on sales_date column. The ef...
|