Reputation
2,328
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
5 18
Newest
 Enlightened
Impact
~54k people reached

17h
comment Can we create indexes on views in SQL Server?
@Niraj In SQL Server indexed views are equivalent to Oracle's fast refresh materialized views. SQL Server offers no option for deferred refresh (which would be handy for enforcing constraints).
1d
comment How to Retrieve data within nested select statement?
Please post the table definitions and sample data in a consumable way. You're just a few clicks away from a good question. Read here how to create it spaghettidba.com/2015/04/24/…
1d
comment sql server transactional - replication - the internal procedures often deadlock with user processes
very few people comment on downvotes. It can get frustrating at times. Asking for comments won't likely lead who downvoted to explain their reasons.
1d
reviewed Approve How to monitor history of logins to database if login auditing is not enabled?
1d
answered How to monitor history of logins to database if login auditing is not enabled?
1d
answered sql server transactional - replication - the internal procedures often deadlock with user processes
2d
reviewed Approve MySQL command “SHOW DATABASES” returns invalid databases
2d
reviewed Approve MySQL Index Creation Internals
2d
comment Can we create indexes on views in SQL Server?
@RafaelPiccinelli the view needs WITH SCHEMABINDING. No such option for indexes.
2d
answered Can we create indexes on views in SQL Server?
2d
reviewed Approve How to order by alphanumeric codes in SQL Server
May
24
awarded  Enlightened
May
24
awarded  Nice Answer
May
22
reviewed Approve Optimal engine for small lookup tables in MySQL
May
22
answered Trace Flag 4199 - Enable globally?
May
22
answered MS SQL Server 2014 has vulnerabilities
May
20
reviewed Approve SQL Server 2012 - Insufficient memory to continue the execution of the program. (mscorlib)
May
20
reviewed Approve Database Engine Services status failed
May
20
reviewed Approve Mixed SQL Server instances with static and dynamic ports
May
20
revised Mixed SQL Server instances with static and dynamic ports
added 68 characters in body