Forum Replies Created

Viewing 15 posts - 1 through 15 (of 453 total)

  • RE: Using pw-inspector in Brute Force attack on SQL Server

    default install of SQL will have "Failed Logins" logging enabled.

    Right Click the server name, and then click Properties. Under the Security page....

    Only pointing this out because if you...

  • RE: Time Traveling with Temporal Tables on SQL Server 2016

    N_Muller - Tuesday, September 5, 2017 7:16 AM

    This is a great article and I have always struggled with temporal data, every time...

  • RE: PowerShell Tool Time: Our First Toolbox

    robert.sterbal 56890 - Wednesday, October 28, 2015 7:10 AM

    Conceptually does it make sense to do this against hundreds of servers, or should...

  • RE: Fill in missing gaps on intergers

    Jeff Moden - Tuesday, August 22, 2017 8:15 AM

    I had forgotten that I was doing some experiments with the function and that...

  • RE: Fill in missing gaps on intergers

    Jeff Moden - Tuesday, August 22, 2017 8:05 AM

    Geoff A - Tuesday, August 22, 2017 8:02 AM

  • RE: Fill in missing gaps on intergers

    we are running Dynamics AX 2012 for Retail here. (all in azure but that is irrelevant, only mentioning it for sympathy)

    anyway, the transaction ID are suppose to be...

  • RE: Fill in missing gaps on intergers

    thanks Jeff. Much appreciated. Will you be in Seattle this year? we could catch up then....

  • RE: Time Traveling with Temporal Tables on SQL Server 2016

    this is great info. thanks so much.

    one question though.

    when you ALTER an existing table and ADD the needed datetime2 columns and then ALTER it again to SET SYSTEM_VERSION = ON,...

  • RE: Get previous years holiday date

    thanks guys.

    running 2014 here and was not aware of LAG.... that is working perfectly.

    Geoff A

  • RE: concatenate specific values from a column

    Luis Cazares (5/20/2014)


    It's still not pretty, it will read the table 4 times, but it should work better than the cursor. The recommendation is that you test both solutions to...

  • RE: concatenate specific values from a column

    i came up with a solution. not pretty but it will work for now...

    declare @Bo table ([ID] int, Col1 varchar(50), Col2 varchar(50), col3 varchar(50))

    insert into

  • RE: concatenate specific values from a column

    I was came to that conclusion a few minutes ago....

    my data will include an Identity column....

    create table TEMPDB..BO ([ID] int, Col1 varchar(50), Col2 varchar(50))

    insert into TEMPDB..BO values

    (1,'01','009920140516102116'),

    (2,'071710811019600001000005',''),

    (3,'070534524264000001000005',''),

    (4,'001806505517000001000005',''),

    (5,'001806595105200001000005',''),

    (6,'001806505903100001000005',''),

    (7,'02','009920140516102145'),

    (8,'000000002703000001000003',''),

    (9,'000000000259900001000003',''),

    (10,'000000007025800001000003',''),

    (11,'000000007056400001000003',''),

    (12,'000000001920500001000003',''),

    (13,'05','009920140516102250'),

    (14,'007648400910500001000005',''),

    (15,'007648400922800001000005',''),

    (16,'007648401441300001000005',''),

    (17,'007648401446800001000005',''),

    (18,'007648401460400001000005','')

    select *...

  • RE: SSIS Data Flow "bulk insert" VS. INSERT INTO

    the logging they are referring to is transnational logging. It is eating up disk space and making your backups larger.

    you could keep the process the same, but INSERT INTO could...

  • RE: Appropriate query for multi parameters

    how about defining @auditCode in your variable options to be @auditcode = (select DISTINCT auditCode from Local_Audits)

    and then just change your last line of code to be AND LU.auditCode in...

  • RE: how to GROUP BY with shortest Distance by AccountNumber

    the last one. The Alternate query.

    but it is still giving me some issues. my table variable example was a little simplistic. the actual way I get the 3 column result...

Viewing 15 posts - 1 through 15 (of 453 total)