Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • Reply To: T-SQL Query Help

    SQL is the fashionable language to query a database. PL SQL essentially stands for "Procedural Language extensions to SQL." This is the extension of Structured Query Language (SQL) that is used in Oracle. T-SQL essentially stands for "...

  • Reply To: Setting up Database mail using gmail account

    Hello, I have read through your matter of concern and would like to help you in this regard. By following these steps you would probably be able to set up...

  • Reply To: MBR & GPT Disks

    Master Boot Record (MBR) disks use the popular BIOS partition table. GUID Partition Table (GPT) disks use Unified Extensible Firmware Interface (UEFI). One benefit of GPT disks is that you can have extra than four partitions on each disk. GPT...

  • Reply To: Query Slow Result

    Different Ways to Improve SQL Query Performance

    Avoid Multiple Joins in a Single Query. ...

    Eliminate Cursors from the Query. ...

    Avoid Use of Non-correlated Scalar Sub Query. ...

    Avoid Multi-statement Table Valued Functions...

  • Reply To: Place data on another drive

    Move your libraries to a 2nd drive or partition

    Right-click the My Documents or Documents folder. Select Properties.

    Click the Location tab.

    Click the Move button.

    In the ensuing dialog box, go to your title folder in pressure D:, create a new folder internal it called files ,...

  • Reply To: Weird network issue

    Network Outages and Inaccessible Files. If you trip a high quantity of network outages at unpredictable instances or you discover your employees unable to get admission to documents they are supposed to have get right of entry to to, you may be experiencing a NetBIOS conflict. ...

    IP Conflicts. ...

    Slow Application...

  • Reply To: Datatype coversion error

    At table level:

    The data kind for this discipline need to enable decimals. So: Single, Double or (not sure) Currency.

    If you desire you also can set the Format property to Percent but this is now not important.

    At structure level:

    Set the Format property for the bounded control to Percent.

  • Reply To: Third-Party TDE?

    Transparent information encryption (TDE) is supplied natively in the database (DBMS), and third-party enterprise encryption operates impartial of the database and also provides obvious information encryption. Each imparting affords wonderful benefits and disadvantages.

Viewing 9 posts - 1 through 9 (of 9 total)