Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,481 through 21,495 (of 59,098 total)

RE: Are the posted questions getting worse?

Just curious... does anyone use RedGate Compare to promote code from Dev to Staging to Prod? Looking for both positive and negative comments on experiences. Thanks folks.
--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 24, 2015 at 10:41 am

#1779677
RE: Trying to insert results from sp_spaceused (tablename) into different table.

Remove the parenthesis and the related single quotes from the EXEC.
--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 23, 2015 at 11:26 pm

#1779486
RE: disk drive is almost full

Sounds like an interview question.
--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 23, 2015 at 11:24 pm

#1779485
RE: Job in Rollback not showing in Activity Monitor

Doe the job use xp_CmdShell or a CmdExec step?
--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 23, 2015 at 11:18 pm

#1779484
RE: Remove the double quote

kennyhuang0108 (2/23/2015)
Thanks Lowell.
I just checked with my boss and the strings can be double quoted.
Thank you very much for your time.
Hope in the future, i wont post...
--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 23, 2015 at 10:28 pm

#1779479
RE: How to get Desired Out Put Like

suresh0534 (2/17/2015)
Hi,
Below is the My Table data...
TypeUser Name region duration1duration2dailsMathSilverGold
ARamesh Section01 ...
--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 23, 2015 at 8:17 pm

#1779471
RE: How to return top n and sum up the rest

Heh... deleted my post. I was having too much fun. 🙂
--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 23, 2015 at 8:09 pm

#1779470
RE: Are the posted questions getting worse?

Lynn Pettis (2/23/2015)
Mark one off, 100 days on the calendar to go. 100 days on the calendar to go, 100 days to go, ...[/i]
Careful, now. Someone might read...
--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 23, 2015 at 7:49 pm

#1779465
RE: sp_Blitz Last good DBCC CHECKDB over 2 weeks old - tempdb

Now that's some good info. Thanks, Ola.
--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 23, 2015 at 7:45 pm

#1779464
RE: Queries and Joining tables

LinksUp (2/23/2015)
Jeff Moden (2/23/2015)
Heh... table names as plural nouns. Makes for some interesting and non-automatable naming conventions.
So, let me ask... do you have an Employee table or an Employees...
--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 23, 2015 at 7:28 pm

#1779460
RE: Queries and Joining tables

spaghettidba (2/23/2015)
Jeff Moden (2/23/2015)
spaghettidba (2/23/2015)
Highly debatable...
The ISO standards suggest that table names are pluralized. I admit that I agree with Celko on this one.
No problem... I don't follow those either....
--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 23, 2015 at 7:08 pm

#1779459
RE: Queries and Joining tables

spaghettidba (2/23/2015)
Highly debatable...
The ISO standards suggest that table names are pluralized. I admit that I agree with Celko on this one.
No problem... I don't follow those either. 😛
--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 23, 2015 at 1:01 pm

#1779395
RE: sp_Blitz Last good DBCC CHECKDB over 2 weeks old - tempdb

Ola Hallengren (2/23/2015)
In the latest version you can do like this:
EXECUTE dbo.DatabaseIntegrityCheck @Databases = 'SYSTEM_DATABASES,tempdb', @CheckCommands = 'CHECKDB'
Please send me a mail for more details.
Ola Hallengren
https://ola.hallengren.com
Rather than taking it offline,...
--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 23, 2015 at 9:42 am

#1779318
RE: Data insertion from staging table to main table.

Shifting gears a bit, the whole idea of a staging table is to pre-validate rows of data so that you don't end up with such a problem as rollbacks. ...
--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 23, 2015 at 9:12 am

#1779303
RE: Queries and Joining tables

Heh... table names as plural nouns. Makes for some interesting and non-automatable naming conventions.
So, let me ask... do you have an Employee table or an Employees table? 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)

February 23, 2015 at 9:01 am

#1779299

Viewing 15 posts - 21,481 through 21,495 (of 59,098 total)