Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,276 through 19,290 (of 59,098 total)

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
RE: Learn to Use Filegroups

BJ Hermsen (5/12/2011)
One of the databases I support uses a large number of file groups to seperate different types of data. Base tables are seperated among many of them...
--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 6:42 am

#1837637
RE: calculate and display week between two dates

The "WEEK" date part is based on the "DATEFIRST" server setting. If you change servers (especially multi-country) or if someone gets some sort of date religion and changes 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)

November 4, 2015 at 6:30 am

#1837631
RE: Ad hoc Backup Policy - prior to applying small changes

This is where proper Point-in-time backups can help a lot.
That notwithstanding and depending on the change, I may backup separate tables using SELECT INTO to copy the data to a...
--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 6:21 am

#1837626
RE: Inherited HUGE db with limited disk space

Don't shrink it. It'll just make matters worse... MUCH worse and you still have disk space.
What's your maintenance for indexes and do you have any HEAP tables that are...
--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 3, 2015 at 4:35 pm

#1837504

Viewing 15 posts - 19,276 through 19,290 (of 59,098 total)