Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,676 through 18,690 (of 59,098 total)

RE: query for datetime

Eirikur Eiriksson (1/3/2016)
Timing the different methods using the previously posted test data set
😎
Test harness
-- TEST: Different ways of calculating duration
-- DATA SET:...
--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)

January 8, 2016 at 7:52 pm

#1850732
RE: query for datetime

drew.allen (1/4/2016)
Jeff Moden (1/1/2016)
Ostensibly, the StartDT and EndDT would be represented using the same DATETIMEOFFSET, which also does NOT change the fact that there are 24 hours in a day....
--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)

January 8, 2016 at 7:49 pm

#1850731
RE: How to insert data from localdb to amazon redshift?

Apologies, Ed. I'm out of my element. What does "C-O" mean in this case?
--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)

January 8, 2016 at 7:45 pm

#1850729
RE: Efficient way to gat all unique values and their counts for a dynamic list of fields using one query statement

Tim Kovacich (1/7/2016)
Hi Jeff,
I just wanted to let you know I love your personal friend. The idea you sent was an excellent suggestion. I went from my original post which...
--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)

January 8, 2016 at 7:38 pm

#1850728
RE: Crosstab query NOT using pivot

Tallboy (1/8/2016)
Thanks guys looks good..
Tried and appears to Work Brilliant !!!!:-D:-D:-D:-D
Thanks for the feedback. To finish this off, do you understand it all well enough to be able 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)

January 8, 2016 at 7:33 pm

#1850727
RE: Table Creation - Tool

Alvin Ramard (1/8/2016)
Jeff Moden (1/8/2016)
I especially hate it when a Developer that doesn't know, creates tables using Visual Studio or has VS auto-magically create the tables from objects because almost...
--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)

January 8, 2016 at 6:40 pm

#1850726
RE: CLR concatenate function without duplicate values

Hugo Kornelis (1/8/2016)
I agree with Jeff on asking the author.
However, I also wonder why you want to filter out duplicates at the CLR side. Isn't it more efficient to filter...
--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)

January 8, 2016 at 6:31 pm

#1850725
RE: Disable NIC on remote server in powershell

Mac1986 (1/8/2016)
I might be the dummest person and i'm sure it might wront to recycle NICs one at a time at 15 hour interval. I'm seeing that IPV6 is slowing...
--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)

January 8, 2016 at 5:47 pm

#1850723
RE: Hacking to Hide

Steve Jones - SSC Editor (1/8/2016)
Jeff Moden (1/7/2016)
Amazing. I think these things are a bit crazy, whether they be shipboard or on airplanes, considering the technology that's been available...
--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)

January 8, 2016 at 1:41 pm

#1850687
RE: Nested Case statements Help

Hugo Kornelis (1/7/2016)
First, in SQL Server CASE is not a statement but an expression. That means that "when section=reading and value =start then time as start_Time" in itself will already...
--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)

January 8, 2016 at 1:36 pm

#1850684
RE: Disable NIC on remote server in powershell

Mac1986 (1/7/2016)
Hi I have a requirement to disable NIC using powershell remotely. I'm using below command. It works when i hardcode NIC's Name in the command but it is failing...
--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)

January 8, 2016 at 1:31 pm

#1850681
RE: Where to start...

Edvard Korsbæk (1/5/2016)
So, what would you recommand for reading to come a bit further than i am today?
A lot of good books and articles have already been cited but, 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)

January 8, 2016 at 1:29 pm

#1850679
RE: CXPACKET very high (average 55 %)

river1 (1/8/2016)
Hi
CXPACKET11143860.7210627025.50516835.2297746866455.110.01140.01090.0005
the values for CXPACKET are very high.
We had the parallelism in 6, then we changed to 1. No good still
Any idea ?
Thanks
A lot of times, CXPACKET is just a...
--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)

January 8, 2016 at 1:15 pm

#1850674
RE: CPU question

mxy (1/8/2016)
I have few questions about CPU details displayed in SET statistics TIME ON. Query runs fast, what does CPU time represent. Can we convert that value to a percentage...
--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)

January 8, 2016 at 1:10 pm

#1850672
RE: CLR concatenate function without duplicate values

krypto69 (1/8/2016)
Hi,
I have a CLR that uses a concatenate function:
https://www.mssqltips.com/sqlservertip/2022/concat-aggregates-sql-server-clr-function/
(andy)
The problem is I am getting duplicates - I know it's supposed to return duplicates, and I know you can eliminate...
--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)

January 8, 2016 at 1:05 pm

#1850667

Viewing 15 posts - 18,676 through 18,690 (of 59,098 total)