Skip to main content
Database Administrators
AmmarR's user avatar
AmmarR's user avatar
AmmarR's user avatar
AmmarR
  • Member for 12 years, 4 months
  • Last seen more than 4 years ago
Profile Activity

50 Answers

Score Activity Newest
27 votes

When To Update Statistics?

26 votes
Accepted

How to Delete Restoring Database

16 votes
Accepted

What are the arguments in favor of using ELT process over ETL?

14 votes

Taking backup of all the databases in SQL Server

12 votes
Accepted

View delete statements in the Transaction log

10 votes
Accepted

Why does sqlcmd -Lc not show the local instance?

9 votes
Accepted

Saving SQL Server backup file in multiple parts

9 votes
Accepted

Can I grant a user ALTER TRACE permission to a single database?

6 votes
Accepted

Treating certain Arabic characters as identical

5 votes
Accepted

Looking for a Trigger to change inserting strings?

4 votes
Accepted

Access 2007 sql editor

3 votes

Strategy to handle an SQL Server DB with too many files (BLOBs) in it?

3 votes

A Script to insert dummy Data in all tables of Database

3 votes
Accepted

Is it possible to join derived tables to actual in Access 2007

3 votes

How to store a date without the year component

3 votes

How to store count value in DB

3 votes

How to do Row Level Security in SSRS 2008 R2 (or 2012) with Active Directory Groups?

2 votes
Accepted

Export multiple tables among servers

2 votes

Maximum table capacity in SQL Server 2008

2 votes

Can a RDBMS connect to a remote server, execute a select query and copy them into a local table just with SQL commands?

2 votes

SQL Server 2008 linked server to an Access 2007 DB that is in a protected directory on the Network

2 votes

Tutorial in datamining

2 votes
Accepted

How does performance of SQL Server CE and SQL Server Express compare?

2 votes
Accepted

How do I design a database for continents, countries, regions, cities and POIs?

2 votes

Would it be possible/wise to execute 2 parallel restores from a single backup?

2 votes
Accepted

SQL Server Log: The database 'master4IDR' is marked RESTORING

2 votes

The following system error occurred: No mapping between account names and security IDs was done

1 vote

SQL Server compact- Query that return 2 constant columns even if query didn't return data

1 vote

Microsoft SQL Server says my login is disabled, even in single user/DAC mode

1 vote

How to build dimensions from SCD tables

1
2