Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
Aasim Abdullah's user avatar
Aasim Abdullah's user avatar
Aasim Abdullah's user avatar
Aasim Abdullah
  • Member for 11 years, 10 months
  • Last seen more than 3 years ago
44 votes
Accepted

How to determine the size of my tables in the SQL Server database

12 votes

Setting a SQL Server instance back to multi user mode

9 votes

VARCHAR primary key - MySQL

7 votes

Which one is better performance and (approach): store as rows or as a varchar column

6 votes
Accepted

This instance of (MS) SQL Server has been using a process id of X since dd/mm/yyyy

5 votes
Accepted

Indexed views on double linked server

4 votes
Accepted

What is difference between is_unique column and is_unique_constraint columns in sys.indexes

4 votes
Accepted

SQL Server Grant execute on all stored procedures without ddl permissions

4 votes

SQL Server : how to create user with access only from specific HOSTNAME or IP addres

4 votes
Accepted

DB_NAME(database_id) return null when executed through linked server

3 votes

Separate data from 1 column into multiple columns

3 votes

SQL Server stored procedure that would enforce atomicity?

3 votes
Accepted

SSIS - insert system date variable as a execute sql task parameter

3 votes
Accepted

MS-Access vba sql update where not working

2 votes

Explicit transactions for each DML query are necessary or not?

2 votes
Accepted

Unexpected empty result

2 votes

Does a database backup reduce size/increase free space of the log file?

2 votes
Accepted

Measuring DB time of application using SQL Server Profiler

2 votes

How to rollback when 3 stored procedures are started from one stored procedure

2 votes
Accepted

Discrepancy between system catalog view and sp_change_users_login?

2 votes
Accepted

Create nonclustered index on uniqueidentifier type

2 votes

Unable to connect to FTP server using "FTP Connection Manager"

1 vote

What does it mean when I see a lock in sys.dm_tran_locks and there's no matching row in sys.dm_exec_requests?

1 vote

I can't find the problem?

1 vote

TSQL substitute for MAX() string ranking

1 vote
Accepted

Timestamp columns in Peer to Peer Replication

1 vote

Abnormal PREEMPTIVE_OS_AUTHENTICATIONOPS Waits

1 vote

What significance does an index_id < 256000 have?

1 vote

MS Access Query to update

1 vote

Additional space required for INDEX REORGANIZE