Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,611 through 17,625 (of 59,102 total)

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
RE: Unicode Bulk insert Problems

It's stupid. Even NOTEPAD supports UTF-8 but SQL Server does not until 2016.
https://msdn.microsoft.com/en-us/library/ms188365(v=sql.105).aspx
You can, however, pre-convert the file to UTF-16 to import. Supposedly, the code at http://www.gnu.org/software/libiconv/#downloading works....
--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 30, 2016 at 9:24 pm

#1882061
RE: An IDENTITY column has reached Max int

DesNorton (5/29/2016)
I deleted the table first before performing reseed .
If you were able to, so nonchalantly, just kill all of the data in the table, why did you wait...
--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 30, 2016 at 6:33 pm

#1882057
RE: Sql server 2000 - Reverse the fill factor values after DBCC Reindex

NM. I didn't see @Cmd getting executed but then see the results of the cursor were captured on the screen and those were executed.
--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 30, 2016 at 4:49 pm

#1882054
RE: Compare 3 tables and calculate working days

ganapathy.arvindan (5/30/2016)
Yes your right, it is a pivot table, please let me know whether it is possible to calculate working days in pivot table itself, please help me in solving...
--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 30, 2016 at 4:41 pm

#1882051
RE: Great Developers

Perhaps you need someone to help you with your CV, Mannie. Although many folks loath recruiters, a good one is worth their weight in Gold. Rather than taking...
--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 30, 2016 at 4:27 pm

#1882050
RE: Slow BCP Out, only 9000 rows/second

We've previously run into hardware limitations (it was old hardware which has since been replaced). First, going from the big machine to Network Attached Storage had a couple 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 30, 2016 at 4:10 pm

#1882049
RE: Long running queries more than 24 hours

See "Example C" at the following link. If that doesn't give you some good ideas, then post back.
EDIT... had walked away and didn't realize that YB751 had posted. ...
--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 30, 2016 at 3:44 pm

#1882047
RE: Mentors and Professional Groups

From the Article:
It didn’t always go smoothly, I’ll admit. Frank Whittle, the inventor of the turbojet engine, presented the idea at a meeting of his professional association, only to be...
--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 30, 2016 at 3:38 pm

#1882046
RE: Difficult delete question

j-1064772 (5/30/2016)
Adding the extra joins offers the advantage of stating the intent clearly instead on relying on an "implicit" behaviour. Unless of course performance of such a construct becomes 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)

May 30, 2016 at 10:29 am

#1882021
RE: What does Visual Studio do when it's "loading"

It sounds like it's either waiting for a connection or waiting for a resource that is blocked. You might want to try running sp_who2 from SSMS to take 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)

May 29, 2016 at 7:43 pm

#1881960
RE: Compare 3 tables and calculate working days

ganapathy.arvindan (5/29/2016)
trying to add a image on employee table format but not able to
Correct. That's because you're trying to reference an image from your C:Drive and this web site...
--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 29, 2016 at 7:37 pm

#1881959
RE: Difficult delete question

There's no need to join back to the table to do the DELETE. You can delete from the table by deleting from the CTE.
Here's the OPs original data in...
--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 29, 2016 at 6:02 pm

#1881957

Viewing 15 posts - 17,611 through 17,625 (of 59,102 total)