Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,631 through 3,645 (of 59,067 total)

Reply To: SQL Query - Finding CPU age (how old)

sets4life wrote:
Hi All
Trying to do a query to find out how old are the cpu on device. We do have a way of doing it but it involves manual step...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 15, 2022 at 3:39 am

#4016512
Reply To: SQL Query - Finding CPU age (how old)

ScottPletcher wrote:
Didn't you already ask this q?!
According to the OPs profile, no. In fact, this appears to be the first and only question they've posted.

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 15, 2022 at 3:14 am

#4016507
Reply To: How to add background color of row based to existing SP/query

Phil Parkin wrote:
When I do things like this, I return separate columns for the properties I wish to control (font, bold, colour etc) and then assign those columns to the relevant...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 15, 2022 at 3:04 am

#4016505
Reply To: How to handle multiple Aliases
One possibility for those is a bit shorter...
```
NULLIF(A.CALC_Date_EOIReceived,'1900-01-01 00:00:00.000') AS [Date Req Created]
NULLIF(A.CALC_Date_EOIReceived,'1900-01-01 00:00:00.000') AS [Date Initiated]
```
If we could see the rest of the code, we could...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
April 14, 2022 at 4:41 am

#4015455
Reply To:

wrote:
I'm looking at a career change. I have bachelors degree in healthcare management and pre counseling. My mental health is going down the drain and do not think I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 14, 2022 at 4:28 am

#4015450
Reply To: Common Import format to import data and database schema from various SQL dbs

I'll also tell you that a lot of companies aren't going to send you a database backup because there's a whole lot of stuff in a backup that they might...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 13, 2022 at 5:36 pm

#4015242
Reply To: Filter clause query

With a small tweak, the method in the following article is what I use for such bleedovers. It's NOT a short article because it actually explains how to think about...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 12, 2022 at 10:27 pm

#4014770
Reply To: Learning SQL Server 2016

fluis wrote:
Hi there,
I am looking to find some very good beginner resources for SQL server 2016 as we have to use that at work. I dont have much experience with...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 12, 2022 at 8:13 pm

#4014728
Reply To:

I don't know what your stored procedure looks like but, if you need to compare every column of every row to all the other rows, then create a hash of...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 12, 2022 at 7:06 pm

#4014721
Reply To: Difference between inner join and cross join?

All true and thanks for posting the examples.
Just to be sure though (for any newbies that might be reading this), that's not what I was talking about in my previous...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 12, 2022 at 5:07 pm

#4014666
Reply To: First post here - help with installation of 2012 or 2019 Sql Server Express

Lordy. I agree with the others. Using a decade old version of SQL Express instead of the current version or at least previous version of SQL server of the SQL...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 12, 2022 at 4:57 pm

#4014658
Reply To: Difference between inner join and cross join?

Hi Tony, and welcome aboard!
Just to add to your explanation, a CROSS JOIN can also be used as a massive, super fast "Pseudo Cursor" to replace <<insert drum roll here>>...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 12, 2022 at 1:14 am

#4014279
Reply To: make script more robust

While this is all very interesting, I have to ask the question... Have you actually called the software vendor to tell them of your problem and to see what they...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 12, 2022 at 12:56 am

#4014263
Reply To: SS2019 Running Extremely Slow

Even with the columnstore thing, the original issue on this thread has never been solved. What made the old query suddenly perform so poorly when the database was moved to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 12, 2022 at 12:47 am

#4014262
Reply To: Removing Text From All Rows
George Vobr wrote:
In SQL Server 2017 (14.x) and later, it is possible to use the TRIM (Transact-SQL) function:
```
;WITH ctePC
AS ( SELECT expression
   ...
```
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
April 12, 2022 at 12:41 am

#4014260

Viewing 15 posts - 3,631 through 3,645 (of 59,067 total)