Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,596 through 17,610 (of 59,102 total)

RE: Something about licensing SQL Server

paolobianchi (6/1/2016)
Thanks to all.
I found on Microsoft the answer, i MUST licence all core
•To license a physical server, you must license all the cores in the server with 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 4:32 pm

#1882677
RE: Can we just lock the schema rather a DB?

Steve Jones - SSC Editor (6/1/2016)
SQL Server takes locks as needed to process data, change objects, etc., to avoid glitches. As Gilamonster mentioned, there isn't a lock db or schema...
--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:58 pm

#1882640
RE: Long running queries more than 24 hours

- Win (6/1/2016)
Thanks for your response.
I will still wait for some real stuff that helps on my query that was used..
What "real stuff" do you expect?
--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:56 pm

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

Viewing 15 posts - 17,596 through 17,610 (of 59,102 total)