Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,566 through 17,580 (of 59,069 total)

RE: Convert OPENQUERY to SQL

kocheese (6/1/2016)
I am having a hard time and hoping someone could point out what I can't seem to figure out.
We are migrating from an old environment to 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)

June 1, 2016 at 1:50 pm

#1882636
RE: Finding if there was CPU or memory pressure yesterday night

coolchaitu (6/1/2016)
Hi Jeff,
The Senior DBA got CPU and memory utilization data for last 7 days from system admin team. He found that there was no CPU or memory pressure ...
--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)

June 1, 2016 at 1:37 pm

#1882633
RE: Finding if there was CPU or memory pressure yesterday night

coolchaitu (5/31/2016)
Good morning experts
Sorry for delay. Our senior dba got the data from the sysadmin team. Thanks a lot for your help
Two way street. What data did the DBA...
--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)

June 1, 2016 at 12:09 am

#1882338
RE: How to clear master.dbo.sysprocesses ?

manticohd (5/31/2016)
John Mitchell-245523 (5/31/2016)
Sysprocesses is a view of the processes that are running on SQL Server. You can't update it. If you want to stop any of those processes...
--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)

May 31, 2016 at 11:04 pm

#1882329
RE: The Coffee Routine

Ugh! Soy Milk. Almond Milk... maybe, although I prefer black coffee. But Soy Milk? To each their own. I can't do it.
On the subject of...
--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)

May 31, 2016 at 11:00 pm

#1882328
RE: What is SQL Fertilization any links?

"SQL Fertilization" is when you go crop dusting in the server room. 😛 Gives new meaning to the term "It Depends". 😀
Either that or it's a "code smell". ...
--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)

May 31, 2016 at 9:39 pm

#1882322
RE: Inserting XML

Alan.B (5/31/2016)
I don't know why you get an error. This code
CREATE TABLE Mytest (id INT, x XML)
INSERT mytest
VALUES
(1, CAST('1200' AS XML))
...
--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)

May 31, 2016 at 9:36 pm

#1882321
RE: Are the posted questions getting worse?

Luis Cazares (5/31/2016)
Grant Fritchey (5/31/2016)
Because SQL Fertilization needs to become something we all talk about. It's important. Don't you understand how SQL Fertilization works?
I have to say a lot of...
--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)

May 31, 2016 at 9:24 pm

#1882320
RE: Great Developers

manie (5/31/2016)
I am telling you everywhere I went they ask for my qualifications and when I say I have none, they say sorry sir.
Did they even bother to interview you...
--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)

May 31, 2016 at 9:20 pm

#1882319
RE: Difficult delete question

yvesql (5/31/2016)
Thanks Jeff, great! 🙂
I did, however, forget to add DESC to the ROW_NUMBER() sort. I've corrected the script. My apologies for my oversight.
--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)

May 31, 2016 at 9:04 pm

#1882318
RE: Difficult delete question

First, thanks again to chuck.forbes for picking up on me forgetting the DESC sort order. I've corrected the script and tested it. Looks like it's good to go.
--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)

May 31, 2016 at 9:02 pm

#1882317
RE: Difficult delete question

chuck.forbes (5/31/2016)
Jeff,
I think your windowing function needs a DESC, like DesNorton's solution has. I feel like a jerk writing this, since your Jedi SQL skills far surpass...
--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)

May 31, 2016 at 4:50 pm

#1882303
RE: Finding if there was CPU or memory pressure yesterday night

gfoxxy93 (5/31/2016)
Do you have any performance counters running on the server?
Even if someone did, it's a bit crazy to start looking at things like performance counters unless the error from...
--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)

May 31, 2016 at 4:33 pm

#1882302
RE: More Overloads

From the Article:
This time ACID was taken to be: Algorithms, Computer/Cloud, IoT, and Data.
In their hurry to be cute or notable, they've opened themselves up to not only people...
--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)

May 31, 2016 at 6:41 am

#1882126
RE: Difficult delete question

yvesql (5/31/2016)
Thanks Jeff, great! 🙂
You're welcome.
Since it came up, I need to check... you understand how it works? If not, please post back and I'll explain more. It'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)

May 31, 2016 at 6:22 am

#1882123

Viewing 15 posts - 17,566 through 17,580 (of 59,069 total)