Forum Replies Created

Viewing 15 posts - 16 through 30 (of 541 total)

  • Reply To: SUM(CAST(....

    Thanks for your response Jeff.  Glad to see you are still going strong. I will have a play. Keep up the great work.

    Kind Regards,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 25, 2022 at 3:14 pm

    #3977014

  • Reply To: SUM(CAST(....

    Thank you for your replies.

    I added: CAST(FileSize AS decimal(35,2)) AS FileSize,

    +

    WHERE Domain = @Domain AND convert(bigint, Filesize) > 50000

    That worked so many thanks.

    One last question...

    --I added
    ROUND(SUM(CAST([FileSize] AS...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 25, 2022 at 9:54 am

    #3976895

  • Reply To: SUM(CAST(....

    Hi. Where?

    Looks like you need BIGINT instead of INT.

    I tried:

    SUM(CAST([FileSize] AS BIGINT)/1048576.0)) + ' MB' AS [FileSizeMB]

    Kind Regards,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 24, 2022 at 5:08 pm

    #3976617

  • Reply To: Shrink or not to shrink that is the question?

    Hi. I guess it doesn’t make much difference but the deletes were performed in batches over a 24 hour period.

    Thanks,

    Phil

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    November 15, 2020 at 10:20 pm

    #3808104

  • Reply To: Shrink or not to shrink that is the question?

    Hi. I will need to check. I am surprised it is 600+GB.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    November 15, 2020 at 9:54 pm

    #3808102

  • Reply To: Shrink or not to shrink that is the question?

    Hi. I do not manage SQL I’m the tech lead on the application.

    The database is in a cluster hosted in Azure. I have been advised recovery model must be set...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    November 15, 2020 at 4:32 pm

    #3808055

  • Reply To: Shrink or not to shrink that is the question?

    Hi. Yes the transaction log is that large.

    Thanks,

    Phil

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    November 15, 2020 at 11:51 am

    #3808011

  • Reply To: Shrink or not to shrink that is the question?

    You could well be right 🙂

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    November 15, 2020 at 7:11 am

    #3807979

  • Reply To: Shrink or not to shrink that is the question?

    Hi Jeffrey. I have no concerns over the DB size however the vendor felt it might be impacting performance. Thank you for taking time to respond.

    Kind Regards,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    November 14, 2020 at 10:28 pm

    #3807917

  • Reply To: Report Development

    I was only able to mark one reply as answer...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 21, 2020 at 9:50 am

    #3716982

  • Reply To: Report Development

    Thanks to both. I am up and running.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 21, 2020 at 9:49 am

    #3716981

  • Reply To: Report Development

    Hi. Thanks to both. So I have already downloaded SSDT-Setup-ENU.exe + vs_SQL.exe. I originally installed vs_SQL.exe. I have kicked off install of SSDT-Setup-ENU.exe and have selected Database Tools and  SQL...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 21, 2020 at 9:39 am

    #3716979

  • RE: SA Password Unknown

    I just tried Joie response, results below:

    C:\Windows\system32>sqlcmd -S SERVER\Instance -E
    1> EXEC sp_addsrvrolemember 'DOMAIN\MyAccount', 'sysadmin';
    2> go
    Msg 15247, Level 16, State 1, Server SERVER\Instance , Line 1

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    August 17, 2017 at 2:18 am

    #1955623

  • RE: SA Password Unknown

    Thanks for all your input. Rather embarrassingly (or fortunately) I decided to RDP to the server using the service account I used to install the application. Hey presto the account was a...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    August 17, 2017 at 1:55 am

    #1955620

  • RE: SA Password Unknown

    The error log records:
    Login failed for user 'SERVER\User'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine]
    Error: 18456, Severity: 14, State 5.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    August 16, 2017 at 6:08 am

    #1955455

Viewing 15 posts - 16 through 30 (of 541 total)