Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,021 through 19,035 (of 59,072 total)

RE: Responsibilities of L1-DBA

eluriraja (12/6/2015)
Hello sir, i'm Raja..
I've opening on L1- DBA....
So I want to know about the " Responsibilities of L1-DBA "...
SO Can you tell me " What are 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)

December 7, 2015 at 9:16 pm

#1844538
RE: TSQL Recursive Help

Since we don't have your data nor even your table structure, I have to ask... what is the code not doing?
--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)

December 7, 2015 at 6:46 pm

#1844523
RE: report print layout fine but normal layout ko

Andy H Kwok (12/6/2015)
Hi Jeff,
Thanks but do you have more meaty insights by any chance? 🙂
Best,
Andy
Unfortunately, no. The two views of reports were designed to provide different functionality and...
--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)

December 7, 2015 at 10:15 am

#1844435
RE: Regarding Transaction log backup

SQL-DBA-01 (12/4/2015)
Thnx...That is how it works. I will pass on the links to d other db champs..
I've been following a lot of your posts over the last 6 months. ...
--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)

December 6, 2015 at 1:05 pm

#1844257
RE: Sql Agent Job doesn't populate data but executing tsql does?

I'm thinking that it still might be a privs thing for the login that SQL Server Agent uses.
--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)

December 6, 2015 at 1:01 pm

#1844255
RE: using BCP to import data where first record is different

With only 5 "fields", I'll typically import each row as a whole row and split it using DelimitedSplit8K ( see the "Resources" section at the bottom of the article located...
--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)

December 6, 2015 at 12:51 pm

#1844254
RE: report print layout fine but normal layout ko

I guess I don't understand why you think they'd be the same to begin with. If they were the same, then they wouldn't need one or the other. ...
--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)

December 6, 2015 at 12:39 pm

#1844253
RE: Do not display Row_Number OVER column in result set

ramadesai108 (12/4/2015)
I have resolved the issue.
Cool! Please post your solution.
--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)

December 5, 2015 at 8:46 pm

#1844231
RE: Generate sequence of numbers between values

TheSQLGuru (12/4/2015)
P.S. Hope I get to see you Jeff at the Cleveland SQL Saturday in February!
I really like presenting at Cleveland. Hopefully, they'll pick my session to give me...
--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)

December 5, 2015 at 8:44 pm

#1844230
RE: Tempdb configuration advice

vsamantha35 (12/3/2015)
•No of physical cpus= 2
•no of logical cpu count = 24
I'm thinking that the logical to physical CPU ratio on that box is the real problem.
--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)

December 5, 2015 at 8:36 pm

#1844229
RE: SQL Query

smmkr17 (12/5/2015)
Current table
ColA ColB ColC
A 1 Yes
A 2 No
A 1 Yes
A 1 Yes
B 1 Yes
B 2 Yes
C 1 Yes
D 1 No
My result should be
A No
B Yes
C No
If ColA Values A,B...
--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)

December 5, 2015 at 8:20 pm

#1844227
RE: Inserting rows a row at a time instead of in batches- RBAR is faster???

MadAdmin (12/5/2015)
Proof is in the pudding always. Try the set based and measure. Then try the rbar and measure. Especially when the advice sounds odd.
Make the person that made 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)

December 5, 2015 at 8:14 pm

#1844226
RE: Are the posted questions getting worse?

SQLRNNR (12/4/2015)
Jeff Moden (12/4/2015)
K. Thanks. Something's wrong. Nothing in my spam locker, either.
It's happened off and on.
Sometimes tweaking your subscriptions (delete on and re-add it) helps.
K. Thanks. ...
--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)

December 5, 2015 at 8:23 am

#1844207
RE: Help me with this syntax (1Customer code note more)

Please see the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
--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)

December 5, 2015 at 8:19 am

#1844205
RE: SQL Server tables size

river1 (12/5/2015)
Hi,
Wich t-sql command can I run tho have a list of the user-tables ordered by size inside one database?
Thank you
If you just want to see the tables, then open...
--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)

December 5, 2015 at 8:11 am

#1844204

Viewing 15 posts - 19,021 through 19,035 (of 59,072 total)