Viewing 15 posts - 17,566 through 17,580 (of 59,069 total)
kocheese (6/1/2016)
We are migrating from an old environment to a...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2016 at 1:50 pm
coolchaitu (6/1/2016)
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
Change is inevitable... Change for the better is not.
June 1, 2016 at 1:37 pm
coolchaitu (5/31/2016)
Good morning expertsSorry 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
Change is inevitable... Change for the better is not.
June 1, 2016 at 12:09 am
manticohd (5/31/2016)
John Mitchell-245523 (5/31/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2016 at 11:04 pm
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
Change is inevitable... Change for the better is not.
May 31, 2016 at 11:00 pm
"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
Change is inevitable... Change for the better is not.
May 31, 2016 at 9:39 pm
Alan.B (5/31/2016)
CREATE TABLE Mytest (id INT, x XML)
INSERT mytest
VALUES
(1, CAST('1200' AS XML))
...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2016 at 9:36 pm
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
Change is inevitable... Change for the better is not.
May 31, 2016 at 9:24 pm
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
Change is inevitable... Change for the better is not.
May 31, 2016 at 9:20 pm
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
Change is inevitable... Change for the better is not.
May 31, 2016 at 9:04 pm
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
Change is inevitable... Change for the better is not.
May 31, 2016 at 9:02 pm
chuck.forbes (5/31/2016)
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
Change is inevitable... Change for the better is not.
May 31, 2016 at 4:50 pm
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
Change is inevitable... Change for the better is not.
May 31, 2016 at 4:33 pm
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
Change is inevitable... Change for the better is not.
May 31, 2016 at 6:41 am
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
Change is inevitable... Change for the better is not.
May 31, 2016 at 6:22 am
Viewing 15 posts - 17,566 through 17,580 (of 59,069 total)