February 2012
M T W T F S S
« Jan    
 12345
6789101112
13141516171819
20212223242526
272829  

Archives

Categories

  • [+]ASP.NET (7) 
  • [+]C# (87) 
  • [+]C++ (13) 
  • [+]Delphi (20) 
  • [+]JavaScript (24) 
  • [+]Regular Expressions (7) 
  • [—]SQL (13) 
  • [+]VB (100) 
  • [+]VB.NET (4) 

Online

Users: 4 Guests, 1 Bot
  • Loading...


    Loading...

    Login






    Register | Lost password?

    Register





    A password will be mailed to you.
    Log in | Lost password?

    Retrieve password





    A confirmation mail will be sent to your e-mail address.
    Log in | Register
  • Archive for the ‘SQL’ Category

    T-SQL: Find logical name and physical location of system databases

    Continue

    What's new in SQL Server 2008

    SQL SERVER 2008 DATABASE IMPLEMENTATION AND MAINTENANCE
    MCTS EXAM: 70-432
    ===================================================================
    Exam Objectives:
    	1)  New Features in SQL Server 2008
    	2)  Installing SQL Server 2008
    	3)  Configuring SQL Server 2008
    	4)  Managing Security
    	5)  Managing Data Encryption
    	6)  Managing High Availability
    	7)  Maintaining Your Database
    	8 )  ETL Techniques
    	9)  Managing Replication
    	10) Monitoring and Troubleshooting
    	11) SQL Server XML Support
    	12) Service Broker
    	13) Performance Tuning
    	14) Implementing Objects
    ====================================================================
     Continue reading New Features in SQL Server 2008

    Concatenate the values of a column in all rows into one row.

    Continue

    Capture the SQL Server Wait Stats to a table for reporting

    Continue

    Capture Virtual File statistics to a table to track reads, writes, and possible file contention in SQL Server

    Continue

    Backup all user databases

    Continue

    Backup Transaction Logs

    Continue

    Adding a string array to database

    Continue

    A user-defined function that formats the columns of a table, view, stored procedure, etc. into separate columns of code such as C# properties, Wilson ORMapper xml, and more

    Continue

    A user defined function to translate a 5 digit zip code to a two character state code.

    Continue

    Page 1 of 212