Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,311 through 2,325 (of 59,067 total)

Reply To: query, compare and match against values in date and time columns

brian.cook wrote:
LOL! Ok.
The LPKCX are Cranes. The date and times are the location of the cranes as indicated by the Lat/Long. Calculating the distance between the given LPKCX location and...
--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)

December 7, 2022 at 7:02 pm

#4123057
Reply To: Pivot not working, pivot without aggregate functions.
Jonathan AC Roberts wrote:
```
DROP TABLE IF EXISTS #T;

SELECT *
  INTO #T
  FROM (VALUES ('1A','E'),('1A','IR'),('1A','N'),('1A','SC'),('1A','SCIR'),
             ...
```
--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)
December 7, 2022 at 3:12 am

#4122766
Reply To: Pivot not working, pivot without aggregate functions.

Post withdrawn. Found something odd.
--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)

December 7, 2022 at 1:41 am

#4122722
Reply To: Pivot not working, pivot without aggregate functions.

@sbhagyalakshmi95,
So do you have another column that would enforce the order of the data you posted or doesn't the order in the resulting rows matter?
--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)

December 6, 2022 at 11:20 pm

#4122678
Reply To: Table has no data but query takes 20 secs to complete

Awesome info, Grant. Thanks.

--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)

December 6, 2022 at 11:11 pm

#4122677
Reply To: Pivot not working, pivot without aggregate functions.

Post withdrawn. Found something odd.
--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)

December 6, 2022 at 6:35 pm

#4122617
Reply To: Table has no data but query takes 20 secs to complete

From the original results posted for sys.db_db_index_physical_stats, I think it's pretty clear that ghost rows are an issue. The fast inserts "feature" may also be an issue.
You first need 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)

December 6, 2022 at 2:47 pm

#4122545
Reply To: Pivot not working, pivot without aggregate functions.

Neither a Pivot nor a nasty fast CROSSTAB can be done without an aggregate. The good new for you is, MAX() is an aggregate. Do the Pivot using MAX(). You'll...
--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)

December 6, 2022 at 2:32 pm

#4122544
Reply To: Table has no data but query takes 20 secs to complete

Ken McKelvey wrote:
If you want to post a query plan use something like:
https://www.brentozar.com/pastetheplan/
Would you download a unknown file from the internet?
The trouble with that is that can go away and...
--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)

December 6, 2022 at 2:29 pm

#4122535
Reply To: How to speed up creating Clustered ColumnStore Index??

It sounds like there are multiple years (maybe 6 or so?) stored in the table. Column Store or not , I'd split it up into multiple tables, at least by...
--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)

December 6, 2022 at 2:18 pm

#4122528
Reply To: 10 years as Sql server dba but still fears of Interview and lack of Confidence

If you search for interview questions for DBAs, you'll find a wealth of questions. I also want you to be aware that, while the questions can be pretty good, some...
--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)

December 5, 2022 at 10:35 pm

#4122238
Reply To: Non-sysadmin needs ability to maintain SQL Agent Jobs

Please look into the database ROLES for MSDB. There a 3 that are totally different than they are in any other database. They'll be obvious to you. Then, look them...
--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)

December 5, 2022 at 10:12 pm

#4122234
Reply To: T-SQL Code Review - Where Field DOES NOT contain

Ed B wrote:
For this example I would probably use ISNULL(airport_city, '') not in
That would make sure that you don't ever have to worry about the query using an index to seek....
--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)

December 5, 2022 at 10:03 pm

#4122233
Reply To: The DAX Text Contatenation

Lucky but logical guess on my part.
--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)

December 5, 2022 at 12:54 am

#4121853
Reply To: Display Top N values of a table with calculation next to it

Lordy... my apologies. Really bad day or two, apparently. I totally missed the fact that this was for SSRS 2016. I don't even know how to spell SSRS.
--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)

December 3, 2022 at 2:52 am

#4121389

Viewing 15 posts - 2,311 through 2,325 (of 59,067 total)