Jeff Moden

Forum Replies Created

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

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
RE: Hiring Guitarists

patrickmcginnis59 10839 - Wednesday, August 16, 2017 11:32 AM
"The "what", "why", "when", and "how" is important to being able to 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 18, 2017 at 7:52 pm

#1955894
RE: Subroutines in TSQL

@Lynn,
Consider the use of QUOTENAME in your REPLACE to help mitigate SQL Injection even when you use hard-coded brackets.
--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 17, 2017 at 12:02 pm

#1955705
RE: Subroutines in TSQL

dmeissner - Thursday, August 17, 2017 7:48 AM
Listen guys, I apologize for getting uptight. Maybe you guys do things different here by...
--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 17, 2017 at 11:45 am

#1955698
RE: Subroutines in TSQL

dmeissner - Tuesday, August 15, 2017 10:54 PM
Lyle,
I'm sorry you don't understand that this is a hypothetical example. There is no schema except that which the viewer chooses. Variables such as my_database, my_table, and my_column are clearly placeholders where one can simply swap out to match their schema. Nothing more.
I didn't feel it was necessary to include code for creating...
--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 16, 2017 at 10:29 pm

#1955600

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