Forum Replies Created

Viewing 15 posts - 6,016 through 6,030 (of 8,731 total)

  • RE: SELECT clause

    Readers don't block readers. Readers can block writers and the other way around. Even on that case, it would depend on the locks acquired based on the queries and the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 7, 2014 at 8:31 am

    #1736002

  • RE: Different result for one query

    GilaMonster (8/7/2014)

    Is it repeatable

    Are they connecting to the same instance, same database

    Are they using nolock/read uncommitted?

    Repeating Gail's question:

    Are they connecting to the same instance, same database?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 7, 2014 at 8:26 am

    #1735999

  • RE: Converting large excel spreadsheet to normalized data in SQL 2012

    First of all, how do you get your data into SQL Server? What are you using?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 7, 2014 at 8:25 am

    #1735997

  • RE: Help to add money value

    That's why I included a link to the help topic on those functions. Books online (BOL) or online help or simply SQL Server help (as easy as pressing F1 on...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 7, 2014 at 8:23 am

    #1735996

  • RE: Diff between 2012 and 2008 R2?

    Here you go, these are all the differences:

    http://technet.microsoft.com/en-us/library/bb500435(v=sql.110).aspx

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 7, 2014 at 8:15 am

    #1735993

  • RE: SQL-only ETL using a bulk insert into a temporary table (SQL Spackle)

    Stan Kulp-439977 (8/7/2014)

    shah.muhammad (8/7/2014)

    Bulk Insert works in most cases but if your operation is based on sequence, you can't rely on bulk insert as it loads the data from the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 7, 2014 at 7:08 am

    #1735951

  • RE: SQL DBA high ended question (5+ years’ experience)

    Eirikur Eiriksson (8/6/2014)

    benjamin.reyes (8/6/2014)

    Eirikur Eiriksson (8/5/2014)

    Grant Fritchey (8/5/2014)

    Eirikur Eiriksson (8/5/2014)

    Guess one has to differentiate between five years of work and five years worth of experience. Questions like "what are the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 6, 2014 at 2:49 pm

    #1735787

  • RE: Help to add money value

    Try using CAST or CONVERT

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 6, 2014 at 2:38 pm

    #1735784

  • RE: Stupid Stored Procedure Question Nbr 1

    A stored procedure (or any process in a batch) runs each statement one at a time waiting for each one to complete.

    Deadlocks occur between different sessions, so a single SP...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 6, 2014 at 9:01 am

    #1735673

  • RE: Calculating Working Hours

    That's true, but this could work as a guide. This script was originated from a forum post and I thought of sharing it even if it can't be used as...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 5, 2014 at 10:56 pm

    #1735477

  • RE: SQL DBA high ended question (5+ years’ experience)

    Eirikur Eiriksson (8/5/2014)

    Luis Cazares (8/5/2014)

    Eirikur Eiriksson (8/5/2014)

    Grant Fritchey (8/5/2014)

    Eirikur Eiriksson (8/5/2014)

    Guess one has to differentiate between five years of work and five years worth of experience. Questions like "what are...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 5, 2014 at 6:41 pm

    #1735450

  • RE: SQL DBA high ended question (5+ years’ experience)

    Eirikur Eiriksson (8/5/2014)

    Grant Fritchey (8/5/2014)

    Eirikur Eiriksson (8/5/2014)

    Guess one has to differentiate between five years of work and five years worth of experience. Questions like "what are the DAC limitations", "consequence...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 5, 2014 at 6:05 pm

    #1735445

  • RE: SQL DBA high ended question (5+ years’ experience)

    GilaMonster (8/5/2014)

    Luis Cazares (8/5/2014)

    Koen Verbeeck (8/5/2014)

    Grant Fritchey (8/5/2014)

    You get a phone call. The person on the phone says the database is slow. What do you do?

    Migrate from Oracle to SQL...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 5, 2014 at 4:25 pm

    #1735428

  • RE: SQL DBA high ended question (5+ years’ experience)

    Eirikur Eiriksson (8/5/2014)

    Luis Cazares (8/5/2014)

    Eirikur Eiriksson (8/5/2014)

    Luis Cazares (8/5/2014)

    Koen Verbeeck (8/5/2014)

    Grant Fritchey (8/5/2014)

    You get a phone call. The person on the phone says the database is slow. What do you...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 5, 2014 at 4:18 pm

    #1735426

  • RE: SQL Injection - Suggestion..!!!

    Fix the code.

    Change permissions to the web app user to the minimum needed. You'll still get attacked but the damage can be minimized.

    Fix the code.

    Fix the code.

    The code should...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 5, 2014 at 3:51 pm

    #1735420

Viewing 15 posts - 6,016 through 6,030 (of 8,731 total)