Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,591 through 22,605 (of 59,099 total)

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
RE: bcp error

halifaxdal (10/21/2014)
I really like bcp but it really makes me frustrated, I keep getting error:
Starting copy...
SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Unexpected EOF encountered 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)

October 21, 2014 at 9:09 pm

#1753910
RE: Masking (Deidentification)

With the detail provided, my suggestion would be to replace non-null values with a GUID. You may have some difficulty with the postal code column if you have any...
--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 8:44 pm

#1753909
RE: When Work Gets in the Way of Work

Eric M Russell (10/21/2014)
Not only is there a high frequency of events, but there's also a number of new presentations to build. It seems I have 3-4 (at least) new...
--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 8:33 pm

#1753908

Viewing 15 posts - 22,591 through 22,605 (of 59,099 total)