Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,246 through 19,260 (of 59,072 total)

RE: Tricky Problem with Group by Clause

pshrvankumar (11/4/2015)
Hi All,
I have trapped with below problem, which am facing this issue from last 4 days, below is my table: CSAT
EQIDRevis FileName JobcodeJobqalMaterial
11Mick ...
--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)

November 4, 2015 at 11:10 pm

#1837864
RE: DIFFERENCE BETWEEN NOLOCK VS WITH(NOLOCK) IN SQL SERVER 2008

Sergiy (11/4/2015)
I would suggest (if NOLOCK is a requirement) to use NOLOCK, not WITH (NOLOCK).
NOLOCK without brackets is not a hint, but a table name alias.
So, the query would 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)

November 4, 2015 at 11:08 pm

#1837863
RE: Hash on a column in a table

kbnyny (11/4/2015)
I know nothing about hash on a table but I need a lot of help on this. Here what I want to accomplish, I have table that has...
--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)

November 4, 2015 at 4:16 pm

#1837830
RE: running sql profiler

ramyours2003 (11/4/2015)
is running a profiler will make the tempdb grow?
Depending on where you run it from and how you run it, it can make a file on your...
--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)

November 4, 2015 at 4:14 pm

#1837829
RE: SSMS Help system buggy ?

Apologies for the obvious question... did you download "Books Online" (the help system you're looking for) and install it? It is no longer installed automatically nor even provided 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)

November 4, 2015 at 4:09 pm

#1837828
RE: Downgrade SQL Server / Install Master Database

tress (11/4/2015)
Very good question 🙂 I don't believe you can use the developer edition in a production live environment. At the moment I am trying to replicate what 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)

November 4, 2015 at 4:06 pm

#1837826
RE: XP_CMDSHELL fails execution

I'll also add that no one except DBAs that have "SA" privs should ever be allowed to execute xp_CmdShell directly. It's one of those rare instances where I'll actually...
--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)

November 4, 2015 at 3:58 pm

#1837825
RE: Are the posted questions getting worse?

Brandie Tarvin (11/4/2015)
Jeff Moden (11/3/2015)
Man o man... yet another self-proclaimed DBA bites the dust in the interview process as has another self-proclaimed "expert" Database Developer. It amazing how they...
--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)

November 4, 2015 at 10:42 am

#1837747
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (11/4/2015)
GilaMonster (11/3/2015)
Jeff Moden (11/3/2015)
No takers on the job description I posted a while back?
Wrong country.
and wrong state
Oh my. Now THAT would be 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)

November 4, 2015 at 8:42 am

#1837700
RE: Are the posted questions getting worse?

GilaMonster (11/3/2015)
Jeff Moden (11/3/2015)
No takers on the job description I posted a while back?
Wrong country.
For sure. The boss there would love what you can do, Gail.
--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)

November 4, 2015 at 8:40 am

#1837696
RE: Are the posted questions getting worse?

anthony.green (11/4/2015)
Jeff Moden (11/3/2015)
No takers on the job description I posted a while back?
Remote working an option?
Unfortunately, probably not for this one, Anthony. I will ask, though....
--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)

November 4, 2015 at 8:39 am

#1837695
RE: Kill hung xp_cmdshell child process from SQL

Yes there is. I'll post it tonight.
--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)

November 4, 2015 at 8:37 am

#1837694
RE: Find All Items That Call a Stored Procedure

andrew.mills 44498 (11/3/2015)
As much as I appreciate the suggestion and code, I should have stated I do not have the permission required to create a new table, nor make changes...
--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)

November 4, 2015 at 7:34 am

#1837663
RE: Learn to Use Filegroups

Gary Varga (11/4/2015)
So there is far more to File Groups than I had imagined. If anyone is considering writing an article (I recall GilaMonster and RonKyle saying that they might...
--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)

November 4, 2015 at 7:08 am

#1837648
RE: Learn to Use Filegroups

Steve Jones - SSC Editor (5/12/2011)
Alan Vogan (5/12/2011)
In SQL Server, we can't split a table across filegroups. Or can we?
I was just asked that question! The idea that...
--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)

November 4, 2015 at 7:00 am

#1837644

Viewing 15 posts - 19,246 through 19,260 (of 59,072 total)