Viewing 15 posts - 4,681 through 4,695 (of 59,067 total)
Heh... this site left me no choice, Grant. I had to give this article only 5 stars because it won't let me give it 1000!
It's amazing how many "Brown Leaf"...
September 5, 2021 at 6:56 am
I have a query that is using DATEDIFF to calculate the number of minutes, of course as an integer, but I may need the extra precision of showing this...
September 3, 2021 at 6:26 pm
It's hard to tell.... are you looking for confirmation about your "assumption" or ???
September 2, 2021 at 8:04 pm
<sigh>
So I post a comment over at DBA Stack Exchange, because I know what I'm posting isn't an answer. I get dinged for it because it almost reads like...
September 2, 2021 at 8:02 pm
Confirmed! Messages, Followers, and Following are all back! Thanks, Steve!
September 2, 2021 at 6:41 pm
What other useful DBA reports do you suggest? Maybe something we would run every month or so to check that our environment is configured/running optimally. We have these so...
September 2, 2021 at 1:57 am
As a bit of a sidebar, the TOP thing may have been someones attempt to "set a row goal" to trick the optimizer into doing a better job. The thing...
September 2, 2021 at 1:34 am
Hello,
We have truncated a huge table (50+ million) rows in sql server which was created for testing purpose.
However the disk space is not released back.
Any pointers on how to...
September 1, 2021 at 10:53 pm
Shifting gears a bit and speaking of the community on this site, someone made a new addition to Wiktionary a month or so ago. I'm sure that most of you...
August 31, 2021 at 3:01 am
My comment was to Grant and was meant as a general comment. If you'd like to quantify it, go back to the testing that I did that was mostly ignored...
August 31, 2021 at 2:58 am
Thanks, Steve. I really appreciate it. Are there similar links for "followers" and "following"?
August 31, 2021 at 2:41 am
That's fantastic. How do we read old messages? I'm not seeing it anywhere in my profile. It's entirely possible that this ol' brain forgot something so I'll ask, do you...
August 30, 2021 at 9:32 pm
I have noticed that rebuilding indexes on a couple of the tables referenced in that query statement can improve performance temporarily.
That causes a recompile of anything that uses...
August 30, 2021 at 4:57 pm
You can't really track user behavior through the logs. Without specialized tools, you can't view the information in the logs. That's really not what the logs are for. It's...
August 30, 2021 at 4:49 pm
I set my sql server recovery mode as FULL,so all of the logs will be fully recorded. if so, how can I use the log to track if users'...
August 30, 2021 at 4:46 pm
Viewing 15 posts - 4,681 through 4,695 (of 59,067 total)