Skip to main content
Saeed Neamati's user avatar
Saeed Neamati's user avatar
Saeed Neamati's user avatar
Saeed Neamati
  • Member for 11 years, 9 months
  • Last seen this week
  • Tehran, Iran
20 votes
2 answers
4k views

Why these characters are all equal in SQL Server?

17 votes
1 answer
8k views

Why can't we have multiple cascade paths?

10 votes
2 answers
19k views

How to free the unused space for a table

6 votes
1 answer
1k views

Equivalent of a SQL Server schema in MySQL?

6 votes
3 answers
905 views

Why different datetimes freezes a query based on indexes?

5 votes
3 answers
4k views

How to change primary key's data type from int to bigint in a huge transactional database under tremendous load?

5 votes
1 answer
2k views

The backup of the file or filegroup "fileStream" is not permitted, because it is not online

5 votes
4 answers
16k views

Get object script in SQL Server via T-SQL?

5 votes
4 answers
299 views

How to select records from two tables transactionally

5 votes
2 answers
5k views

Do varchar(max), nvarchar(max) and varbinary(max) columns affect select queries?

4 votes
4 answers
15k views

SQL Server Management Studio (SSMS) is way too slow in its GUI

4 votes
2 answers
1k views

How to enforce data consistency across one-to-one relationship in an inheritance hierarchy

4 votes
3 answers
185 views

VLDB is stuck in recovery state. It's a permission issue, now what should I do?

4 votes
1 answer
1k views

Why SqlBulkCopy gets slower by table's row count?

4 votes
2 answers
356 views

Why is the result of a totally deterministic and all-encompassing "case" in select query in view nullable?

3 votes
1 answer
3k views

Exclusively access a table and prevent other queries, even read queries

3 votes
1 answer
4k views

Why and for what possible reasons 'sa' gets locked?

3 votes
1 answer
798 views

Is there a way to determine locks that a given query might apply on SQL objects?

3 votes
3 answers
2k views

PERCENT_RANK does not distribute over 100

2 votes
1 answer
103 views

Find duplicate subscriptions in SQL Server

1 vote
1 answer
109 views

Stuck at optimizing "not in clause" for a medium-sized query across two tables

1 vote
0 answers
5k views

SQL Server Management Studio times out connecting to a remote SQL Server engine

1 vote
0 answers
79 views

Why on the VPS, uuid() is wrapped in a single quote?

1 vote
0 answers
36 views

How to design for scalable set operations?

1 vote
1 answer
201 views

How to DRY record metadata in SQL Server

1 vote
1 answer
2k views

SQL Server unique index, per subset of data, based on values of another column

1 vote
1 answer
53 views

How can I get duplicate entry error on a table that only has one record?

1 vote
1 answer
48 views

How to solve this problem for hierarchical data structure?

1 vote
1 answer
939 views

What cons should I consider if I put index on every UUID column in my database

0 votes
1 answer
77 views

Considering that we don't want logs, what files should I put into my MariaDB's file-based backup plan?