MSSQL Server Archive

  • Insert auto Number in SQL Bulk insert

    Insert auto Number in SQL Bulk insert

    To insert unique serial numeric values to an SQL table usually DBAs rely on procs with loops and inside loop an incrementing variable substitutes numeric values this may query time out., will consume mush significant time and may cause intermediate termination to resolve this issue in...

    Full Story

  • MS SQL Server – Functions

    MS SQL Server – Functions

    SQL Help Launch “SQL Query Analyzer” then Help, click “Transact-SQL Help”, click the tab “Contents”, then click on the plus sign by “Transact-SQL Reference”. Launch “SQL Query Analyzer” then Help, “Contents and Index”.  When “SQL Server Books Online” loads click on “Index” and type the...

    Full Story

  • MSSQL Server Date Manipulations (datename)

    MSSQL Server Date Manipulations (datename)

    In MSSQL Server its necessary for to see weekname(sunday,monday,etc..) and, weekcount and even some times its important to the day count in an year and most of DBA s directly count these , but SQL has a lot of built in Functions have a look...

    Full Story

  • Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition

    Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition

    You must enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps: Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then...

    Full Story

  • MSSQL 2005 Express Edition  Agent(Scheduler)

    MSSQL 2005 Express Edition Agent(Scheduler)

    Microsoft’s Free Edition of its SQL Server Edition MSSQL 2005 Express Edition is not shipped with SqlServer Agent, This is the Major Drawback of SQL Server  and i made a lot of googling for the same Finally i reached  http://www.lazycoding.com/products.aspx         Version...

    Full Story

  • MSSQL Server Rules Simplified

    MSSQL Server Rules Simplified

    One of the most exciting RDBMS Feature RULE is very simple with MSSQL Server Creates an object called a rule. When bound to a Field, data type, a rule specifies the acceptable values that can be inserted into that field. Here i am using a...

    Full Story

  • Strange Experience in MSSQL Server with ‘substring’ and ‘len’ Functions

    Strange Experience in MSSQL Server with ‘substring’ and ‘len’ Functions

    As of all DBA a me too is a great FAN of MS SQl Server for its Flexibility, stability and versatility , though recently i experienced a strange walthrough while i was into simple string functions with length and Substring extractions my requirement is simple...

    Full Story

  • Comparison b/w MSSQL and Mysql

    Comparison b/w MSSQL and Mysql

    Database engines are a crucial fixture for businesses today. There is no shortage of both commercial and open source database engines to choose from. Microsoft SQL Server 2005 is Microsoft’s next-generation data management solution that claims to deliver secure and scalable applications while making them...

    Full Story

  • SQL Server Insert Row number in Query Resultset

    SQL Server Insert Row number in Query Resultset

    Select Like following SELECT custid, custname, ROW_NUMBER() OVER(ORDER BY custid asc) AS ‘Row Number’ from members will list row number serially

    Full Story

  • MSSQL Client For Linux

    MSSQL Client For Linux

    Aqua Data Studio is a complete Integrated Development Environment (IDE) for database administrators, software developers and business analysts. It provides four major areas of functionality: 1) Database query and administration tools; 2) a suite of compare tools for databases, source control and file systems; 3)...

    Full Story