Database Administrators
Profile Activity
Meta user
Network profile
vijayp
Summary Answers Questions Tags Badges Bookmarks Bounties Reputation All actions

85 Answers

Votes Activity Newest
52
How to insert or update using single query?
Jan 20 '15 at 13:29
10
Cannot attach the AdventureWorks database
Oct 3 '14 at 6:31
10
Multiple User Types - DB Design Advice
Sep 5 '14 at 13:19
8
Why is casting a string to DATETIME not accurate to the ms?
Nov 28 '14 at 7:43
5
Why SQL Server 2008 R2 do full installation for just adding another instance on the same machine
Oct 31 '14 at 6:57
5
SQL “select” query for getting 0 instead of null?
Sep 24 '14 at 9:31
5
Find Without primary key Table in SQL Server 2008 R2?
Sep 16 '14 at 13:36
4
How to update a column with values from the same newly inserted row in a trigger?
Nov 21 '14 at 3:39
4
Need help about giving relationships in database design
Oct 31 '14 at 11:16
4
Which one is better performance and (approach): store as rows or as a varchar column
Oct 21 '14 at 6:02
3
Database design: 4 types of users but have different functionality , separate or one table?
Nov 1 '14 at 4:44
3
Don't know how to transform variable entity into relational table
Oct 26 '14 at 6:24
3
Is SQL Server Thread Safe?
Sep 19 '14 at 9:38
3
Copy whole table to another database
Sep 15 '14 at 6:43
3
Get table name from union query?
Sep 10 '14 at 11:47
2
What's the structure of a matchmaking server?
Oct 11 '14 at 15:30
2
Which terms are used to refer a row in database?
Apr 17 '15 at 6:31
2
Viewing execution plans for queries with parameters
Mar 27 '15 at 10:29
2
Which one is best solution for future database structure?
Feb 19 '15 at 10:05
2
I can't create relationship in my database sql server
Jan 14 '15 at 9:16
2
Executed a Stored Procedure in the Production Server and the following warning message is shown
Jan 6 '15 at 5:59
2
Email address unique or primary key?
Dec 29 '14 at 5:04
2
Will a non-clustered index on a column with covering index on all the columns of table affect the Delete statement Records)?
Dec 26 '14 at 12:37
2
SQL Server Compact - Will it perform well with heavier traffic sites?
Dec 6 '14 at 4:11
2
Should I put common fields in each specific tables or one common table then join when data selecting?
Nov 28 '14 at 6:14
2
SQL Server 2008 R2 – Track Database Growth (Production Database)
Nov 1 '14 at 8:16
2
How to restore SQL Server 2008 R2 database to newly installed SQL Server 2008 R2 instance?
Oct 17 '14 at 3:32
2
Backup without using SQL Server Management Studio
Sep 19 '14 at 15:09
2
Why can't we access SQL Server when a long query is running in Management Studio?
Sep 10 '14 at 12:25
2
Best practice database design - user rating tables
Sep 7 '14 at 13:10
1
2 3