Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,286 through 18,300 (of 59,102 total)

RE: CAST tinyint to nvarchar

Ed Wagner (2/26/2016)
Yeah, I tend to go with a very literal interpretation. As has been pointed out, a simple Error in the table would have helped. I can...
--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)

February 28, 2016 at 7:55 am

#1861691
RE: Deadlock help please

gary1 (2/27/2016)
Thanks Jeff,
I was not running any queries in SSMS. We were running bunch of sql scripts which will do some updates (it's a vendor application, will get an...
--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)

February 28, 2016 at 7:45 am

#1861689
RE: The Dangers of Algorithms

Outstanding article, Steve. I'd discuss it a bit more but, being a customer/consumer of software, I would tick off the whole world with my thoughts in this area, so...
--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)

February 27, 2016 at 7:34 pm

#1861668
RE: Converting VARCHAR to BIGINT

Luis Cazares (2/27/2016)
Jeff Moden (2/25/2016)
Luis Cazares (2/25/2016)
If by any chance you're working with SQL Server 2012 or later, you can use TRY_CAST or TRY_CONVERT.
Have you compared it for performance?
I...
--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)

February 27, 2016 at 6:37 pm

#1861667
RE: Converting VARCHAR to BIGINT

SQLBill (2/25/2016)
You should also be able to use ISNUMERIC to see what data is not numeric and therefore can't be converted.
-SQLBill
Careful now. ISNUMERIC should never be confused with ISALLDIGITS....
--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)

February 27, 2016 at 6:34 pm

#1861666
RE: Converting VARCHAR to BIGINT

dogramone (2/25/2016)
Have a look at the script here
http://www.sqlservercentral.com/scripts/IsNumber/70211/
That's a Scalar Function with more than 1 While Loop. While it may do the job, it's RBAR on steroids and I...
--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)

February 27, 2016 at 6:32 pm

#1861665
RE: Error in merge statement in Tsql

baiju krishnan (2/27/2016)
The MERGE statement attempted to UPDATE or DELETE the same row more than once. [font="Arial Black"]This happens when a target row matches more than one source row.[/font] 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)

February 27, 2016 at 4:27 pm

#1861658
RE: Match all duplicate IDs in a single row for review

staugust1 (2/27/2016)
...OR the same LastName and State...
To be honest, if you have very much data at all, that could return a huge number of potential duplicates. If someone told...
--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)

February 27, 2016 at 4:14 pm

#1861655
RE: Deadlock help please

Someone else might be able to glean a whole lot more from what you listed but, for me, there's not a whole lot of information about the Query that was...
--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)

February 27, 2016 at 4:07 pm

#1861654
RE: Please help fix this error in SSIS 2008 package, data flow..

Luis Cazares (2/26/2016)
SSIS won't work correctly with temp tables. You need to use a permanent table for your script.
Unless there's a workaround using certain settings, but I don't remember any.
Heh......
--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)

February 27, 2016 at 6:38 am

#1861620
RE: Returning Multiple Unrelated Tables in Single XML Output From Stored Proc

Sean Lange (10/26/2012)
riaan-777462 (10/26/2012)
Hi There,
I'm quite inexperienced in returning XML from SQL and have only been using single tables to return normal XML in the past.
Now, however, I need to...
--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)

February 27, 2016 at 6:34 am

#1861619
RE: IDEs sweet but beguiling

This is a really good article, Phil. It actually echoes what Bill Gates predicted back in the '80s when he said that, soon, there would be no programmers, just...
--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)

February 27, 2016 at 6:31 am

#1861618
RE: Hierarchy with changing levels

@glabrecque,
I keep looking at the jpg file that represents what you want for the final result and I keep asking myself what you would use that result for. 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)

February 26, 2016 at 7:55 pm

#1861601
RE: Please help fix this error in SSIS 2008 package, data flow..

VoldemarG (2/25/2016)
i am executing the attached script (SSIS 2008 r2)
SCRIPT1.PDF either directly in OLEDB data source via query and outputting result as is to FLAT FILE.
OR
as a compiled...
--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)

February 26, 2016 at 5:16 pm

#1861596
RE: SQL backup best practices

Lwestcott 17148 (2/26/2016)
Thank you for the help!
Ok, dumb question, but why can't the "tool" take a parameter or two like fragmentation percent and/or number of pages in use? When above...
--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)

February 26, 2016 at 5:03 pm

#1861595

Viewing 15 posts - 18,286 through 18,300 (of 59,102 total)