Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,146 through 20,160 (of 59,098 total)

RE: data problem

Never mind... post deleted.
--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)

July 13, 2015 at 6:00 am

#1811930
RE: ldf of main db and tempdb keep increasing

Edward-445599 (7/13/2015)
dbcc opentran
showed an old transaction , killed it
You should now try to figure out what data is missing because of the rollback you just caused and who 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)

July 13, 2015 at 5:42 am

#1811923
RE: Challenge - dynamically load any file

Abhijit More (7/13/2015)
I have challenge where I received data from multiple sources in different formats such as excel, csv, flat file.
Now the challenge is I have to load any received...
--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)

July 13, 2015 at 5:39 am

#1811922
RE: Extract the titles from XML

The correct answer isn't actually available. The correct answer should be to "hunt down the moroff that used XML to transmit purely flat data and introduce him to high...
--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)

July 13, 2015 at 4:53 am

#1811910
RE: Recover DB without Log file.

I believe the point that Perry is trying to make is that not much you can try in this case is going to work. About the only thing that'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)

July 13, 2015 at 4:35 am

#1811907
RE: Page Life Expectancy drops like a rock at several points throughout the day

mortalic (7/10/2015)
We just went live on 2014 a few weeks ago. Previously on 2008R2, we've noticed a few small differences in behavior for the different DB Engines.
This one 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)

July 13, 2015 at 4:26 am

#1811906
RE: Are the posted questions getting worse?

GilaMonster (7/13/2015)
Yes, yes, yes, yes!!!!!!!!
Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
Outstanding, Gail!
--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)

July 13, 2015 at 4:03 am

#1811901
RE: Data Loss or Downtime

David.Poole (7/12/2015)
I strongly suspect that in the event of a DR scenario the business would find out that certain non-critical systems were actually far more important than they realised.
The question...
--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)

July 13, 2015 at 12:55 am

#1811867
RE: I Feel Like a Magician

Steve Jones - SSC Editor (7/12/2015)
I thought so too, after banging my head on the wall for a day and a half. Eventually found that there are some issues 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)

July 12, 2015 at 7:05 pm

#1811856
RE: I Feel Like a Magician

David.Poole (7/8/2015)
Microsoft, your product is mature, it is time to start sweating the small stuff
+ 1 billion! I've emblazoned one of your fine quotes in my head... I think...
--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)

July 12, 2015 at 6:59 pm

#1811855
RE: Problems importing CSV files using SSIS.

Orlando Colamatteo (7/11/2015)
Maybe it was oversold to you, I wasn't there, but XML does what is was designed to do. If you have to ship relational or hierarchical data structures...
--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)

July 11, 2015 at 2:59 pm

#1811825
RE: Are the posted questions getting worse?

TomThomson (7/10/2015)
Eirikur Eiriksson (7/10/2015)
Spot on Jeff but it doesn't take Chinese though, everyone has heard stories of strange things ordered in French restaurants etc.. Guess the French also use automatic...
--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)

July 11, 2015 at 12:20 am

#1811794
RE: slow performance

Grace09 (7/10/2015)
Jeff, The Compilation Time is from the last time the sql server were rebooted. Thanks.
Ok... but I need to know what that date and time was, please.
--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)

July 10, 2015 at 5:02 pm

#1811786
RE: Partitioning and Indexes

I wouldn't (and haven't) used any of those 3 methods. I'd (and have) do the clustered index by Date (the partitioning column) and the PK. It's going to happen...
--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)

July 10, 2015 at 12:17 pm

#1811722
RE: Data Loss or Downtime

I have a 350GB database in my SQLServer based telephone system. If that system goes down, we're toast because it's a critical part of our business to "answer 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)

July 10, 2015 at 12:02 pm

#1811712

Viewing 15 posts - 20,146 through 20,160 (of 59,098 total)