user avatar
user avatar
user avatar
vijayp
  • Member for 7 years, 10 months
  • Last seen more than a month ago
59 votes

How to insert or update using single query?

12 votes
Accepted

Multiple User Types - DB Design Advice

10 votes

Cannot attach the AdventureWorks database

8 votes
Accepted

Why is casting a string to DATETIME not accurate to the ms?

5 votes

How to update a column with values from the same newly inserted row in a trigger?

5 votes

Why SQL Server 2008 R2 do full installation for just adding another instance on the same machine

5 votes
Accepted

Find Without primary key Table in SQL Server 2008 R2?

5 votes
Accepted

SQL "select" query for getting 0 instead of null?

4 votes
Accepted

Need help about giving relationships in database design

4 votes
Accepted

Which one is better performance and (approach): store as rows or as a varchar column

3 votes

Don't know how to transform variable entity into relational table

3 votes

Database design: 4 types of users but have different functionality , separate or one table?

3 votes

Is SQL Server Thread Safe?

3 votes

Copy whole table to another database

3 votes

Get table name from union query?

2 votes

Why can't we access SQL Server when a long query is running in Management Studio?

2 votes

Best practice database design - user rating tables

2 votes

SQL Server Create Database File Error

2 votes

Backup without using SQL Server Management Studio

2 votes
Accepted

SQL Server 2008 R2 – Track Database Growth (Production Database)

2 votes

Sql Server Management Studio can't remember passwords

2 votes

Will a non-clustered index on a column with covering index on all the columns of table affect the Delete statement Records)?

2 votes

Email address unique or primary key?

2 votes
Accepted

Executed a Stored Procedure in the Production Server and the following warning message is shown

2 votes

I can't create relationship in my database sql server

2 votes
Accepted

What's the structure of a matchmaking server?

2 votes

How to restore SQL Server 2008 R2 database to newly installed SQL Server 2008 R2 instance?

2 votes

SQL Server Compact - Will it perform well with heavier traffic sites?

2 votes

Which one is best solution for future database structure?

2 votes

Viewing execution plans for queries with parameters