Richard M.

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 279 total)

Reply To: How to Use PowerShell to Track a Network Latency Issue in an Always On Availability Group

Right. Not only not meaningful, but messy, at best. Include the logic pointed out in the article I linked (or any other you found on this topic), so the backups...
_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

October 24, 2022 at 1:42 pm

#4103619
Reply To: How to Use PowerShell to Track a Network Latency Issue in an Always On Availability Group

If you created the same scheduled job on both replicas, and are not doing the right backup config, you might be creating a mess with your backup chain.
The fact that...
_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

October 24, 2022 at 12:40 pm

#4103592
Reply To: How to Use PowerShell to Track a Network Latency Issue in an Always On Availability Group

Interesting insight into the research process to find out what the root cause might be.
I am a little confused though about your comment:
Since the full backup job of both replicas...
_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

October 21, 2022 at 12:27 pm

#4102451
RE: Solve Sudoku with T-SQL - Part 1

Thanks Bevan! Seems that order clause fixed the issue. Look like the output is now correct.
_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

February 20, 2018 at 8:56 am

#1980478
RE: Solve Sudoku with T-SQL - Part 1

Same thing here. I used the code attached to the article, and the result set has almost all initial values replaced with other values and the results is not valid...
_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

February 20, 2018 at 6:47 am

#1980444
RE: Solve Sudoku with T-SQL - Part 1

Very interesting Bevan! Thanks for article. Can't wait for next part!
_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

February 20, 2018 at 5:08 am

#1980413
RE: Tracking Database DDL Changes with SQLVer

To tripple-check, I just tested in on a 75K character long SP and it printed out just fine. If you look at the code, it dynamically makes sure a CR+LF...
_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

January 22, 2015 at 9:35 am

#1772297
RE: Tracking Database DDL Changes with SQLVer

David, I believe the code I posted does not have that problem. I routinely use it when I need to recover some code that was updated.
_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

January 22, 2015 at 9:27 am

#1772287
RE: Tracking Database DDL Changes with SQLVer

Great article. We have been using DDL Loging for quite some time, with different iterations of T-SQL scripts.
And, there is a way to circumvent the PRINT limitation on length and...
_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

January 22, 2015 at 8:42 am

#1772262
RE: Using VMs in a cluster

We have deployed several VM clusters with SQL 2012 on VMWare, and there's some caveats to it. If you want to use shared storage it basically breaks, at least for...
_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

November 28, 2013 at 7:24 am

#1669690
RE: SQLServerCentral Runs sp_Blitz - Reliability

Brent Ozar (1/15/2013)
The log-bigger-than-database check is one of my favorite recent additions. I can't believe how often it comes up, and it's something I never would have thought to...
_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

January 15, 2013 at 6:36 am

#1577315
RE: SQLServerCentral Runs sp_Blitz - Security

jeffreddy (1/10/2013)
SQLDBA360 (1/10/2013)
*prepairing to be shot down
I've never had any problems setting SA as the DB owner with the SA account disabled, its a practice I follow even when the...
_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

January 10, 2013 at 8:38 am

#1575846
RE: Indexes

winash (10/21/2010)
Googled this out of curiosity and found the most disturbing explanation for index segmentation...
http://www.careerride.com/sql-server-what-is-index-segmentation.aspx
:ermm: :alien: :w00t: - looks like a "WTF!!??!!" icon is needed
ouch... and someone googling that will...
_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

October 21, 2010 at 1:31 pm

#1240557
RE: Duplicate production to Dev

Have you thought about Replication?
_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

October 20, 2010 at 1:34 pm

#1239886
RE: Tempdb

TemDB will not automatically shrink back, but you need to take something bigger in consideration: how often will this happen? If it will be frequent, it would be best to...
_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

October 19, 2010 at 1:22 pm

#1239300

Viewing 15 posts - 1 through 15 (of 279 total)