User JP Chauhan

20 votes

Taking backup of all the databases in SQL Server

answered Jul 30, 2012 at 7:10

9 votes

SQL Server: Should we use TCP or Named Pipes or use the default?

answered Sep 12, 2012 at 11:30

9 votes

Accepted

Cannot connect to my local instance

answered Jul 30, 2013 at 7:10

9 votes

How to solve the error Msg 547, Level 16, State 0, Line 1

answered Apr 3, 2014 at 11:05

6 votes

How to select distinct for one column and any in another column?

answered Sep 14, 2012 at 19:08

6 votes

COUNT and SUM at the same time after removing duplicate rows

answered Sep 6, 2012 at 6:58

5 votes

Accepted

Backup plan for MySQL NDB cluster databse not innoDB

answered Jul 22, 2013 at 7:49

4 votes

Scalability: Desiging a message table

answered Jul 8, 2013 at 12:24

4 votes

Can anyone describe the step by step process of recovery , backup and restore in sql server

answered Aug 10, 2012 at 9:15

3 votes

Accepted

How do I create a rule for a Primary Key

answered Aug 21, 2012 at 5:42

3 votes

Accepted

SQL Server 2008 user, group, or role already exists in the current database

answered Aug 6, 2012 at 10:00

3 votes

Setting up SQL Server 2008 R2

answered Aug 8, 2012 at 5:57

3 votes

Sql server 2008 filestream maximum number of rows

answered Jul 19, 2012 at 9:39

3 votes

Single query to copy data from 3 tables into a single empty table

answered Jul 24, 2012 at 10:28

3 votes

How can I change the names of all tables to uppercase?

answered Mar 25, 2014 at 11:09

2 votes

Accepted

DayOfYear as per Indian fiscal year

answered Jan 11, 2016 at 7:00

2 votes

Shrink transaction log while transaction in progress

answered Jun 13, 2013 at 8:47

2 votes

How can place SQL Server online on the internet?

answered Aug 24, 2012 at 14:14

1 vote

Fix for orphan user 'guest'?

answered Aug 16, 2012 at 10:03

1 vote

single select vs multiple selects using limit and offset

answered Jul 31, 2012 at 9:33

1 vote

Query taking too long to execute

answered Jul 22, 2013 at 12:39

1 vote

Agent Xps getting disabled automatically

answered Feb 24, 2014 at 9:14

0 votes

DMV queries for capturing most frequently used queries and worst performing queries

answered Mar 12, 2014 at 10:09

0 votes

MongoDB: how to get the all the embedded data?

answered Sep 26, 2014 at 14:23

0 votes

Fetch column data against group by data

answered Nov 9, 2015 at 11:54

0 votes

SQL server level permissions

answered Jul 26, 2013 at 10:27

0 votes

SQL Server Table Backup

answered Feb 20, 2014 at 9:49

0 votes

What type of SQL Server Replication fits our scenario? Merge or Transactional?

answered Mar 19, 2013 at 7:52

0 votes

SQL Server 2008 R2 High CPU

answered Jul 26, 2012 at 12:49

0 votes

How does the database decide which Index to use

answered Jul 26, 2012 at 5:26

Stack Exchange Network

36 Answers

Taking backup of all the databases in SQL Server

SQL Server: Should we use TCP or Named Pipes or use the default?

Cannot connect to my local instance

How to solve the error Msg 547, Level 16, State 0, Line 1

How to select distinct for one column and any in another column?

COUNT and SUM at the same time after removing duplicate rows

Backup plan for MySQL NDB cluster databse not innoDB

Scalability: Desiging a message table

Can anyone describe the step by step process of recovery , backup and restore in sql server

How do I create a rule for a Primary Key

SQL Server 2008 user, group, or role already exists in the current database

Setting up SQL Server 2008 R2

Sql server 2008 filestream maximum number of rows

Single query to copy data from 3 tables into a single empty table

How can I change the names of all tables to uppercase?

DayOfYear as per Indian fiscal year

Shrink transaction log while transaction in progress

How can place SQL Server online on the internet?

Fix for orphan user 'guest'?

single select vs multiple selects using limit and offset

Query taking too long to execute

Agent Xps getting disabled automatically

DMV queries for capturing most frequently used queries and worst performing queries

MongoDB: how to get the all the embedded data?

Fetch column data against group by data

SQL server level permissions

SQL Server Table Backup

What type of SQL Server Replication fits our scenario? Merge or Transactional?

SQL Server 2008 R2 High CPU

How does the database decide which Index to use