Forum Replies Created
Viewing 15 posts - 811 through 825 (of 2,355 total)
-
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/ -
Reply To: Store Decimal values without Trailing Zeros
IT researcher wrote:I am using SQL Server 2008 R2 version. Is there any method to store decimal value in SQL without extra trailing zeros(like Float data type format).
Are you using a...
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,355 total)