Forum Replies Created
Viewing 15 posts - 811 through 825 (of 2,356 total)
-
Reply To: Are the posted questions getting worse?
Grant Fritchey wrote:Doggone it. Silly thing took me to an old post on the thread and I responded a second time. Sorry. I'll leave it up.
It's tough getting old.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Sql Server query to search database with multiple keywords
henryvuong wrote:I need to write an SQL Server query to allow user to search a table with multiple keywords. The table may look like this:
Table t ID Product 1 ...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Are the posted questions getting worse?
This is my new favorite.
https://www.sqlservercentral.com/forums/topic/tuning-query-2
Wow. Just Wow.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: A Need for Monitoring without Administration
One of my "pet peeves" with most monitoring is that it captures and stores so many metrics, and these metrics never are used for anything.
Most monitoring is used an alerting...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Are the posted questions getting worse?
Keeping with the subject...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: I have 4 nodes and i want 3 instances on 3 nodes and 4th as passive for windows
How much time have you spent learning how to install and configure Window Clusters?
If you are using SQL 2019, would Availability Groups server you better?
The first step is to configure...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Query Code returning incorrect results
carlton 84646 wrote:Can I also point out, that I'm trying to achieve the result without using LEFT JOIN
Curious, what issues will a LEFT JOIN cause?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Rebuilding and Reorganizing Indexes
Here is a piece of code that selects the individual statistics and generates the update statistics command.
It will do a fullscan of the statistics. Like Jeffery said, if you rebuild...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Rebuilding and Reorganizing Indexes
For starters, I would download Glenn Berry's diagnostic scripts to attempt to pinpoint what the specific issues may be.
https://glennsqlperformance.com/resources/
Ola's scripts are fine, I use them. But if you do...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Rebuilding and Reorganizing Indexes
christi1711 wrote:I have a Standard Edition. I have poor performance of my SQL Server and saw that a lot of tables had fragmentation more than 90 %.
Are you sure that...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Are the posted questions getting worse?
Sergiy wrote:Michael L John wrote:Anyone see the email from PASS?
We are saddened to tell you that, due to the impact of COVID-19, PASS is ceasing all regular operations, effective January 15, 2021.
Can...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Are the posted questions getting worse?
Anyone see the email from PASS?
We are saddened to tell you that, due to the impact of COVID-19, PASS is ceasing all regular operations, effective January 15, 2021.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Are the posted questions getting worse?
Jeff Moden wrote:Michael L John wrote:Luis Cazares wrote:In case someone missed it. There seems to be a big problem with Solarwinds Orion products, which some of you might use.
A related story
https://www.washingtonpost.com/technology/2020/12/15/solarwinds-russia-breach-stock-trades/
While it...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Are the posted questions getting worse?
Luis Cazares wrote:In case someone missed it. There seems to be a big problem with Solarwinds Orion products, which some of you might use.
A related story
https://www.washingtonpost.com/technology/2020/12/15/solarwinds-russia-breach-stock-trades/
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Help getting last 2 entries from split string with variable number of splits
This may work. Didn't really test it thoroughly.
SELECT
T.Id,
T.Name AS Product,
REVERSE(Split.ItemValue) AS Identifer,
Split.ItemNumber AS MaxNum,
Split.ItemNumber
FROM #TmpData AS T
CROSS APPLY dbo.DelimitedSplit8K(REVERSE(T.IdentificationString), '-') Split ...Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 15 posts - 811 through 825 (of 2,356 total)