Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,956 through 23,970 (of 59,102 total)

RE: Common questions asked in SQL Server DBA Interview

Randheer (2/25/2014)
Check out below link for Interview Questions and answers for SQL Server DBA
http://www.sqlserverquest.com/p/sql-server-dba-interview-questions.html
The link didn't work even when I copied and pasted it. 😉 I did, however,...
--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)

April 5, 2014 at 6:25 pm

#1703550
RE: Getting Started in SQL Server

Evil Kraig F (10/28/2011)
I figure I'm about average for most DBA/Devs in ability, time availabily, and desire.
I'm glad they republished this article. Very well written, Craig.
As...
--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)

April 5, 2014 at 6:04 pm

#1703549
RE: Stairway to Advanced T-SQL Level 4: Using Views to Simplify Your Query

There is one scenario where what you claim is true but, from what I can see, it's only for a "no rows found" condition. Here's the code...
PRINT...
--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)

April 5, 2014 at 5:38 pm

#1703548
RE: Stairway to Advanced T-SQL Level 4: Using Views to Simplify Your Query

I just added the following code to the example above, the second snippet of which matches your example, Jose.
PRINT '========== Do an aggregate only from TableA...'
SELECT TableASomeID,...
--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)

April 5, 2014 at 5:23 pm

#1703547
RE: Stairway to Advanced T-SQL Level 4: Using Views to Simplify Your Query

jay 87680 (3/20/2014)
There is a general misconception of the following statement that you make.
"In this case SQL Server will still have to join all the tables in the view...
--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)

April 5, 2014 at 4:53 pm

#1703546
RE: How many Databases are you managing

I have found that managing databases and servers is pretty easy although I certainly prefer not to have to keep up with hunred or thosands like some of the folks...
--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)

April 5, 2014 at 3:08 pm

#1703538
RE: xp_create_subdir for non-sysadmins

jpoole (4/5/2014)
Hi,
Is it possible for non-sysadmins to run xp_create_subdir on the Express version of 2008 R2? When researching the subject I have seen talk of adding a proxy account. Can...
--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)

April 5, 2014 at 2:42 pm

#1703535
RE: Processing flat file with Header,Detail and Trailer

Drat... I was hoping you wanted a T-SQL-only solution. 😛 I don't actually know how to spell SSIS so I can't help here. Hopefully, someone who knows SSIS...
--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)

April 5, 2014 at 1:12 pm

#1703524
RE: Find sequential numbers

You're a better man than I, Mr. Pettis. I took the time to put the originally posted data in a table along with an answer (very similar to yours...
--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)

April 5, 2014 at 1:09 pm

#1703521
RE: Short Stroking and Performance

I think hard disks have simply gotten too big to do some of the old tricks to bring multiple spindles into play. As for "short stroking", Peter Norton figured...
--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)

April 5, 2014 at 12:39 pm

#1703520
RE: Find sequential numbers

rui_leote (4/5/2014)
I can do it, I am not at home now. I have a table with only 2 columns. Let's say "eventdate" and "status".
Eventdate is datetime
Status is int.
I have records...
--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)

April 5, 2014 at 11:19 am

#1703507
RE: rewrite cursor to set based

priestxandar (4/5/2014)
Could anyone help with this ?
Thank you
It's a fair bit of work to rewrite such things so that they perform better. It's also a bit like shooting in...
--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)

April 5, 2014 at 11:16 am

#1703506
RE: Processing flat file with Header,Detail and Trailer

naresh0407 (4/4/2014)
Hi All,
I have below flatfile.Please let me know how to process this file without scripttask in SSIS.
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)

April 5, 2014 at 11:04 am

#1703505
RE: Opinion of use of LINQ

One of the biggest problems I've had with Linq to SQL (and other ORMs, as well) is the data-type mismatching it sometimes does. Most of our character based columns...
--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)

April 5, 2014 at 11:01 am

#1703504
RE: Sequential numbers

This is a duplicate post. Please don't post any answers here because it'll just separate potential solutions from what is already in progress. Instead, please the in-progress duplicate...
--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)

April 5, 2014 at 10:40 am

#1703502

Viewing 15 posts - 23,956 through 23,970 (of 59,102 total)