Viewing 15 posts - 46 through 60 (of 1,187 total)
Hello,
I am seeing the same issue. I checked the database configuration and it seems OK, but perhaps someone else can post more info on why this happens and how to...
December 2, 2022 at 4:27 pm
Thanks, Frederico. This was indeed ultimately a permissions issue.
-- webrunner
November 28, 2022 at 6:48 pm
Hello,
You can also run the query here for a general sense of what SQL Server is waiting on:
SQL Server Wait Statistics (or please tell me where it hurts…)
https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/
HTH.
-- webrunner
November 14, 2022 at 5:15 pm
"I walked outside to take the call during a break and was told I wasn't responding quick enough to the call. The emergency? A test of how quickly I'd respond...
November 4, 2022 at 3:23 pm
Jeff, at the risk of introducing more adages into this thread, your most recent reply reminds me of another I heard once: "If you don't have time to do it...
October 24, 2022 at 6:44 pm
I once read about a term in economics that was coined for this kind of decision making: satisficing.
Satisficing is a decision-making process in which an individual makes a choice that...
October 24, 2022 at 2:11 pm
Hi Ed,
Thanks. The even types are:
mydb1: event types 4 and 2
mydb2: event type 3
According to the MS documentation, those mean:
2 = Bad checksum.
3 = Torn page.
4 = Restored (page was...
September 29, 2022 at 5:44 pm
Thanks Ed, that is an excellent reminder. I too often focus on doing what is asked of me. Sometimes the answer has to be "That is not possible," or "That...
August 12, 2022 at 1:34 pm
Thanks, Scott. This is what I came up with. I decided not to use SET IDENTITY_INSERT dbo.sysjobhistory ON since they are just interested in having access to old history, not...
August 4, 2022 at 8:32 pm
Thanks so much, Scott. That is extremely helpful information. Much appreciated.
-- webrunner
August 4, 2022 at 4:23 pm
@edwardwill "The correct answer should be "Create Certificate". There is no LOAD CERTIFICATE Command."
That's what I thought!
-- webrunner
July 20, 2022 at 1:12 pm
Thanks for this question, Steve. Especially because it explains another one of the generic errors that get returned from SQL Server, such as string or binary truncation etc.
-- webrunner
July 15, 2022 at 1:34 pm
Thanks for this helpful review of the AVG() T-SQL function!
I'd just like to call attention to the few minor typos in the article - just helpful feedback. For example
"all female...
July 1, 2022 at 7:05 pm
Gotcha, Jeff, thanks for the disclaimer. At the very least I can use the info you provided to rule in or rule out the issue. Much appreciated.
-- webrunner
June 13, 2022 at 3:04 pm
Thanks so much, Jeff, I will review those articles.
Thanks again!
-- webrunner
June 13, 2022 at 2:42 pm
Viewing 15 posts - 46 through 60 (of 1,187 total)