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
10 votes
2 answers
19k views

How to free the unused space for a table

5 votes
4 answers
16k views

Get object script in SQL Server via T-SQL?

4 votes
4 answers
15k views

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

17 votes
1 answer
8k views

Why can't we have multiple cascade paths?

1 vote
0 answers
5k views

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

5 votes
2 answers
5k views

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

0 votes
2 answers
5k views

Why shouldn't I increase SQL Server's timeout globally everywhere?

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?

20 votes
2 answers
4k views

Why these characters are all equal in SQL Server?

3 votes
1 answer
4k views

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

3 votes
1 answer
3k views

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

0 votes
0 answers
2k views

MariaDB Access denied for user 'root'@'192.168.80.4' (using password: YES) for some databases

3 votes
3 answers
2k views

PERCENT_RANK does not distribute over 100

5 votes
1 answer
2k views

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

1 vote
1 answer
2k views

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

0 votes
1 answer
2k views

Is it possible to select all columns but one column using SQL syntax?

0 votes
1 answer
2k views

Why SQL Server docker image uses high CPU all the time, and how to fix it?

6 votes
1 answer
1k views

Equivalent of a SQL Server schema in MySQL?

4 votes
2 answers
1k views

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

4 votes
1 answer
1k views

Why SqlBulkCopy gets slower by table's row count?

0 votes
2 answers
1k views

How to drop a procedure across a lot of databases (SQL Server 2016)

1 vote
1 answer
941 views

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

6 votes
3 answers
906 views

Why different datetimes freezes a query based on indexes?

0 votes
1 answer
892 views

Delete all data of all tables of all user databases in MariaDB

3 votes
1 answer
798 views

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

0 votes
0 answers
617 views

How to know why my query times out sometimes, but gets executed other times (random behavior)?

0 votes
0 answers
456 views

How to check a value is UUID in MariaDB?

0 votes
1 answer
445 views

Unable to translate Unicode character \\uDCC9 at index 5 to specified code page

4 votes
2 answers
357 views

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

5 votes
4 answers
299 views

How to select records from two tables transactionally