adspace


Can a table be moved to different filegroup?

Answer Posted / Anjali Singh

Yes, a table in SQL Server can be moved to a different filegroup using the ALTER TABLE command.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you append an identity column to a temporary table?

1071


How to rebuild the master database?

1167


What is temporary table in sql server? Why we use temp table?

1023


Why we use the openxml clause?

1080


What kind of problems occurs if we do not implement proper locking strategy?

1501


Can we shrink data file in sql server?

1130


Does view occupy space?

1022


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1024


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2296


How to convert numeric expression data types using the cast() function?

1151


What is acid mean in sql server?

1247


When should you use an instead of trigger?

1054


What is the difference between for xml raw and for xml auto?

1119


What is an indexed view?

1023


what is the Ticketing tool used in Wipro technologies at Bangalore...???

8232