Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,731 through 20,745 (of 59,072 total)

RE: Here are some SQL Server Interview Questions

Luis Cazares (5/14/2015)
You receive a late call during the night to inform you that the server is down and must be working correctly before everyone arrives in the morning. How...
--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 14, 2015 at 1:14 pm

#1797995
RE: Documenting with Tests

PHYData DBA (5/14/2015)
Code Comments <> Documentation
Just in case that was not clear to everyone already.
I have to strongly disagree with that if it's done correctly. The next question would...
--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 14, 2015 at 12:08 pm

#1797960
RE: Run SQL query to retrieve 650 unique records

If this is something that needs to be done more than once or automated, post back and we'll turn it into a stored procedure for 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 14, 2015 at 12:02 pm

#1797956
RE: Fast Insert

As always, "It Depends". For example, no one has mentioned using the high performance "SELECT/INTO" method, which works wonders even if minimal logging isn't possible due to the current...
--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 14, 2015 at 11:57 am

#1797952
RE: Are the posted questions getting worse?

I agree with what the others have said. Your community service and that blog have been well above and beyond the call of duty and you advertising yourself 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)

May 14, 2015 at 11:51 am

#1797947
RE: Are the posted questions getting worse?

Ed Wagner (5/11/2015)
WayneS (5/11/2015)
Jeff Moden (5/8/2015)
Lynn Pettis (5/8/2015)
I do love showing people Jeff's DelimitedSplit8K function and pointing them to his article.
:blush: I'm honored, ol' friend. It's not mine...
--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 14, 2015 at 8:38 am

#1797877
RE: Need Ammunition for Developers Doing Select *'s

Careful now... I wouldn't ignore the elapsed time. Frequently, it's a strong indication of disk activity even if stats I/O isn't turned on to see. You just have...
--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 13, 2015 at 6:17 pm

#1797726
RE: MCSA 70-461 Question

There's always an exception to every rule... in this case, it would be the good folks that earned an MCM.
--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 13, 2015 at 6:01 pm

#1797724
RE: Urgent SQL Developer vs Enterprise edition 2012/2014

Steve Jones - SSC Editor (5/13/2015)
Current licensing says 2 core packs. With their verbiage, it's confusing. The licensing PDF does say minimum of 4 cores, so my apologies.
Of course, 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)

May 13, 2015 at 5:29 pm

#1797720
RE: Are the posted questions getting worse?

jasona.work (5/13/2015)
Ed Wagner (5/13/2015)
Lynn Pettis (5/13/2015)
jasona.work (5/13/2015)
Looks like Grant hadn't had his daily mandatory caffiene intake when he posted here:
:hehe:
On an unrelated note, does anyone here have any experience with...
--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 13, 2015 at 5:23 pm

#1797719
RE: MCSA 70-461 Question

Lynn Pettis (5/13/2015)
Only two reasons I would get the certs right now. One, if my employer came to me and said it was a requirement for my job. Two,...
--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 13, 2015 at 5:10 pm

#1797718
RE: Archieving Data

And just to be sure, there's no freakin' way that I'd use SSIS for any of this. 😉
--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 13, 2015 at 4:50 pm

#1797715
RE: Archieving Data

ramana3327 (5/13/2015)
Hi,
Another point to note here is that table is replicating and the table has more than 55000000 records greater than 3 months. Is this no of rows are ok...
--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 13, 2015 at 4:48 pm

#1797714
RE: Refreshing the data warehouse without hurting anybody

GPO (5/13/2015)
it shouldn't void any warranty (BWAAAA-HAAAAA-HAAA!!!! Like someone thought of that in the contract!
Are you psychic? Actually there was one warranty. That was that they'd bill us come...
--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 13, 2015 at 4:39 pm

#1797712
RE: The Service Pack Fiasco

TomThomson (5/13/2015)
Jeff Moden (5/11/2015)
MS has to do one very important thing... they need to slow down and do service packs 100% correct. SPs are supposed to fix things, not...
--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 13, 2015 at 3:43 pm

#1797701

Viewing 15 posts - 20,731 through 20,745 (of 59,072 total)