Viewing 15 posts - 1,591 through 1,605 (of 6,676 total)
Why are you invoking a SQL command - and then within that script executing sqlcmd? What is the purpose of this script?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 1, 2020 at 6:28 pm
In the drop down in the certificate we have selected the available certificate in the configuration manager
But is that the correct certificate? Unless you open the certificate and verify...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 30, 2020 at 9:28 pm
Just having the certificate on the server doesn't do anything - the certificate needs to be bound to an address. Since SSRS uses its own internal web server - you...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 30, 2020 at 8:58 pm
Http load balancer is working , but I am getting the error when I try to access the secured site https://, do you still think it could be something...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 30, 2020 at 8:14 pm
You just need a LEFT OUTER JOIN:
Select [week] = coalesce(tt.[week], 1)
, al.Account
, tt.[value]
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 29, 2020 at 7:04 pm
Not sure why you think you need separate databases. You most likely can resolve your issues by using separate schemas instead of creating separate databases.
And - as was stated previously,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 29, 2020 at 6:54 pm
You need to uninstall it - apparently the bug is related to database snapshots and CHECKDB uses that feature. Not sure about these other components, but you only need to...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 28, 2020 at 8:37 pm
Are you sure the load balancing is actually routing to both servers?
How are you load balancing - is it through Netscaler, F5 or something else and are both servers up...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 27, 2020 at 3:16 pm
Thank you this work when the user enter the full number but the idea to wildcards is that they can type
@number1 + 56_4__
@number2 = 6__7__
What does this mean?
What would...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 25, 2020 at 3:29 pm
And to add....
Datafile of 50 gigs 40% free space and log file of 30 gigs 99% free.....so 5 gigs might be ok for backup ?
50 GB at 40% free...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 24, 2020 at 9:23 pm
Jeff - I was reading your article(https://www.red-gate.com/simple-talk/opinion/opinion-pieces/jeff-moden-dba-of-the-day/) and wanted to ask, what are some of the books or resources you felt like are great resouces to master Tsql. I...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 24, 2020 at 8:04 pm
If the user can enter multiple items in the text box - is it up to the user to insert a pipe in the string? Or do you have some...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 24, 2020 at 7:52 pm
To add to what Grant has posted - unless you have made changes to the instance configuration's TCP/IP settings you don't need to change anything. The default configuration isn't locked...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 23, 2020 at 6:11 pm
you need 'tempdb..#xxx' when checking for object existence.
e.g. if object_id('tempdb..#xxx') is not null drop table #xxx;
other than the case above you do not need to reference tempdb.. and you...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 22, 2020 at 8:27 pm
You can review the SQL Server logs through notepad to see why SQL Server is not starting. My guess is that you have added one or more trace flags incorrectly...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 22, 2020 at 8:20 pm
Viewing 15 posts - 1,591 through 1,605 (of 6,676 total)