Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,511 through 21,525 (of 59,072 total)

RE: Are the posted questions getting worse?

TomThomson (2/16/2015)
Sioban Krzywicki (2/15/2015)
TomThomson (2/14/2015)
Lynn Pettis (2/14/2015)
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...
--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 16, 2015 at 6:26 am

#1777810
RE: Avoiding Cursors

Steve Jones - SSC Editor (1/22/2015)
bump
The difficult part for me is that I've already written about most of the generic solutions that I've used in the real world and 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)

February 15, 2015 at 5:50 pm

#1777744
RE: Copy multiple CSV files into database using stored proc , Need to Create new databases everytime

nikki123 (2/9/2015)
hi
I need to import multiple csv files and load into table and everytime new database has to be created .
I was able to create new databases using...
--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:30 pm

#1777743
RE: Copy multiple CSV files into database using stored proc , Need to Create new databases everytime

CooLDBA (2/12/2015)
I had done it in the past with similar requirements.
Ah... I'm sorry. Please accept my apologies. I didn't mean to be sarcastic on my last response. ...
--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:21 pm

#1777742
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

Viewing 15 posts - 21,511 through 21,525 (of 59,072 total)