Forum Replies Created

Viewing 15 posts - 166 through 180 (of 7,164 total)

  • RE: Linked Servers, Views, and Stored Procedures

    Brandie Tarvin (2/25/2016)

    ...some OLTP databases reference tables in the Reporting databases.

    How many tables? I am thinking a simple Transactional Replication Publication on Server B subscribed to by Server A (same...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 25, 2016 at 7:31 pm

    #1861313

  • RE: Today's Random Word!

    ThomasRushton (2/25/2016)

    Ed Wagner (2/24/2016)

    Grumpy DBA (2/24/2016)

    Luis Cazares (2/24/2016)

    crookj (2/24/2016)

    HappyGeek (2/24/2016)

    Ed Wagner (2/24/2016)

    Champions

    Queen!!

    Dust (another one bites the...)

    Bohemian (Rhapsody)

    (Under) Pressure

    ZZ Top

    (Top) Trumps

    Triumph

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 25, 2016 at 2:57 am

    #1860984

  • RE: Home Computing - RAM and Processing suggestion

    Igor Micev (2/25/2016)

    Orlando Colamatteo (2/25/2016)

    Igor Micev (2/25/2016)

    Orlando Colamatteo (2/24/2016)

    Igor Micev (2/24/2016)

    Orlando Colamatteo (2/21/2016)

    etl2016 (2/21/2016)

    Hi,

    I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 25, 2016 at 2:01 am

    #1860981

  • RE: Home Computing - RAM and Processing suggestion

    Igor Micev (2/25/2016)

    Orlando Colamatteo (2/24/2016)

    Igor Micev (2/24/2016)

    Orlando Colamatteo (2/21/2016)

    etl2016 (2/21/2016)

    Hi,

    I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development apps such as below.

    Could...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 25, 2016 at 1:36 am

    #1860973

  • RE: How do you pseudo-code/flow-chart/map existing SQL code?

    You're welcome. Thanks for the feedback.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 24, 2016 at 8:26 pm

    #1860956

  • RE: Home Computing - RAM and Processing suggestion

    Igor Micev (2/24/2016)

    Orlando Colamatteo (2/21/2016)

    etl2016 (2/21/2016)

    Hi,

    I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development apps such as below.

    Could you please suggest if...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 24, 2016 at 8:00 pm

    #1860948

  • RE: Is TSQLT the tool to use?

    Eric Mamet (2/24/2016)

    Our management gets very upset if they find we spend time writing tests...

    :doze:

    That is a little sad. Do they get upset when there are bugs in production...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 24, 2016 at 3:16 am

    #1860652

  • RE: Try Catch doesnt work

    Cadavre (2/23/2016)

    See: -

    BEGIN TRY

    DECLARE @sql NVARCHAR(MAX) = 'IF ' + CHAR(39) + '1' + CHAR(39)

    + ' COLLATE Arabic_CI_AI...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 23, 2016 at 9:35 pm

    #1860619

  • RE: Today's Random Word!

    Grumpy DBA (2/23/2016)

    Ed Wagner (2/22/2016)

    DonlSimpson (2/22/2016)

    ZZartin (2/22/2016)

    Grumpy DBA (2/22/2016)

    djj (2/22/2016)

    Fixes

    Neutered

    Schnauzer

    Terrier

    Bichon

    Weimaraner

    Westminster

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 23, 2016 at 6:13 am

    #1860375

  • RE: Topic emails not being sent when replies are posted

    I must have gotten into a strange area of perception with the site not understanding the behavior of the drop down coupled maybe with some email delays on my end...all...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 23, 2016 at 1:47 am

    #1860299

  • RE: Orphaned login report for all databases

    dawryn (2/23/2016)

    I'd rather use (undocumented) stored procedures sp_MSForEachDB instead of cursor for single line solution:

    Exec sp_MSForEachDB 'EXEC [?].dbo.sp_change_users_login @Action=Report'

    Please don't use that procedure. Here is why: http://sqlblog.com/blogs/aaron_bertrand/archive/2010/12/29/a-more-reliable-and-more-flexible-sp-msforeachdb.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 23, 2016 at 1:42 am

    #1860295

  • RE: Creating XML from SQLCMD - with Reserved Characters

    SteveEClarke (2/22/2016)

    Hi Orlando,

    You mentioned that I have some options missing - however, the options that you have mentioned are for screen width ( -w, -y )

    Without the -y the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 22, 2016 at 8:30 am

    #1860107

  • RE: Creating XML from SQLCMD - with Reserved Characters

    I noticed a few things missing from your options when trying to run this locally:

    sqlcmd -S ".\sql2012" -d "tempdb" -E -s"|" -w 65535 -y 0 -i "C:\@\ActualSales.sql" -h -1 |...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 22, 2016 at 7:11 am

    #1860078

  • RE: write stored procedure using case when

    It would be helpful if you would provide the CREATE TABLE statement for your admin table, some INSERT statements to populate it with sample data and the query used to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 22, 2016 at 6:50 am

    #1860073

  • RE: How do you pseudo-code/flow-chart/map existing SQL code?

    Andrew P (2/21/2016)

    Thanks Orlando, the Hungarian notation is enforced by management, it's not by preference :-).

    The situation I have is where a previous developer has left a system with...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 22, 2016 at 6:42 am

    #1860069

Viewing 15 posts - 166 through 180 (of 7,164 total)