Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,306 through 25,320 (of 59,102 total)

RE: bcp aborts on first FK violation

bruce.malmat (9/26/2013)
I want to use BCP to load data from a text file.
By default, constraints are turned off in bcp, so I use the CHECK_CONSTRAINTS hint.
bcp aborts if ANY 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)

November 27, 2013 at 1:06 pm

#1669568
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Jeff Moden (11/27/2013)
L' Eomot Inversé (11/27/2013)
In SQL 2012 the fractions are between 0 and 9 in Latin1_General_CI_AS but not in SQL_Latin1_General_CI_AS. It's the same in SQL 2008 R2, and...
--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)

November 27, 2013 at 10:49 am

#1669535
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

L' Eomot Inversé (11/27/2013)
In SQL 2012 the fractions are between 0 and 9 in Latin1_General_CI_AS but not in SQL_Latin1_General_CI_AS. It's the same in SQL 2008 R2, and unless my...
--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)

November 27, 2013 at 8:32 am

#1669498
RE: Are the posted questions getting worse?

jasona.work (11/26/2013)
/rant mode on
Frickin' bloody pain in the tuckus idiotic mindless rules drones! Gotta go in early tomorrow because it's entirely possible a SQL server and a couple Oracle...
--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)

November 27, 2013 at 7:52 am

#1669486
RE: Are the posted questions getting worse?

Greg Edwards-268690 (11/23/2013)
L' Eomot Inversé (11/23/2013)
Ed Wagner (11/22/2013)
I never had the "pleasure" of working with either of those IBM products, but I've been forced to work with other ones. ...
--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)

November 27, 2013 at 7:50 am

#1669485
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Paul White (11/26/2013)
I've just noticed that "IsAllDigits" includes fractions:
-- True
SELECT IsAllDigits
FROM dbo.IsAllDigits('1¼');
-- True
SELECT IsAllDigits
FROM dbo.IsAllDigits('¾5¼');
Collation-related of course. There is more between 0 and 9 than just the integers....
--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)

November 27, 2013 at 7:24 am

#1669479
RE: Visitor Parking

Japie Botma (11/27/2013)
I would just change one thing on Jeff's suggestion: Use a wheel clamp instead of towing. In our country it is a cheaper option and if...
--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)

November 27, 2013 at 6:59 am

#1669465
RE: Free Disk Space by Clearing Columns ?

I also believe that type of thing will only work on variable length columns, as well.
--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)

November 26, 2013 at 9:11 pm

#1669318
RE: Visitor Parking

Gosh. I believe this is real simple.
The signs should say that you'll be towed after 2 hours UNLESS you register your vehicle with the folks inside. That way...
--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)

November 26, 2013 at 9:08 pm

#1669317
RE: Extract string

kapil_kk (11/26/2013)
David Burrows (11/26/2013)
One way
SUBSTRING(@string,CHARINDEX('_',@string)+1,CHARINDEX('_',SUBSTRING(@String,CHARINDEX('_',@string)+1,255))-1)
Thanks David,:-)
I have implemented in the same manner..but I am looking for another solutions for this
Ok... your turn. Why did you need 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)

November 26, 2013 at 9:04 pm

#1669315
RE: Core T-SQL

ChrisM@Work (11/26/2013)
Interesting you should go beyond "core skills" here, Jeff. Over the last year or two I've been compiling a list of skills which I think a "senior SQL Server...
--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)

November 26, 2013 at 6:57 pm

#1669302
RE: Core T-SQL

ChrisM@Work (11/26/2013)
Interesting you should go beyond "core skills" here, Jeff.
Heh... "Core Skills" for a Database Developer or a DBA. You might as well say "breathing" with as low...
--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)

November 26, 2013 at 1:28 pm

#1669260
RE: Which way is better in SQL Paging (With or TempTableVariable) & Why ??

There are also a wad of paging methods in the following discussion.
http://www.sqlservercentral.com/Forums/Topic672980-329-1.aspx
--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)

November 25, 2013 at 10:15 pm

#1669022
RE: Which way is better in SQL Paging (With or TempTableVariable) & Why ??

Ok, here we go. The first thing that we need is some test data. Heh… I couldn’t bring myself to put a telephone number in an NVARCHAR column...
--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)

November 25, 2013 at 9:51 pm

#1669019
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

All it has to do is happen once on my machines and I'm screwed. And monitoring for something means that it has already happened and the monitor log then...
--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)

November 25, 2013 at 6:06 pm

#1669009

Viewing 15 posts - 25,306 through 25,320 (of 59,102 total)