Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,581 through 17,595 (of 59,069 total)

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
RE: Rebuild index job is causing index corruption?

Seems like you uncovered a bug. Unfortunately, they not going to fix it because it's in a version of SQL Server that has been out of support for quite...
--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 5:39 pm

#1881956
RE: SQL back Job is failing

ramana3327 (5/27/2016)
Hi,
I created a maintenance plan for backup. The job is failing with the error
The job failed. The owner (TestUser) of job MaintenancePlan.Subplan_1 does not have server access.
The TestUser...
--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 28, 2016 at 12:11 pm

#1881927
RE: Redirect requests to new Database in same instance

GonnaCatchIT (5/28/2016)
I know that option, but want to know if SQL Server supports redirection to different database.
Issue is we dont have control over the SQL servers and there are lot...
--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 28, 2016 at 11:33 am

#1881926

Viewing 15 posts - 17,581 through 17,595 (of 59,069 total)