Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,436 through 24,450 (of 59,099 total)

RE: Oddball Interview Questions

Knut Boehnert (2/7/2014)
"How would you fill a coffee cup in T-SQL?"
I wouldn't because that's RBAR. I'd write the code to fill a million coffee cups according to size...
--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)

February 7, 2014 at 10:05 pm

#1687302
RE: OS Disk Capacity Information

My problem is that I'm still stuck with 2005 at work (apologies for forgetting to mention that on a 2K12 forum). CMS isn't possible for me at this time.
I'll...
--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)

February 7, 2014 at 9:31 am

#1687115
RE: How many partitions & files are supported in 2008R2

sqlcentral2 (2/6/2014)
Jeff Moden (2/5/2014)
sqlcentral2 (2/5/2014)
Simple question.
The partitioning scheme with indices calls for about 1100 file groups per year (one file per file group), and there is 20 years of...
--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)

February 7, 2014 at 9:27 am

#1687114
RE: OS Disk Capacity Information

wak_no1 (2/6/2014)
Thank you.
Code to retrieve disk information needed via Powershell
Get-WMIObject Win32_LogicalDisk -filter "DriveType=3" -computer (Get-Content c:\computers.txt) | Select SystemName,DeviceID,VolumeName,@{Name="size(GB)"; Expression={"{0:N1}" -f($_.size/1gb)}},@{Name="freespace(GB)";Expression={"{0:N1}" -f($_.freespace/1gb)}}
Of the back of this, I've created a table...
--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)

February 7, 2014 at 8:05 am

#1687076
RE: OS Disk Capacity Information

wak_no1 (2/6/2014)
Bob, thank you, this is working as I'd hoped. I can sort of see what I needed to do.
One thing has just occurred to me though, I need 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)

February 7, 2014 at 8:02 am

#1687073
RE: OS Disk Capacity Information

Robert klimes (2/6/2014)
try this out
$ds = New-Object system.Data.DataSet
$ds = Get-WMIObject Win32_LogicalDisk -filter "DriveType=3" -computer (Get-Content c:\computers.txt) | Select SystemName,DeviceID,VolumeName,@{Name="size"; Expression={"{0:N1}" -f($_.size/1gb)}},@{Name="freespace";Expression={"{0:N1}" -f($_.freespace/1gb)}}
foreach ($d in $ds)
{
$systemname = $d.systemname
$deviceID = $d.DeviceID
$volumename...
--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)

February 7, 2014 at 7:53 am

#1687066
RE: Are the posted questions getting worse?

Koen Verbeeck (2/7/2014)
Ed Wagner (2/7/2014)
That's one thing I really enjoy about SSC. The people here aren't paid to answer questions. We do it because we enjoy doing it,...
--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)

February 7, 2014 at 7:09 am

#1687028
RE: Are the posted questions getting worse?

Koen Verbeeck (2/6/2014)
Steve Jones - SSC Editor (2/6/2014)
However, this way they can give feedback that something worked. We are talking about how to best get other info from the "crowd"...
--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)

February 7, 2014 at 12:36 am

#1686920
RE: How comma separated values are divided into rows?

Luis Cazares (2/6/2014)
Evil Kraig F (2/6/2014)
Jeff, do you have SSIS 2k8 available to you or do you need said examples in 2k5?
That's just mean 😀
Nah... Craig knows me. 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)

February 7, 2014 at 12:26 am

#1686917
RE: How comma separated values are divided into rows?

Koen Verbeeck (2/6/2014)
Jeff Moden (2/6/2014)
Shifting gears to the idea that you came up with using "Split.String" and a loop in SSIS, I couldn't have come up with that partiicular answer...
--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)

February 7, 2014 at 12:18 am

#1686915
RE: How comma separated values are divided into rows?

Evil Kraig F (2/6/2014)
Jeff Moden (2/6/2014)
Heh... I'm used to, welcome, and embrace criticism. It's one of the tools I use to learn new things. For example, if someone...
--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)

February 7, 2014 at 12:15 am

#1686913
RE: Sending a Variable Number of Elements in a Parameter

I just reported the formatting problems for this article. Hopefully, someone at SQLServerCentral will pick up on it and fix it. Again, these problems aren't caused by 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)

February 6, 2014 at 8:42 pm

#1686886
RE: Sending a Variable Number of Elements in a Parameter

Phil Factor (2/6/2014)
Alex,
I've gone back to have a closer look at the article. It could be that I've misunderstood something, but I really think the first example could be improved....
--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)

February 6, 2014 at 8:10 pm

#1686884
RE: Sending a Variable Number of Elements in a Parameter

Alex Grinberg-230981 (2/6/2014)
I have tested CLR to split a delimited string, much slower and take bigger resources. This why I did include CLR option in my posting.
It would be interesting...
--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)

February 6, 2014 at 7:38 pm

#1686876
RE: Sending a Variable Number of Elements in a Parameter

David McKinney (2/6/2014)
Also, sorry but I find the allusion to plagiarism a little facile. This code is pretty much public domain by now, ...{snip}..., I really don't feel that...
--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)

February 6, 2014 at 6:50 pm

#1686873

Viewing 15 posts - 24,436 through 24,450 (of 59,099 total)