Jeff Moden

Forum Replies Created

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

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
RE: Core T-SQL

Greg Edwards-268690 (11/30/2013)
Gary Varga (11/29/2013)
Jeff Moden (11/29/2013)
The exception to that rule is that spelling errors are simply not forgivable and incorrect substitution of correctly spelled words (for example, you meant...
--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:03 pm

#1669984
RE: Need to fill the Gaps with previous value

dwain.c (12/1/2013)
Where in the world did you come up with such a thing?
Heh... after spending hours on posts like this one wondering why the hell the code won't short circuit...
--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 6:39 pm

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

sqlsurfing (12/1/2013)
Jeff Moden (11/30/2013)
Set it to "single user" then immediately to "multi-user" and then immediately execute the restore command. Of course, these 3 things should be in a script.
Good...
--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 6:26 pm

#1669981

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