Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,801 through 19,815 (of 59,072 total)

RE: Sorting in Powershell

I guess my question would be... why on Earth are you doing this in PowerShell?
--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 20, 2015 at 5:31 pm

#1821566
RE: Fine tuning Queries

mufadalhaiderster (8/20/2015)
It would be a good practice for some of you experts.
Heh... actually, it would be good practice for YOU! 😉 Download Grant Frichey's free book on execution plans...
--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 20, 2015 at 5:26 pm

#1821565
RE: The Road to Success

Iwas Bornready (8/20/2015)
I just worry about the programmers that want to "fix" something that isn't broken, just to make it more efficient. As often as not they really don't understand...
--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 20, 2015 at 1:02 pm

#1821529
RE: forecasting projection--how to approach this?

dandenise316 (8/20/2015)
Correct sir, but how to calculate that multiplier?
I'm interested in finding out what the average responses / applications, etc are based upon the mailer volume and mailer type fields....
--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 20, 2015 at 10:52 am

#1821483
RE: Machine needs for developing and running sql

Ben Whyall (8/20/2015)
Hi
I'm not sure this is the best forum but i'm hoping its the best fit.
I am a developer mostly working on .net applications with a SQL...
--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 20, 2015 at 10:40 am

#1821479
RE: How to Recover Database without Backup

crickwilli (8/20/2015)
Get more effective safe and secure software, you can download third-party software, Kernel for SQL Database Recovery Tool. This software easy to recover complete database objects available in .MDF...
--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 20, 2015 at 8:37 am

#1821430
RE: PDF iFilter problems (again!)..

Jeff ingham (3/12/2014)
...hopefully this might save someone from premature hair loss!
Apparently, it DID! Well done!
--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 20, 2015 at 8:27 am

#1821424
RE: Multiple records on one row..

ByronOne (8/20/2015)
Cheers Chris
I'll give this a whirl.
Thanks for the really speedy response!
BO
The question now is, do you understand how and why it works?
I ask because Chris' fine...
--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 20, 2015 at 8:07 am

#1821410
RE: SQL Turn Row data to Column

Eirikur's CROSSTAB solution is an effective solution for when the maximum number of items is 3 and can be easily converted for larger known maximums. It's also easily converted...
--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 20, 2015 at 8:04 am

#1821408
RE: SQL Turn Row data to Column

Jayanth_Kurup (8/20/2015)
@jeff Looks like a perfect example on using dynamixc SQL 🙂
Nah. Not for this. It's a simple CROSSTAB or PIVOT problem, especially since it's known that there...
--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 20, 2015 at 8:01 am

#1821404
RE: BCP Command with headers

vikramchander90 (8/20/2015)
Hi,
I have a table which has few columns as Numeric value. I need to export the ouptut into a csv file as a report with column headers. 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)

August 20, 2015 at 7:41 am

#1821390
RE: Find working time of each employee

Really, really looks like and sounds like homework. Even if it's not, you should at least try. And rules 4, 5, and 6 create an oxymoron because 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)

August 20, 2015 at 12:14 am

#1821263
RE: The Road to Success

One of my previous bosses said that "If you don't make mistakes, I'm not pushing you hard enough".
While I agree with that, the place to experiment and make mistakes 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)

August 19, 2015 at 11:59 pm

#1821262
RE: Where IN @txtVariable (where txtVariable is a CSV list)

Kevlarmpowered (8/19/2015)
My DBAs frown on dynamic SQL...
They REALLY need to get over that. Properly written dynamic SQL is SQL Injection proof, safe, fast, and will cache an execution...
--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 19, 2015 at 11:52 pm

#1821260
RE: Hiding the security folder from contractors using SMSS

hurricaneDBA (8/19/2015)
Dear Everyone
I am setting up a database for one contractor who needs to access one of our databases but i need to remove the permission for them to view...
--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 19, 2015 at 11:51 pm

#1821259

Viewing 15 posts - 19,801 through 19,815 (of 59,072 total)