druzin's user avatar
druzin's user avatar
druzin's user avatar
druzin
  • Member for 11 years, 1 month
  • Last seen more than 2 years ago
24 votes

How to JOIN two table to get missing rows in the second table

11 votes

Slow delete caused by many foreign keys

10 votes
Accepted

Multiple like conditions for same column?

8 votes

COUNT of rows with parent id equal to the row we have with a parent id of 0 in one query

7 votes

Should I create an enumeration or individual flags?

7 votes

SELECTing multiple columns through a subquery

7 votes
Accepted

How do I validate all my constraints in postgresql?

7 votes
Accepted

Selecting rows from same name table from multiple databases in single result set

6 votes

Can I copy the table structure of a #temp table to a new physical table?

5 votes
Accepted

Triggers on Insert or Update SQL Server (Spatial)

5 votes

Alternative to WHERE clause

5 votes
Accepted

How to display the query result separately for each item in an IN clause?

4 votes

Large update taking too long; looks like it is updating more records than I have

4 votes
Accepted

Conditional WHERE Clause in a Table Valued Function

4 votes

Using dynamic sql inside Oracle stored procedure

3 votes
Accepted

Is it better to add an index and search via the index or add a unique constraint and let an insert fail?

3 votes

View column has an 8000 character limit?

3 votes

Stored Procedures under Source Control, best practice

3 votes
Accepted

can I use many-to-many relation with weak entity

3 votes
Accepted

Using Oracle Datapump when target table has additional column

2 votes
Accepted

How to get a column of the select to be "cumulative" (like in excel)?

2 votes
Accepted

Backup throws permission error

2 votes
Accepted

Unique Constraint with multiple null columns

2 votes
Accepted

How to generate create table script without primary and foreign key in Oracle

2 votes
Accepted

Stored procedure performs worse than straight query

2 votes

I can't connect to an instance of SSMS from other servers SSMS

2 votes

Storing file into oracle db

2 votes
Accepted

capture output of table-valued function

2 votes

How to modify an update in Oracle so it performs faster?

1 vote

Avoiding Multiple Queries when Searching for Records Associated with a Set of Records