Jeff Moden

Forum Replies Created

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

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
RE: Update SQL with excel files?

Thom A - Wednesday, April 5, 2017 1:49 AM
stino - Tuesday, April 4, 2017 11:09 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 7:42 am

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

usenet - Wednesday, April 5, 2017 4:19 AM
The last query posted by SQL_Elvis is actually wrong:
CAST(FILEPROPERTY(name,''SpaceUsed'') AS INT) UsedSpaceMB,
should be
--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:39 am

#1936782
RE: Should I listen to this recommendation to change data lengths for consistency during ETL?

Andrew P - Wednesday, April 5, 2017 3:16 AM
The source database is the Microsoft sample database AdventureWorksLT 2012. I'm not sure why...
--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:25 am

#1936778
RE: Just the time, please

Actually (and without giving up the correct answer here), none of the answers are correct because the correct answer doesn't have enough zeroes to the right of the decimal point....
--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 4, 2017 at 11:04 pm

#1936692

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