Skip to main content
Matan Yungman's user avatar
Matan Yungman's user avatar
Matan Yungman's user avatar
Matan Yungman
  • Member for 10 years, 6 months
  • Last seen more than 4 years ago
6 votes
Accepted

Get identity value of all rows inserted

4 votes
Accepted

Understanding SQL Server plan cache

4 votes

View scripts ran by a specific user?

4 votes

why the optimizer doesn't choose the optimal plan

3 votes

Single statement or batched delete?

3 votes

Easily give role in one database access to tables in another database on the same server

3 votes

What does a TRUNCATE TABLE write to the Log file in SQL Server?

3 votes

SSIS v/s Replication v/s logshipping

3 votes

Why is an entire index that is infrequently used stored in the buffer pool?

3 votes
Accepted

What SQL Server database version do I need?

3 votes
Accepted

Database structure for multiple users sharing one dataset, but also many users with their own dataset

3 votes

Having trouble with a query. DBMS Assignment

2 votes

Memory is not released after the execution stored procedure followed by a process end

2 votes
Accepted

How should I structure my time based index?

2 votes

View locks acquired during query execution (SQL Server)

2 votes

Migration from SQL Server 2012 Ent to SQL Server 2014 STD

2 votes

Replication monitoring refresher for distribution job affecting performance

1 vote

Is database performance optimization independent of the size of a database or a table?

1 vote

How to Create users in sql server for accessing only one database using Management Studio

1 vote

Drop & re-add subscribers to transactional replication

1 vote

Clustered Index / Index Oriented Table performance in join, worse than nonclustered?

1 vote
Accepted

What does <> mean in Relational Calculus?

1 vote

Why Model database in SQL Server is in FULL recovery mode

1 vote

Mathematical equality of two SQL statements

1 vote

What is the exact relationship between a database transaction and locking?

0 votes

Running Total: To store or compute