Viewing 15 posts - 19,021 through 19,035 (of 59,072 total)
eluriraja (12/6/2015)
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
Change is inevitable... Change for the better is not.
December 7, 2015 at 9:16 pm
Since we don't have your data nor even your table structure, I have to ask... what is the code not doing?
--Jeff Moden
Change is inevitable... Change for the better is not.
December 7, 2015 at 6:46 pm
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
Change is inevitable... Change for the better is not.
December 7, 2015 at 10:15 am
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
Change is inevitable... Change for the better is not.
December 6, 2015 at 1:05 pm
I'm thinking that it still might be a privs thing for the login that SQL Server Agent uses.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 6, 2015 at 1:01 pm
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
Change is inevitable... Change for the better is not.
December 6, 2015 at 12:51 pm
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
Change is inevitable... Change for the better is not.
December 6, 2015 at 12:39 pm
ramadesai108 (12/4/2015)
I have resolved the issue.
Cool! Please post your solution.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 5, 2015 at 8:46 pm
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
Change is inevitable... Change for the better is not.
December 5, 2015 at 8:44 pm
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
Change is inevitable... Change for the better is not.
December 5, 2015 at 8:36 pm
smmkr17 (12/5/2015)
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
Change is inevitable... Change for the better is not.
December 5, 2015 at 8:20 pm
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
Change is inevitable... Change for the better is not.
December 5, 2015 at 8:14 pm
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
Change is inevitable... Change for the better is not.
December 5, 2015 at 8:23 am
Please see the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
--Jeff Moden
Change is inevitable... Change for the better is not.
December 5, 2015 at 8:19 am
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
Change is inevitable... Change for the better is not.
December 5, 2015 at 8:11 am
Viewing 15 posts - 19,021 through 19,035 (of 59,072 total)