Skip to main content
Aasim Abdullah's user avatar
Aasim Abdullah's user avatar
Aasim Abdullah's user avatar
Aasim Abdullah
  • Member for 11 years, 11 months
  • Last seen more than 3 years ago
1 vote

Abnormal PREEMPTIVE_OS_AUTHENTICATIONOPS Waits

1 vote
Accepted

Timestamp columns in Peer to Peer Replication

4 votes
Accepted

DB_NAME(database_id) return null when executed through linked server

0 votes

Automatic database restore fails as cannot find file

1 vote

MS Access Query to update

1 vote

What significance does an index_id < 256000 have?

4 votes

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

2 votes

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

2 votes
Accepted

Create nonclustered index on uniqueidentifier type

2 votes
Accepted

Discrepancy between system catalog view and sp_change_users_login?

6 votes
Accepted

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

1 vote

TSQL substitute for MAX() string ranking

2 votes

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

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?

4 votes
Accepted

SQL Server Grant execute on all stored procedures without ddl permissions

1 vote

I can't find the problem?

4 votes
Accepted

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

1 vote

Steps or evaluation order of the SQL statement

3 votes
Accepted

MS-Access vba sql update where not working

3 votes
Accepted

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

44 votes
Accepted

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

3 votes

SQL Server stored procedure that would enforce atomicity?

12 votes

Setting a SQL Server instance back to multi user mode

9 votes

VARCHAR primary key - MySQL

2 votes
Accepted

Measuring DB time of application using SQL Server Profiler

2 votes

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

7 votes

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

2 votes

Explicit transactions for each DML query are necessary or not?

1 vote

Additional space required for INDEX REORGANIZE

0 votes

group records according to column