Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,261 through 25,275 (of 59,099 total)

RE: updating rows with xml

EamonSQL (12/1/2013)
because a downstream process then takes the xml which feeds into a report.
I can't amend the downstream process.
Oh my. I feel for you there.
Did Magoo's answer...
--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:20 pm

#1669978
RE: server automatic restart

sqlfriends (12/1/2013)
We have a windows 2008 server sp2 that hosts a SQl server 2008.
Recently the server has an automatically restart at a night and a weekend.
In the HP Proliant...
--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:04 pm

#1669976
RE: Easy Question: Organizing Data Flows

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 have a control package...
--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 5:59 pm

#1669975
RE: Antivirus on large SQL Server instances

I don't have an answer right now but I have a friend that works with servers that half a half TByte and more. I know he's running some form...
--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 5:54 pm

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

Shifting gears again, VARCHAR(50) for eMail addresses simply isn't wide enough. I'd make that a VARCHAR(250) and still be prepared for the occasional truncation. Yes, I've seen it...
--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 5:45 pm

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

pietlinden (12/1/2013)
Side note: Do not use "sp_" as a prefix for the stored procedures you write. "sp_" is reserved for system stored procedures. maybe use "usp_" instead. ...
--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 5:35 pm

#1669969
RE: Query performance

I would first ask the Developers how they knew they rolled everything back and how they knew they didn't drop something that they didn't add.
The other thing might be 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)

December 1, 2013 at 5:17 pm

#1669966
RE: Core T-SQL

ChrisM@Work (11/26/2013)
Jeff Moden (11/25/2013)
rlortega (11/25/2013)
So what minimum T-SQL skills are necessary if you're a DBA, not a developer?
To be honest... learning to read minds and to anticipate "what's coming" by...
--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 5:13 pm

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

Are you able to correctly answer and carry on a fairly decent conversation about those "direct" questions? If not, you might not survive the interview.
Shifting gears back to 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)

December 1, 2013 at 5:00 pm

#1669964
RE: How can I use MAX() function in another DataBAse?

I'd also like to recommend that you avoid 3 part naming in code. Create a synonym for the table in the other database and then stick to 2 part...
--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 3:55 pm

#1669963
RE: SSRS Time Calculations/Query

Duplicate post. To keep from splitting up answers, please don't post replies here. Please see the same post at the following URL. Thanks.
http://www.sqlservercentral.com/Forums/Topic1518687-2799-1.aspx
--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 3:52 pm

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

dwain.c (9/24/2013)
Leifton - For your case I might just use a correlated sub-query due to its simplicity and the fact that it has widespread understanding.
Create Table #SensorHistory
(
...
--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 3:21 pm

#1669960
RE: Check Data exists or not

kapil_kk (11/30/2013)
can you please tell me how merge doesn't process row by row...
Actually, everything in SQL Server processes "row by row". If you let SQL Server do it, it's...
--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 30, 2013 at 11:13 pm

#1669938
RE: what is the sql server edition for trial download

I can confirm that. If you take a gander at the following URL...
http://technet.microsoft.com/en-us/library/cc645993.aspx
, which is titled "Features Supported by the Editions of SQL Server 2012", you'll find a note...
--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 30, 2013 at 10:09 pm

#1669935
RE: Identify Duplicate Records according to Multiple Criteria

Sy-1148362 (11/30/2013)
Hi There!
I have an Employee table with Columns:
EmpID | FirstName | MiddleName | LastName | SSN | BirthDate | HireDate | City | Zip
Requirement: I have to identify 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 30, 2013 at 9:54 pm

#1669934

Viewing 15 posts - 25,261 through 25,275 (of 59,099 total)