Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,041 through 20,055 (of 59,072 total)

RE: Investigating Slow Restore Process

There are several things that pop into my mind.
1. If the database backup isn't a compressed backup, then you have some serious file size and freespace issues if 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 26, 2015 at 11:28 pm

#1815035
RE: how to create alter for cup ultilization

Actually, it's not something easily done from SQL Server and probably should not be. It should be done from Windows. Here's a link about setting up such alerts...
--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 26, 2015 at 10:51 pm

#1815034
RE: Query for LastYear same Month

yayan.m (7/26/2015)
Please advice.
We're only guessing here because we don't actually have your data. It's time for you to read and heed the article at the first link in my...
--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 26, 2015 at 1:44 pm

#1815017
RE: Help with joining two tables

J Livingston SQL (7/26/2015)
Jeff...as usual you have provided an informative analysis for the OP to consider.
Far more eloquent, patient and concise than my initial reaction and potential post this morning...
--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 26, 2015 at 1:16 pm

#1815016
RE: Help with joining two tables

bgolembiesky 4883 (7/26/2015)
Thanks for taking time to go through this Jeff. ADP assured me that the calculation was performing correctly but it's obviously not. I dumped both tables into excel...
--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 26, 2015 at 12:43 pm

#1815013
RE: Help with joining two tables

bgolembiesky 4883 (7/24/2015)
I've having difficulty joining two tables and getting the results I want. What I'm trying to accomplish is an Health Savings Account (HSA) upload file to go 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 26, 2015 at 10:40 am

#1815009
RE: is it possible to install sql managment studio on XP?

As much as I loved XP, XP is no longer supported. You really need to upgrade.
--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 25, 2015 at 7:57 pm

#1814984
RE: Help with joining two tables

bgolembiesky 4883 (7/25/2015)
sgmunson (7/25/2015)
bgolembiesky 4883 (7/24/2015)
Unfortunately, it does not. That's what I tried initially. It seems like a simple request. All I want is the employee, check date and amount...
--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 25, 2015 at 7:56 pm

#1814983
RE: No Downtime Deployments

WWWWWHHHHUUUUUTTTTT?!?!?!?! You mean to tell me that ORMS don't auto-magically handle all of this? :-P;-)
And the final comments in that article are only partially correct. If the process...
--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 25, 2015 at 7:40 pm

#1814980
RE: Getting duplicate data when connecting to another table.

.Netter (7/25/2015)
I've just managed to get resolve this, I changed my where statement to look like the following:
where
(p.id = @UserId or p.id = @SenderId)
and
...
--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 25, 2015 at 7:27 pm

#1814979
RE: Help with joining two tables

bgolembiesky 4883 (7/25/2015)
sgmunson (7/25/2015)
bgolembiesky 4883 (7/24/2015)
Unfortunately, it does not. That's what I tried initially. It seems like a simple request. All I want is the employee, check date and amount...
--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 25, 2015 at 7:09 pm

#1814978
RE: Is It Worth Writing Unit Tests?

ZZartin (7/25/2015)
Just out of curiosity how do people feel about the concept of rapid development as it relates to unit testing since the concept of small individual separate components is...
--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 25, 2015 at 10:01 am

#1814963
RE: Help with joining two tables

bgolembiesky 4883 (7/24/2015)
Unfortunately, it does not. That's what I tried initially. It seems like a simple request. All I want is the employee, check date and amount from ps_al_chk_ded where...
--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 25, 2015 at 9:10 am

#1814960
RE: differential backup

A "newbie" with just 2 posts had two posts deleted by the automatic SPAM killer because he included URLs in his post. I do wish they'd fix that somehow...
--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 25, 2015 at 9:07 am

#1814958
RE: Is It Worth Writing Unit Tests?

David.Poole (7/25/2015)
I've been looking at the whole business requirements through to deliverable process.
I used to think I was quite good at testing and peer reviewing code.....until my then company hired...
--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 25, 2015 at 8:38 am

#1814957

Viewing 15 posts - 20,041 through 20,055 (of 59,072 total)