Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,241 through 15,255 (of 59,101 total)

RE: Installing SQL Server: How much space to allocate for each drive?

lindsayscott23 - Thursday, April 6, 2017 5:57 AM
Jeff Moden - Wednesday, April 5, 2017 11:58 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)

April 6, 2017 at 12:19 pm

#1937109
RE: Need SQL Training Recommendations

james.mobley - Monday, April 3, 2017 9:36 AM
Yes, it is going to be very challenging. That's why I have been so thankful...
--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)

April 6, 2017 at 12:11 pm

#1937105
RE: I want back my Points

SQLRNNR - Thursday, April 6, 2017 10:15 AM
Thom A - Thursday, April 6, 2017 8:11 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)

April 6, 2017 at 11:59 am

#1937102
RE: I want back my Points

gvoshol 73146 - Thursday, April 6, 2017 5:50 AM
An interesting question, but it could have been more interesting.
You could have added more...
--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)

April 6, 2017 at 8:04 am

#1937048
RE: Disappearing SSMS keyboard shortcut!

miapjp - Wednesday, April 5, 2017 4:21 PM
Aha! I was looking at keyboard --> Query shortcuts.... It took me a bit 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)

April 5, 2017 at 10:07 pm

#1936955
RE: XCOPY failing via xp_cmdshell

homebrew01 - Tuesday, April 4, 2017 8:39 AM
I am trying to copy files from our hosting site server to pur local server...
--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)

April 5, 2017 at 10:03 pm

#1936954
RE: Index and or constraint

andis59 - Wednesday, April 5, 2017 12:44 PM
Jeff Moden - Wednesday, April 5, 2017 12:09 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)

April 5, 2017 at 4:54 pm

#1936937
RE: How to join these tables together

jcelko212 32090 - Wednesday, April 5, 2017 12:57 PM
I can make the next sequence value into a default for a column,...
--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)

April 5, 2017 at 4:40 pm

#1936936
RE: Are the posted questions getting worse?

WayneS - Tuesday, April 4, 2017 11:37 AM
FYI: This happened to me this weekend
Absolutely awesome, ol' friend. Congratulations!
--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)

April 5, 2017 at 4:23 pm

#1936935
RE: Index and or constraint

andis59 - Wednesday, April 5, 2017 8:15 AM
Jeff Moden - Wednesday, April 5, 2017 7:50 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)

April 5, 2017 at 12:09 pm

#1936882
RE: Installing SQL Server: How much space to allocate for each drive?

lindsayscott23 - Wednesday, April 5, 2017 9:58 AM
Thanks both for the suggestions; really helpful.
The server will be a development environment, so 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)

April 5, 2017 at 11:58 am

#1936880
RE: Installing SQL Server: How much space to allocate for each drive?

andrew gothard - Wednesday, April 5, 2017 10:31 AM
lindsayscott23 - Wednesday, April 5, 2017 9:58 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)

April 5, 2017 at 11:47 am

#1936878
RE: QUERY: GET SPACE USED/FREE in All Databases

usenet - Wednesday, April 5, 2017 7:43 AM
actually, there is another "glitch" in the code:
The column "DbName" should read logical_filename instead,...
--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)

April 5, 2017 at 8:09 am

#1936795
RE: Installing SQL Server: How much space to allocate for each drive?

Whatever you do, make sure that it's easy to add drive space at the drop of a hat... any hat.
I'd also avoid installing anything of SQL Server 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)

April 5, 2017 at 7:56 am

#1936789
RE: Index and or constraint

andis59 - Wednesday, April 5, 2017 12:35 AM
Here is some more information.
The data is used for creating a marking of a product....
--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)

April 5, 2017 at 7:50 am

#1936788

Viewing 15 posts - 15,241 through 15,255 (of 59,101 total)