Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,326 through 11,340 (of 59,102 total)

RE: PIVOT

Did that work for you or what???
--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)

September 2, 2018 at 8:07 pm

#2004240
RE: SQL Server 2016 SP1 (Azure IaaS) slower than SQL 2008 SP2 on premise

quackhandle1975 - Sunday, September 2, 2018 4:06 PM
Another update (for anyone that cares) 😀 I did some tests with running the process...
--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)

September 2, 2018 at 7:50 pm

#2004237
RE: The Game is Afoot

Andy Warren - Sunday, September 2, 2018 9:10 AM
Thank you all for reading and the comments! Jeff, I think that 14 mil...
--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)

September 2, 2018 at 4:04 pm

#2004234
RE: Can't Get BULK INSERT TO ERROR!!!

You don't need SSIS for this. You need proper constraints on your table and that includes if you're using SSIS. The constraints will cause BULK INSERT to fail and sequester...
--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)

September 2, 2018 at 3:59 pm

#2004233
RE: Order of Clustered Index

Mike Scalise - Sunday, September 2, 2018 10:18 AM
Sorry for the delay. My wife went into labor a week early so I've...
--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)

September 2, 2018 at 3:49 pm

#2004232
RE: Hide a column from other user in MSSQL

Google is your friend... here's just one link on the subject.,
https://sqlstudies.com/2015/11/12/hiding-one-or-more-columns/
The real key may be to ask the question, why does the user have access 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)

September 2, 2018 at 3:42 pm

#2004231
RE: Balancing Writes

coolchaitu - Sunday, September 2, 2018 8:02 AM
Thanks Jeff. Happy long weekend
Thank you. It just needs to get started. The boss...
--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)

September 2, 2018 at 3:07 pm

#2004230
RE: Balancing Writes

coolchaitu - Sunday, September 2, 2018 6:46 AM
Jeff Moden - Sunday, September 2, 2018 6:39 AM
--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)

September 2, 2018 at 7:52 am

#2004223
RE: Balancing Writes

coolchaitu - Sunday, September 2, 2018 3:48 AM
andycadley - Sunday, September 2, 2018 2:33 AM
--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)

September 2, 2018 at 6:39 am

#2004216
RE: How to Generate a common unique column for multiple views

Naidu PK - Friday, August 31, 2018 2:36 PM
I created 3 different views and I need a common column to join these...
--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)

September 1, 2018 at 8:14 pm

#2004207
RE: Balancing Writes

coolchaitu - Saturday, September 1, 2018 3:51 PM
SGT_squeequal - Saturday, September 1, 2018 3:38 PM
--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)

September 1, 2018 at 7:57 pm

#2004206
RE: Code to list dates end of month dates between specific start and end date ranges

alexander.lummer - Friday, August 31, 2018 12:31 PM
Caps out at 100 rows where there should be more? this i would def hope...
--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)

August 31, 2018 at 8:42 pm

#2004197
RE: [RESOLVED] How to cast string (with comma or/and decimal) to integer/decimal?

Instead of using expensive REPLACEs, you could always convert it to the MONEY datatype and then to DECIMAL. The MONEY datatype takes commas in stride.
--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)

August 31, 2018 at 8:38 pm

#2004196
RE: The Game is Afoot

I'm glad that someone else still likes SQL Profiler. 😀
As for that 10-15% CPU thing? The only time I don't cringe at that is when a large batch...
--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)

August 31, 2018 at 8:34 pm

#2004195
RE: Interesting question about NCI's when converting HEAPs to CI's

Interesting... earlier today, I ran the following code and it said "Error near ONLINE" and would not execute.
ALTER TABLE dbo.Trans
ADD CONSTRAINT PK_Trans PRIMARY KEY CLUSTERED ([Iterator]) WITH (ONLINE =...
--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)

August 31, 2018 at 8:05 pm

#2004194

Viewing 15 posts - 11,326 through 11,340 (of 59,102 total)