Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,871 through 15,885 (of 59,098 total)

RE: A Possible Alternative to SQL UNPIVOT

Just to ask the question again, would someone show me how to apply this XML method of unpivoting to a whole table instead of just one row? 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)

January 18, 2017 at 5:34 pm

#1923582
RE: A Possible Alternative to SQL UNPIVOT

drew.allen - Wednesday, January 18, 2017 1:04 PM
Jeff Moden - Monday, January 16, 2017 4:16 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)

January 18, 2017 at 5:31 pm

#1923581
RE: Alter index at same time as updte statistics caused deadlock - recommendations

Actually, it may not be a futile exercise. I do agree that rebuilding the indexes to reenable them will rebuilt the stats for those indexes but that will not include...
--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 17, 2017 at 9:02 pm

#1923321
RE: T-SQL Puzzle

Koen Verbeeck - Tuesday, January 17, 2017 7:05 AM
Thanks for the question. Now you only have to put the semicolon not on...
--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 17, 2017 at 8:30 pm

#1923317
RE: A Possible Alternative to SQL UNPIVOT

Not sure that the author of this article can post back so can anyone else answer my question at the top of the previous post? I'd like to do 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 17, 2017 at 6:38 pm

#1923311
RE: Database Diagram of Information_Schema.

ScottPletcher - Tuesday, January 17, 2017 12:32 PM
For SQL Server, you should ignore the INFORMATION_SCHEMA views and use system views instead, such as sys.tables, sys.columns,...
--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 17, 2017 at 5:41 pm

#1923309
RE: Manual Cleanup of Change Tracking in SQL Server 2014

This is a part of the reason why I grow my own auditing. It can be scheduled, controlled, and tuned for the least impact and resource usage/commitment.
--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 17, 2017 at 5:30 pm

#1923305
RE: split one column into two based on numbers (NOT PIVOT)

wweraw25 - Wednesday, January 11, 2017 8:48 AM
To be more specific this is what I meanColumn1452234515235642162895631628742330245123314518313245263231458142Column AColumn B1452234530245123152356423145183116289563324526321628742331458142
How is that any more specific...
--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 17, 2017 at 5:24 pm

#1923304
RE: split one column into two based on numbers (NOT PIVOT)

wweraw25 - Wednesday, January 11, 2017 8:34 AM
I have a column something like belowNumber1452234515235642162895631628742330245123314518313245263231458142I need to split into two columnsNumber 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 17, 2017 at 5:21 pm

#1923303
RE: Get All Participants and their unread message

drew.allen - Tuesday, January 17, 2017 3:24 PM
sgmunson - Tuesday, January 17, 2017 3:09 PM
Any chance...
--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 17, 2017 at 4:40 pm

#1923301
RE: Addressing my biggest objection to using sys.sp_executesql…

Ah, understood. Thanks, Jason.
Hmmm... maybe you should submit an article on this.
--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 17, 2017 at 4:30 pm

#1923299
RE: Addressing my biggest objection to using sys.sp_executesql…

Jason A. Long - Tuesday, January 17, 2017 11:14 AM
Seriously? The new forum format is going to replace ending parens with smirky...
--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 17, 2017 at 12:16 pm

#1923254
RE: Delaying Patches is Problematic

Interesting article. Substitute the word "performance" or "accuracy" for all instances of the word "security" and it makes the article 3 times as important.<
--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 17, 2017 at 12:09 pm

#1923251
RE: Powershell vs Sqlcmd

Sue_H - Tuesday, January 17, 2017 11:07 AM
Jeff Moden - Tuesday, January 17, 2017 9:57 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)

January 17, 2017 at 11:39 am

#1923246
RE: Powershell vs Sqlcmd

Steve Jones - SSC Editor - Tuesday, January 17, 2017 9:40 AM
I hate centralized systems. That creates a single point of failure...
--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 17, 2017 at 9:57 am

#1923215

Viewing 15 posts - 15,871 through 15,885 (of 59,098 total)