Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,056 through 23,070 (of 59,067 total)

RE: Do you usually go to agencies?

I've carefully hand-picked a couple of agencies and have found them to be incredibly useful especially since they're usually the first to know about new and appropriate jobs. The...
--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)

July 25, 2014 at 1:55 pm

#1732525
RE: Need Help parsing through the XML

Evil Kraig F (7/25/2014)
Glad I asked for clarification. 🙂
Me to. And fully agreed on the cross server use of table variables. It could really cut down on the...
--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)

July 25, 2014 at 12:53 pm

#1732504
RE: Are the posted questions getting worse?

Sean Lange (7/25/2014)
WOW!!! If you have ever wondered about the quality of responses at SO just checkout this response to a question about when it is appropriate to use NOLOCK.
Most...
--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)

July 25, 2014 at 12:45 pm

#1732501
RE: I am Confused about SQL Server performance

Of course, there's always the old but effective thought of not putting anything in your mouth until you look at it and smell it first. 😉
Rollbacks are incredibly expensive especially...
--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)

July 25, 2014 at 12:42 pm

#1732499
RE: Policy Based Management - Enabling Transaction Logs

swoozie (7/25/2014)
I am trying to find or write a script that is run to enable the transaction log.
Please explain what you mean above. Transaction logs are not "enabled".
--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)

July 25, 2014 at 12:27 pm

#1732495
RE: How to find number of columns returned from query in powershell

Eirikur Eiriksson (7/25/2014)
Jeff Moden (7/25/2014)
Chand00 (7/25/2014)
Hi,
Thank you. Below one worked for me.
$QueryResults[0].Table.Columns.Count
Apologies. I tried to post but I was unable to post somehow. Once again Thankyou
Still, why does this need...
--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)

July 25, 2014 at 12:24 pm

#1732494
RE: When you convert int to varchar it returns *. Why?

John Mihalko (7/25/2014)
Why does SELECT CONVERT(varchar(4),263000) or SELECT CAST( 263000 AS varchar(4)) return * ?
You would think '3000' to be return. :unsure:
Because SQL Server does not automatically do truncation 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)

July 25, 2014 at 12:21 pm

#1732492
RE: Automatically syncing database to different server

Possibly transactional replication.
--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)

July 25, 2014 at 12:15 pm

#1732487
RE: SQL Pivot?

ken.stoner (7/25/2014)
The cross tab works exactly the way I want it too!
Thank you for all your help!
Until you get a 5th row. 😉 Then, you'd need to convert 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)

July 25, 2014 at 12:05 pm

#1732481
RE: How to find number of columns returned from query in powershell

Chand00 (7/25/2014)
Hi,
Thank you. Below one worked for me.
$QueryResults[0].Table.Columns.Count
Apologies. I tried to post but I was unable to post somehow. Once again Thankyou
Still, why does this need to be done from...
--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)

July 25, 2014 at 11:45 am

#1732475
RE: How to find number of columns returned from query in powershell

Chand00 (7/25/2014)
I want to find out number of columns returned from a query in a powershell script.
As we will be passing a dynamic query which can retrieve only 2 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)

July 25, 2014 at 11:16 am

#1732470
RE: Cross Join Help

dwilliscp (7/25/2014)
I have a massive table (company, plant, resource, part number) that I need to create a from part number, to part number for every part within "Company, Plant, Resource"...
--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)

July 25, 2014 at 11:12 am

#1732469
RE: Get next 2 weeks

sharonsql2013 (7/25/2014)
True, I cannot change the table .
Name is the name of the person , Project is the projectname and all the weeks represent the hours worked on the...
--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)

July 25, 2014 at 11:01 am

#1732465
RE: Exploring Recursive CTEs by Example

David McKinney (7/17/2012)
I love it! Especially the conclusion.
It's time we stopped being afraid to whisper the words 'Recursive CTE' for fear of being heard by the RBAR...
--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)

July 25, 2014 at 9:41 am

#1732433
RE: Latin1_General_BIN Collation

Eric Humphrey (7/24/2014)
Choose Windows collation.
Designer: Latin1_General
Check Binary. All other options become invalid at that point.
I realize that you and I have just answered a 2 year post but I thought...
--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)

July 24, 2014 at 7:19 pm

#1732235

Viewing 15 posts - 23,056 through 23,070 (of 59,067 total)