Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,541 through 21,555 (of 59,098 total)

RE: Intermittent error: Cannot open database "DBNAME" requested by the login. The login failed. Login failed for user 'USER'.

lfajardo (2/12/2015)
Hi Jeff, I assume you are referring to a connection leak on the application side, correct? Which causes uncontrollable number of connections and I assume at some point...
--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)

February 15, 2015 at 5:04 pm

#1777740
RE: chainging isloation level with in the sesssion after closing first tran is correct or not

According to Books Online, what you ask can be done. I've never had the need to do such a thing and so I'll leave the actual experiment up 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)

February 15, 2015 at 4:31 pm

#1777736
RE: Query Help : Recursive Running Total OR Lead/Lag Function for N number of PartitionValue

Thank you very much for the feedback. I really appreciate you posting your final code.
Just as a clarification of terms, though... that's not a "running" total. It's a...
--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)

February 15, 2015 at 9:56 am

#1777720
RE: Query Help : Recursive Running Total OR Lead/Lag Function for N number of PartitionValue

Luis Cazares (2/14/2015)
Basically, you want to divide the proportion by the running total of proportion.
Quick question. How do you define the order? I think I know the answer but want...
--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)

February 14, 2015 at 9:01 pm

#1777704
RE: SQL Server Jobs

Heh... if it weren't related to the profession, I'd delete this just for bad spelling. 😉
--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)

February 14, 2015 at 11:25 am

#1777685
RE: SQL Server Jobs

gnewcomb (2/14/2015)
SQL Server Pros are getting extremely hard to find these days. The question you must ask yourself is am I getting the pay I deserve?
Weather you are beginner 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)

February 14, 2015 at 11:24 am

#1777684
RE: Are the posted questions getting worse?

TomThomson (2/14/2015)
Eirikur Eiriksson (2/7/2015)
TomThomson (2/7/2015)
Grant Fritchey (2/5/2015)
Really? Yankees fans? Are they even human?
Usually not - they're mostly American.
Tom, must say that I find this comment totally inappropriate
😎
How can it...
--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)

February 14, 2015 at 11:16 am

#1777682
RE: Query Causing Blocking, Locks Table for 1000 Seconds, Help Needed!

The most obvious problem in the Execution Plan that you provided are the two warnings (the Yellow triangles on two tables). If you hover over those icons, you'll see...
--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)

February 14, 2015 at 9:15 am

#1777673
RE: Backing up Alternatives

DKY (2/14/2015)
@ Ed Wagner
That's my point, it's too huge to recover to another database just for one table. It would take forever. I have about 80%...
--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)

February 14, 2015 at 8:59 am

#1777670
RE: Query Help : Recursive Running Total OR Lead/Lag Function for N number of PartitionValue

Mr. Kapsicum (2/13/2015)
Guys, Please Help with the problem , let me know if the problem is not well drafted Here.
Nah... you did good. You just have to be a...
--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)

February 14, 2015 at 8:00 am

#1777662
RE: 3rd party tools for backup compression

As previously mentioned, TDE databases don't compress much.
With that in mind, what are your 3 largest tables and what are they used for? I'm betting that at least one...
--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)

February 13, 2015 at 7:51 pm

#1777647
RE: Importing spreadsheet in one single column

SSMS_2007 (2/13/2015)
I am trying to import 1 spreadsheet to a database table. I am using SSMS export import wizard to import spreadsheet. My goal is to import whole spreadsheet 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)

February 13, 2015 at 5:56 pm

#1777642
RE: DATEDIFF values are different for exactly same MiliSeconds

brad.mason5 (2/12/2015)
Hey Jeff,
I created a script that will store statistics of a stored procedure which has a parameter. This parameter has 9k distinct values that can be used. ...
--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)

February 13, 2015 at 5:43 pm

#1777640
RE: Next Business Day

Sangeeth878787 (2/13/2015)
This is the exact requirement I need to do:
We have a requirement to show 'Business Day / Working Day ' as a output for the below input parameters
Input
a)...
--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)

February 13, 2015 at 5:37 pm

#1777639
RE: Update statistics with large databases

Yes, there is a performance impact but not the way some would think. It can be much worse.
When would you expect auto-updates of statistics to occur? Yeah... 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)

February 13, 2015 at 5:28 pm

#1777638

Viewing 15 posts - 21,541 through 21,555 (of 59,098 total)