Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,581 through 14,595 (of 59,101 total)

RE: Trying to create function to create folders (and sub folders)

If you don't mind a little help from "undocumented code", the following will easily do exactly what you want. This is what SQL Server uses to make directories for backups. ...
--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 21, 2017 at 2:04 pm

#1956061
RE: Hiring Heterogeneously

djackson 22568 - Monday, August 21, 2017 8:50 AM
Jeff Moden - Monday, August 21, 2017 12:22 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)

August 21, 2017 at 12:24 pm

#1956044
RE: Hiring Heterogeneously

TomThomson - Sunday, August 20, 2017 7:09 PM
David.Poole - Thursday, August 17, 2017 4:03 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)

August 21, 2017 at 12:22 am

#1955944
RE: RAMDisk? Use it for TempDB?

JakDBA - Sunday, August 20, 2017 10:46 PM
Gail Wanabee - Wednesday, November 30, 2016 3:05 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)

August 21, 2017 at 12:20 am

#1955943
RE: How to reduce the space /shrink SQL Server 2008 R2 Data file (MDF) and Log file (LDF)

JakDBA - Sunday, August 20, 2017 10:00 PM
srik18 - Sunday, August 20, 2017 6:24 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)

August 21, 2017 at 12:14 am

#1955942
RE: Why did added partitions make cube processing slower?

I agree. Partitioning is definitely not a "Go Fast" method. It's a method for managing large datasets to reduce the need for index maintenance and can be used to seriously...
--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, 2017 at 11:17 pm

#1955939
RE: Best practices for setting up service users

DataAnalyst011 - Friday, August 18, 2017 8:28 AM
I'm very new to setting up SQL Servers, and I'm wanting be diligent about security....
--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, 2017 at 10:33 pm

#1955936
RE: 70-473 Anyone studying for this, or passed it?

Duran - Friday, August 4, 2017 9:12 PM
Hello,
I'm studying for this exam, just wondering if anyone else was?
Regards,
D
Why? What would you do...
--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, 2017 at 9:39 pm

#1955931
RE: How to reduce the space /shrink SQL Server 2008 R2 Data file (MDF) and Log file (LDF)

srik18 - Sunday, August 20, 2017 6:24 PM
Dear Guru's,
I have read that using the DBCC ShrinkFile is not the best practice but...
--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, 2017 at 9:34 pm

#1955930
RE: Opinions and Votes

patrickmcginnis59 10839 - Thursday, August 17, 2017 7:39 AM
djackson 22568 - Monday, August 19, 2013 9:25 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)

August 20, 2017 at 7:24 pm

#1955927
RE: Are the posted questions getting worse?

Ed Wagner - Sunday, August 20, 2017 11:43 AM
The spam seems to have returned with a vengeance this weekend. The first page...
--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, 2017 at 2:02 pm

#1955920
RE: Responsibility to Learn

Ed Wagner - Sunday, August 20, 2017 11:40 AM
Nice job, Grant. Short, succinct and so very, very accurate. I really like 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)

August 20, 2017 at 1:46 pm

#1955919
RE: Remove TempDB data files

Riic - Friday, August 18, 2017 3:22 AM
Thanks Anthony! Hope there is no error after removing files! TGIF enjoy...
You could always just...
--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, 2017 at 11:26 am

#1955913
RE: Responsibility to Learn

Oooo, good one, Grant. And rumor has it that it costs $250 per day to actually learn how to get the current date and time. It's actually not possible 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 19, 2017 at 9:40 pm

#1955906
RE: Hiring Guitarists

skeleton567 - Wednesday, August 16, 2017 8:05 AM
I always felt that it's not as important to know all the answers as 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)

August 18, 2017 at 8:05 pm

#1955895

Viewing 15 posts - 14,581 through 14,595 (of 59,101 total)