Trending SQL Server Discussions

Which tool Should I use for SQL Database Recovery as there are so many available?‎

There are so many tools available but deciding the right software will save you time and money. So select a SQL repair tool that is easy to use, recover all database comp‎ ... See More

Answers:

6

Followers:

6

Views:

176

Vote Count:

0

If you have a table in your Database and there is a duplicate values in it How we can delete one raw of each duplicated rows?‎

Answers:

17

Followers:

18

Views:

43

Vote Count:

1

What is the difference between IS NULL operator and ISNULL() function?‎

Answers:

11

Followers:

12

Views:

30

Vote Count:

1

What is the default size of SQL Server Database?‎

Answers:

10

Followers:

9

Views:

32

Vote Count:

0

Do you know how to count duplicate values in sql ?‎

Answers:

48

Followers:

50

Views:

1275

Vote Count:

3

What would be your preference to use global or local temp table in store procedure and why?‎

Answers:

3

Followers:

4

Views:

86

Vote Count:

1

Is SQL language is same for all the RDBMS like SQL Server, Oracle, Sybase, etc?‎

Answers:

10

Followers:

14

Views:

1624

Vote Count:

5

Started a db backup at 10.10 AM & required 20 min for completion. @10.25 AM we inserted few rows in a table. Will new data be there in backup db? ‎

Answers:

8

Followers:

8

Views:

275

Vote Count:

0

Write a query to find second highest salary of an employee?‎

Answers:

5

Followers:

5

Views:

123

Vote Count:

0

What is Replication and Database Mirroring?‎

Answers:

15

Followers:

18

Views:

2194

Vote Count:

2