Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,246 through 25,260 (of 59,102 total)

RE: Looking for a Sr. SQL DBA out of SF

Amber,
Some typical questions to help you in your quest...
City and State?
Can the job be filled by someone working remotely?
--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 2, 2013 at 10:48 am

#1670171
RE: Cannot restore database. Cannot get exclusive accesss

Markus (12/2/2013)
Create this stored Proc, run it as a step before your restore step. I use this to refresh NonProd databases all the time. The syntax for 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 2, 2013 at 10:44 am

#1670168
RE: regarding automatic backup job

For the record, I don't actually use Maintenance Plans to do backups. I've developed my own stored procedures that are scheduled as jobs. Maintenance Plans just don't fit...
--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 2, 2013 at 8:47 am

#1670137
RE: Query performance

GilaMonster (12/2/2013)
Worth noting that a restore clears the plan cache for the restored database, so plans could not have persisted from before the restore.
Absolutely understood and agreed. I was...
--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 2, 2013 at 8:45 am

#1670136
RE: Identify Duplicate Records according to Multiple Criteria

ChrisM@Work (12/2/2013)
Here's the simplest way. Without further information it's unlikely to be the best.
-- I have an Employee table with Columns:
DROP TABLE #Employee
CREATE TABLE #Employee (EmpID INT IDENTITY(1,1), FirstName VARCHAR(100),...
--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 2, 2013 at 8:36 am

#1670135
RE: Easy Question: Organizing Data Flows

Phil Parkin (12/2/2013)
Jeff Moden (12/1/2013)
I don't use SSIS but, speaking from an old dude's perspective, I'd likely make the loading of each table a separate package for reusability and then...
--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 2, 2013 at 8:31 am

#1670133
RE: Fusion-IO or Nimble?

Any thoughts on this, folks? 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 2, 2013 at 12:44 am

#1670013
RE: regarding automatic backup job

One way is to setup a maintenance plan for each of the 3 backup types. If you don't know what a "maintenance plan" is, get into SSMS and press...
--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 1, 2013 at 11:37 pm

#1670007
RE: Question About Trapping Attempt to Insert Duplicate Record in Stored Procedure

So are you all set now? Do you understand pietlinden's good code examples?
--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 1, 2013 at 11:06 pm

#1670003
RE: Need your help...SQL Developer interview questions..pls

Mr. Kapsicum (12/1/2013)
For only just 2+, they will ask you basics questions only, And, in some cases, they will like you write down some basic queries (just to see practical...
--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 1, 2013 at 11:01 pm

#1670002
RE: Question About Trapping Attempt to Insert Duplicate Record in Stored Procedure

I'll also say "congrats" on the very readable code you posted. It's nice to see some thoughtful casing.
To add to what pietliden posted for code, you might want to...
--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 1, 2013 at 8:28 pm

#1669993
RE: Are the posted questions getting worse?

dwain.c (12/1/2013)
Jeff Moden (12/1/2013)
dwain.c (12/1/2013)
I've lived in Thailand more than 10 years and I can honestly say I've never seen "Crying Tiger" on the menu. But if it made...
--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 1, 2013 at 7:32 pm

#1669990
RE: Are the posted questions getting worse?

dwain.c (12/1/2013)
cow is referred to as wua[/b] - don't ask me why)[/i][/b]
FINALLY!!! AFTER NEARLY 40 YEARS, AN EXPLANATION!!!! When I was in the service, I had a young lady...
--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 1, 2013 at 7:18 pm

#1669987
RE: Are the posted questions getting worse?

dwain.c (12/1/2013)
I've lived in Thailand more than 10 years and I can honestly say I've never seen "Crying Tiger" on the menu. But if it made your Thanksgiving 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)

December 1, 2013 at 7:09 pm

#1669986
RE: Easy Question: Organizing Data Flows

Nevyn (12/1/2013)
Yes, master and child packages are possible. There is an execute package task.
Thanks for the confirmation on that, Nevyn.
--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 1, 2013 at 7:05 pm

#1669985

Viewing 15 posts - 25,246 through 25,260 (of 59,102 total)