SQL Server Performance

Recent Activity

Activity stream for all registered members at SQL Server Performance Forums.

  1. manshafmkd posted a new thread.

    I want to select the unique column names from 4 tables using the given query

    select * from t1 where exists(select * from t2 where t2.col1 = t1.col1 and t2.col2 = t1.col2) this...

    Forum: ALL SQL SERVER QUESTIONS

    May 26, 2012 at 1:32 AM
  2. Shehap replied to the thread SQL Server 2008, Maintenance plan under management and SQL Server agent.

    For legibility , one DB maintenance plan can have one or more than one job , thereby it mustn't...

    May 25, 2012 at 10:11 AM
  3. Antonio Benildus Muerling replied to the thread SQL Server 2008, Maintenance plan under management and SQL Server agent.

    Hi Shehap, As per to what you have mentioned, it does seem like, that one, can have only the same...

    May 24, 2012 at 6:36 PM
  4. amahalingam replied to the thread SQL SERVER COLLATION issue.

    It is not recommended to change the collation of the database that is in USE. You should have been...

    May 24, 2012 at 8:28 AM
  5. Shehap replied to the thread publish in ssrs.

    For publish reports privileges , it needs at least system user privileges under site setting or...

    May 24, 2012 at 3:49 AM
  6. Shehap replied to the thread SQL Server 2008, Maintenance plan under management and SQL Server agent.

    By default , when you are going to create any maintenance plan, it will initiate a SSIS package...

    May 24, 2012 at 2:38 AM
  7. Shehap replied to the thread Sql 2000 db query perform slow on sql 2008..

    It sounds like here the root reason beyond these distinct performance reads is relevant to query...

    May 24, 2012 at 2:08 AM
  8. amahalingam replied to the thread Path of the backups in SQL server 2008, how do I see the path from the SQL server 2008 software.

    script below will show you the backups that were taken in the last 24hours and their path. SELECT...

    May 24, 2012 at 1:56 AM
  9. Shehap replied to the thread data source problem in ssrs 2008 r2.

    For legibility , Integrated security here of Data source model should have nothing to do with...

    May 23, 2012 at 11:47 PM
  10. Antonio Benildus Muerling posted a new thread.

    SQL Server 2008, Maintenance plan under management and SQL Server agent

    Hi All, Thanks for reading my post, can anyone tell me, what does it meant by maintenance plans...

    Forum: ALL SQL SERVER QUESTIONS

    May 23, 2012 at 7:53 PM
  11. Antonio Benildus Muerling posted a new thread.

    Path of the backups in SQL server 2008, how do I see the path from the SQL server 2008 software

    Hi all Thanks for reading my post, I am knowing where the backups are from, but am unable to see...

    Forum: ALL SQL SERVER QUESTIONS

    May 23, 2012 at 6:34 PM
  12. admin replied to the thread How to become a Database Administrator.

    Oh yes of course - don't forget about SSP :)

    May 23, 2012 at 9:44 AM
  13. Luis Martin replied to the thread How to become a Database Administrator.

    Also you will find a lot of good articles in our forum.

    May 23, 2012 at 8:13 AM
  14. admin replied to the thread How to become a Database Administrator.

    Hi Antionio, this is too general a question for the forums. I'd suggest starting off with some...

    May 23, 2012 at 1:22 AM
  15. Antonio Benildus Muerling posted a new thread.

    How to become a Database Administrator

    Hi Geeks, Thanks for reading my post I am new to the scene, and I have got 4 years of experience...

    Forum: ALL SQL SERVER QUESTIONS

    May 22, 2012 at 9:43 PM
Loading...