adspace


How many .ndf files can we create in Sql server 2005?

Answer Posted / anil kumar

32766

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I start sql server 2017?

1015


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

1499


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

1022


explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1132


Is it possible to have clustered index on separate drive from original table location?

1039


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

2293


Can you index views?

953


What is subquery? Explain the properties of a subquery?

1058


How to rebuild the master database?

1164


What is standby servers? Explain types of standby servers.

1078


What is the difference between upgrade and migration in sql server?

1183


What is sql server query analyzer?

1126


Can sql servers link to other servers like oracle?

915


What is normalization and what are the advantages of it?

1054


what is the difference between openrowset and openquery?

1192