Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
6
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
Jul
10
accepted No advantage of using Cross Apply or CTE over inline sub-query
Jul
10
comment No advantage of using Cross Apply or CTE over inline sub-query
Well it is not simple it has other table joins, columns as well. I'm using CTE and Cross/Outer apply insteadd of putting sub-queries in select list or where conditions. That is why when I converted this one to CTE and Cross Apply it gave similar execution plan.
Jul
10
asked No advantage of using Cross Apply or CTE over inline sub-query
Oct
2
awarded  Popular Question
Dec
8
accepted Moving database file locations in SQL Server 2008
Dec
8
comment Moving database file locations in SQL Server 2008
thanks @Michael Perrenoud this worked. But after restarting database server it is showing eftest (Recovery Pending) in object explorer.
Dec
8
comment Moving database file locations in SQL Server 2008
@MichaelPerrenoud yes the system databases are available
Dec
8
comment Moving database file locations in SQL Server 2008
@marc_s the database is not visible or available in query window.
Dec
8
asked Moving database file locations in SQL Server 2008
Sep
1
awarded  Supporter
Sep
1
awarded  Scholar
Sep
1
comment Change tables from one user to another
I had used Alter Schema dbo Transfer..., Alter Authorization is new thing for me. But I think Alter Authorization should be better as Schema Transfer can cause problem if sys.objects is used for any functions as per MSDN
Sep
1
accepted Change tables from one user to another
Aug
31
asked Change tables from one user to another
Jun
6
awarded  Student
Jun
6
awarded  Teacher
Jun
5
answered MySQL Replication not working properly on Ubuntu Lucid Lynx Server
Jun
5
asked MySQL Replication not working properly on Ubuntu Lucid Lynx Server
Jun
5
awarded  Autobiographer