Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,561 through 22,575 (of 59,072 total)

RE: Temporal SQL Server Databases

Randy AV (10/24/2014)
We did a very deep dive into looking at Prior Art as did the USPTO examiner. A lot of the prior art was ours, based on 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)

October 24, 2014 at 8:44 pm

#1754757
RE: SSIS Help..

rocky_498 (10/24/2014)
Thanks for your help, got it I can use multicast for different file, how about ?
Source:-
Add, New, Pro, Len, Source
Acorn,Null,Null,Null,Null
Null,FC,Null,Null,Null
Null,Null,Day,Null,Null
Null,Null,Null,2:00,Null
Null,Null,Null,Null,Phone
Null,Null,Null,Null,Web
Destination File:-
Add, New, Pro, Len, Source
Acorn,FC,Day,2:00,Phone
Acron,FC,Day,2:00,Web
this format ?
To be honest,...
--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)

October 24, 2014 at 6:29 pm

#1754754
RE: The 10 (.5) Commandments for IT Professionals

I missed this article the first time around and glad it was republished. Absolutey awesome job. I especially like the part about putting the documentation into the code...
--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)

October 24, 2014 at 5:02 pm

#1754748
RE: High PLE and raising... but Paging up to 120/sec?

SQLKnowItAll (10/23/2014)
My end game here is to show a dev team that they don't need more memory, but by seeing paging and not understanding it, I may not be able...
--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)

October 24, 2014 at 4:54 pm

#1754747
RE: Best Practices

ramana3327 (10/23/2014)
Yes but now it is hitting the production database performance (OLTP). That is the reason they want the read only copy for the reporting source
It would be far easier...
--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)

October 24, 2014 at 4:42 pm

#1754746
RE: DPM with native SQL Log backup

Biank (10/21/2014)
Hello,
I'm wondering if I can take native SQL log backup in addition to DPM backups. We're using DPM for both databases (daily) and logs (every 15min). So,...
--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)

October 22, 2014 at 12:16 am

#1753926
RE: Are the posted questions getting worse?

Steve,
After a fairly long wait (> 30 seconds), I got the following...
Sorry, an error has occurred
If problems persist, please contact us to let us know.
When reporting this error, please quote...
--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)

October 22, 2014 at 12:09 am

#1753925
RE: Are the posted questions getting worse?

Not to mention keeping mosquitos away in a pinch. Of course, it'll also keep everyone else away, as well. 😛
--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)

October 21, 2014 at 11:36 pm

#1753923
RE: DPM with native SQL Log backup

Ah... and to be clear, I was thinking datafile backup being done separately. I agree with Eirikur in asking, why would you ever want to take log file backups...
--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)

October 21, 2014 at 11:32 pm

#1753921
RE: dual purpose OUTPUT parameter

ChrisM@Work (10/21/2014)
Wouldn't it be easier and more natural to refactor this as a function?
I agree but to return a random number, you'd probably want to use a GUID as 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)

October 21, 2014 at 10:10 pm

#1753919
RE: Using >= or <= with DateTime parameter not working?

PhilPacha (10/21/2014)
Trying to add an arbitrary amount of 'time' to a datetime value which starts out containing ONLY a date is fraught with problems. Try adding the last millisecond or...
--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)

October 21, 2014 at 9:29 pm

#1753915
RE: Using >= or <= with DateTime parameter not working?

phoeneous 65427 (10/21/2014)
This works when I apply it to the query, no need to filter in ssrs.
AND (OrderDate BETWEEN (@StartDate ) AND (@EndDate + '23:59:59'))
That misses a full second....
--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)

October 21, 2014 at 9:27 pm

#1753914
RE: the database cannot be attached because an error occurred while loading the detach log

rodrigo.carrasco.e (10/21/2014)
I have no backup
I could be wrong because I'm no SSAS expert but that usually means that the database cannot be recovered and that someone has a fair bit...
--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)

October 21, 2014 at 9:21 pm

#1753913
RE: DPM with native SQL Log backup

Use the "Copy only" feature to do a native backup the database so you don't break the Point-in-Time natue of DPM, whatever that happens to stand for today. 😉
--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)

October 21, 2014 at 9:17 pm

#1753912
RE: SQL Release

Yes... right click on the database in SSMS and click on [Tasks], [Generate Scrips], and then follow your nose. Of course, that just to get you out of 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)

October 21, 2014 at 9:14 pm

#1753911

Viewing 15 posts - 22,561 through 22,575 (of 59,072 total)