Viewing 15 posts - 121 through 135 (of 1,189 total)
Follow-up:
"If connecting to the listener - do you have a secondary in that AG set to read-intent?"
All of the secondaries I checked have these settings:
Connections in primary role: Allow all...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 22, 2020 at 9:01 pm
Thank you, Jeffrey!
Yes, the client reported this error using the listener name. I will investigate the read-intent setting as you advised.
Thanks again,
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 22, 2020 at 6:47 pm
Thanks for this discussion, Steve!
Does anyone used TOAD for SQL Server? Is it worth it?
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 17, 2020 at 8:15 pm
Thanks, everyone!
Sue_H, I followed the article and walked through the steps carefully. Thank you for posting it!
Turns out one of the databases had a limit on file growth which was...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 5, 2020 at 3:36 am
Thanks, Phil,
Sorry about that site. I didn't get the warning but didn't realize it could be marked as suspicious by security software.
Below are the relevant bits of the page's suggestions.
This...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
May 29, 2020 at 3:45 pm
Thanks, that was a good one.
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 7, 2020 at 6:04 pm
Get the best information you can.
About COVID-19: https://www.who.int/docs/default-source/coronaviruse/who-china-joint-mission-on-covid-19-final-report.pdf
WHO situation report: https://www.who.int/docs/default-source/coronaviruse/situation-reports/20200304-sitrep-44-covid-19.pdf?sfvrsn=783b4c9d_2
WHO Q&A: https://www.who.int/news-room/q-a-detail/q-a-coronaviruses
COVID-19 mortality rate by age (seeking a better source): https://www.sciencealert.com/covid-19-s-death-rate-is-higher-than-thought-but-it-should-drop
Thanks for these links!
-...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
March 5, 2020 at 10:01 pm
...
I'm too busy to participate in a global pandemic, so I'll sit this one out. I can't get infected when my head is buried in programming code.
LOL
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
March 5, 2020 at 9:57 pm
in 1918 the spanish flu (influenza A) killed somewhere up to 100 million people. we aren't there yet 🙂
I think the bigger issue is the high variability in case...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
March 4, 2020 at 5:34 pm
Interesting idea, but my guess is that Amazon is keeping a lot more PII (especially if one extends the PII concept to potentially sensitive audio conversations) than it is helping...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
March 3, 2020 at 7:39 pm
Thanks!
Just FYI - I think the issue was with the account I was using to run IE. Once I tried connecting through a shortcut that I had set up to...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
March 3, 2020 at 7:16 pm
Welcome back, Steve, seems to me like your sabbatical went by really quickly, so it's good to hear that it wasn't that way for you and that you feel refreshed....
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
February 26, 2020 at 2:53 pm
Nice question, and it got me because I got it wrong. Although DBCC is often used for "checkdb," of course it has other commands such as OPENTRAN.
Thanks for the Monday...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
February 17, 2020 at 3:47 pm
Thanks, Sue, that was it!
I'm going to review our guest accounts to make sure no inappropriate ones are enabled or have connect permissions.
I disabled guest for the database in question...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
February 12, 2020 at 7:35 pm
Hi,
Do you mean something like the topic of this article?
Deleting the data from the database is the easy part, a simple delete loop will handle that nicely. The problem is...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
January 21, 2020 at 5:22 pm
Viewing 15 posts - 121 through 135 (of 1,189 total)