Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,716 through 20,730 (of 59,102 total)

RE: Project suggestion for a noob

There is very little difference between editions of SQL Server according to what a Noob should start with. About 8 months ago I interviewed a handful of "developers" and...
--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)

May 16, 2015 at 9:39 pm

#1798478
RE: Here are some SQL Server Interview Questions

I was interviewing one person who claimed over 10 years working as a Senior DBA and "tuning experience". Here's how the clustered index segment went.
Me: Tell me all...
--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)

May 16, 2015 at 9:33 pm

#1798477
RE: Here are some SQL Server Interview Questions

GilaMonster (5/15/2015)
David Webb-CDS (5/15/2015)
You gather the customer, the developer, the network guys, the storage guy, and the server guy in a conference room. They all swear that nothing has...
--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)

May 16, 2015 at 9:27 pm

#1798476
RE: Finding Problem Code

Gail Wanabee (5/15/2015)
Eric,
If your users claim the server is slow, I would do several things:
> Ask them, "Compared to what?" This is not a smart *** question. It's a realistic...
--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)

May 15, 2015 at 10:14 pm

#1798414
RE: All restore sequences begin with either a full backup or filegroup backup

afw (5/15/2015)
Aah, makes sense. But boy was I getting that wrong...
Thank you once again 🙂 🙂
My Dad has a saying about such things.
"Half of what is written is true....
--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)

May 15, 2015 at 9:58 pm

#1798413
RE: [SQL Server 2008] Problem with Between syntax

Lynn Pettis (5/15/2015)
Sometimes using a function does NOT mean the comparision becomes nonSARGable.
While that may be true, I'll avoid it whenever possible.
--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)

May 15, 2015 at 9:54 pm

#1798412
RE: [SQL Server 2008] Problem with Between syntax

Jason A. Long (5/15/2015)
WOW... I could have sworn that the last time I tested, CASTing from a DATETIME to a DATE made it unsargable...
Just tetested with this...
DECLARE
@BegDate DATE...
--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)

May 15, 2015 at 9:50 pm

#1798411
RE: [SQL Server 2008] Problem with Between syntax

Jason A. Long (5/15/2015)
ScottPletcher (5/15/2015)
Never use BETWEEN on dates or datetimes;
Out of curiosity, why do you say this?
I could see it it you were talking about DATETIME data...
--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)

May 15, 2015 at 9:45 pm

#1798410
RE: interview questions

sandhyarao49 (4/10/2008)
Hi Could any one tell me the answers for these questions.
1. how do we troubleshoot a datbase if it is in suspect mode.What is the reason for a database...
--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)

May 15, 2015 at 9:33 pm

#1798409
RE: Switching Partitions in SQL 2005

Why are you switched partitions out to rebuild indexes? You do realize you can rebuild indexes on single partitions, correct?
--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)

May 15, 2015 at 9:27 pm

#1798408
RE: Same Query but diffirent execiution plan

Minaz Amin (5/15/2015)
Hi All,
I have very weird issue. I have same query but when executed from different server use different plan. when it runs on QA box it is faster...
--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)

May 15, 2015 at 9:21 pm

#1798407
RE: Cache Manipulation

GilaMonster (5/15/2015)
You can't avoid the optimiser. Even the USE PLAN hint requires that the optimiser runs the optimisation process until it finds the plan specified. Hence it can actually increase...
--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)

May 15, 2015 at 9:19 pm

#1798406
RE: Project suggestion for a noob

dick.vanderweed (5/15/2015)
Hi everyone,
I am teaching myself MS SQL Server 2008 for work purposes. I have a background in programming but not DB Administration. I am done with youtube tutorials...
--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)

May 15, 2015 at 9:13 pm

#1798405
RE: DB crashed

shivakumar.623 (5/14/2015)
My database was crashed then How to identified in particular server particular database was crashed
Let's start from the beginning. What are the indications or error messages that you...
--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)

May 15, 2015 at 9:11 pm

#1798404
RE: Is it possible to determine the dataflow within a database?

Take your pick... either "NO" or "With great difficulty". You should see just the ERD's for some of the procs we write. And considering that there are many...
--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)

May 15, 2015 at 8:58 pm

#1798403

Viewing 15 posts - 20,716 through 20,730 (of 59,102 total)