Forum Replies Created

Viewing 15 posts - 31 through 45 (of 242 total)

  • RE: Accelerator products such as Fusion IO

    TheSQLGuru (6/10/2013)


    Tim Walker. (6/10/2013)


    Can anyone share their experiences with accelerator products such as Fusion IO?

    I'm interested to know how easy they are to implement and what benefits / issues people...

  • RE: How to restore database from network place...

    Thanks both for the feedback, it's much appreciated. I have some space constraints to juggles with and it's great to hear what others are doing in practice.

    Thanks again

    Tim

  • RE: Count Words in Text Field and/or Column (frequency of use)

    Apologies .. I'm off topic and I know it but I'm also in the UK :hehe:

    Jeff Moden (12/6/2011)


    And now you understand my affinity for beer popsicles and dust bunnies....

  • RE: How to restore database from network place...

    kevaburg, John Mitchell-245523

    What's your experience / opinion on performing backups in the ways you describe?

    Thanks

  • RE: Initial data dumps

    Eliyahu (5/21/2013)


    The import process is asynchronous which doesn't guarantee correct order of loading tables, so we are running into reference integrity errors.

    Do you mean it uses SSIS or something similar?...

  • RE: SQL Server Security Issue

    Do you mean, for example, that the sa password in mixed mode is coded into apps so it can never be changed and other users know what this is and...

  • RE: The Cascading (CROSS) APPLY

    Interesting, entertaining and educational with worked examples and performance statistics make this a great read.

    The fact that it is also genuinely very useful and will help me to accurately solve...

  • RE: improve performance of sp

    I'm really sorry that my first post on this thread, which related to the lack of information from the OP, resulted in the thread going totally off topic!

    The reason was...

  • RE: improve performance of sp

    I have amended my original proposal to a genuinely useful one:

    CREATE PROC WhenCanIGoHome AS

    SELECT 'You can go home at '+CONVERT(varchar, DATEADD(s,5+(3595*RAND(CHECKSUM(NEWID()))),GETDATE()),108)

    :hehe:

    Tim

  • RE: Setup SQL Server on Amazon RDS

    Steve Jones - SSC Editor (5/9/2012)


    RDS gives you a database service that works like the 2008 R2 Dev edition.

    ...

    Azure gives you a service that is like SQL Server, but...

  • RE: Setup SQL Server on Amazon RDS

    It's a great article Steve. Thanks. Still trying to work out advantages of cloud offerings from SQL Server (Azure) {deprecated name!} vs Native SQL Server. Amazon entering confuses the matter...

  • RE: improve performance of sp

    riya_dave, I've not been here for a couple of months, but you have at least three of the best experts giving you free help here. You haven't given them any...

  • RE: SQL Azure - Backup

    Hi Dan,

    The only way you can create a 'backup' in SQL Azure is to either:

    (A) Create a BACPAC using the tools in Azure itself. This isn't a real backup though,...

  • RE: Is Clusterd Index sort and store data in physical order in table?

    GilaMonster (10/11/2011)


    Tim Walker. (10/11/2011)


    You are confused because the article you refer to uses confusing terminology.

    It starts "A clustered index determines the physical order of data in a table".

    This means that...

  • RE: Is Clusterd Index sort and store data in physical order in table?

    You are confused because the article you refer to uses confusing terminology.

    It starts "A clustered index determines the physical order of data in a table".

    This means that if your table...

Viewing 15 posts - 31 through 45 (of 242 total)