Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,381 through 10,395 (of 59,102 total)

RE: SQL Server Active Directory helper?

mayurambokar - Thursday, January 8, 2009 3:38 AM
HiI am not able to start SQL Server Active Directory helper in my server 2003....
--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 16, 2018 at 8:53 am

#2016396
RE: Stumped trying to shred XML data into table rows

A fellow by the name of Orlando Colamatteo posted a trick for displaying long strings a long time ago at the following...
--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 16, 2018 at 8:46 am

#2016395
RE: Subquery - another way to achieve the same result?

Since no one specifically identified it and with the idea of teaching a man to fish and how to unsnarl his reel, the other thing that Scott's code does is...
--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 16, 2018 at 8:17 am

#2016393
RE: Accidental DBA - Autogrowth

While SSDs are certainly more forgiving the physical drives when it comes to fragmentation and other things, there's still no way that I'd set autogrowth to a percentage. People tend...
--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 16, 2018 at 7:59 am

#2016392
RE: Stuck Parallel Query

No problem. Thanks for the feedback.
--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 15, 2018 at 10:01 pm

#2016382
RE: Calculating duration between two dates which go over months (splitting by month)

alex.richards - Friday, December 14, 2018 5:31 AM
Thom A - Friday, December 14, 2018 5:28 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)

December 15, 2018 at 9:55 pm

#2016381
RE: How can I combine the three queries to one and possibly improve performance

PasLe Choix - Thursday, December 13, 2018 7:58 AM
Jeff Moden - Wednesday, December 12, 2018 8:00 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)

December 13, 2018 at 9:08 pm

#2016278
RE: The Number that shouldn't be a number

RonKyle - Thursday, December 13, 2018 12:41 PM
Eric M Russell - Thursday, December 13, 2018 12:19 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)

December 13, 2018 at 1:39 pm

#2016261
RE: Need some help with some "XML Hell" please.

Eirikur Eiriksson - Monday, May 29, 2017 2:59 PM
Ed Wagner - Monday, May 29, 2017 2:40 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)

December 12, 2018 at 10:54 pm

#2016181
RE: Get all Attributes from this XML

drew.allen - Wednesday, December 12, 2018 9:33 AM
info 58414 - Wednesday, December 12, 2018 8:24 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)

December 12, 2018 at 9:00 pm

#2016178
RE: Interesting Use Case Of CEILING

Jonathan AC Roberts - Wednesday, December 12, 2018 4:16 PM
I think this might answer your question:
DECLARE @percentComplete float =...
--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 12, 2018 at 8:52 pm

#2016177
RE: How can I combine the three queries to one and possibly improve performance

PasLe Choix - Wednesday, December 12, 2018 7:37 PM
Lynn Pettis - Wednesday, December 12, 2018 9:36 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)

December 12, 2018 at 8:00 pm

#2016174
RE: Max Degree of Parallelism

lmalatesta - Wednesday, December 12, 2018 7:54 AM
Jeff Moden - Tuesday, December 11, 2018 6:19 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)

December 12, 2018 at 7:54 pm

#2016173
RE: Invalid Parsename

chris geswein - Wednesday, December 12, 2018 9:52 AM
Jeff Moden - Wednesday, December 12, 2018 6: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)

December 12, 2018 at 7:50 pm

#2016172
RE: Converting IO/s to MB/s

PHXHoward - Friday, October 12, 2018 3:02 PM
Hey everyone. We are looking at replacing a physical server with a VM and want...
--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 12, 2018 at 7:17 pm

#2016170

Viewing 15 posts - 10,381 through 10,395 (of 59,102 total)