Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,091 through 21,105 (of 59,072 total)

RE: Conversion Failed Varchar to Int - Why ??

homebrew01 (4/5/2015)
I came across this bug earlier today and did fix the code. But I was puzzled about why it failed.
I hadn't really though about this:
" the case statement 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)

April 5, 2015 at 6:02 pm

#1788824
RE: Running Total Performance

Eirikur Eiriksson (4/5/2015)
Jeff Moden (4/5/2015)
Eirikur Eiriksson (4/5/2015)
here is a partial testing code which strongly indicates that the original testing is somewhat flawed.
Sorry... I don't have the time to wade through...
--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)

April 5, 2015 at 5:37 pm

#1788822
RE: Running Total Performance

Eirikur Eiriksson (4/5/2015)
here is a partial testing code which strongly indicates that the original testing is somewhat flawed.
Sorry... I don't have the time to wade through a ton of undocumented...
--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)

April 5, 2015 at 5:20 pm

#1788816
RE: CSV import to SQL having issues with non character data (Date & Decimal)

Did you ever figure this out?
--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)

April 5, 2015 at 4:53 pm

#1788814
RE: Test backup restores (full + log) - restore databases automatically

efyuzegeekgurl (4/4/2015)
Hello
I am working towards automating the process of testing our backups. For the meantime, I do it all manually - I copy the backup files (full + transaction logs)...
--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)

April 5, 2015 at 4:12 pm

#1788812
RE: Importing a text file into SQL Server

itmasterw 60042 (4/3/2015)
Hi,
Someone was telling me that they had a text file that was both comma and piped delimited and that they used BCP to import it.
While they did not...
--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)

April 4, 2015 at 8:26 pm

#1788782
RE: Restore Fails on Standard Edition - statistics

krypto69 (4/4/2015)
Grant Fritchey (4/4/2015)
If the partitioning is working for your in production and you're actually using it, removing it doesn't make a lot of sense. If this other server is...
--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)

April 4, 2015 at 8:09 pm

#1788781
RE: Running Total Performance

Eirikur Eiriksson (4/4/2015)
Kathi Kellenberger (4/4/2015)
Jeff -- For the running totals functionality, I think the performance is pretty good if you use ROWS and have the correct index in place. Where...
--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)

April 4, 2015 at 8:00 pm

#1788780
RE: Running Total Performance

Kathi Kellenberger (4/4/2015)
Jeff -- For the running totals functionality, I think the performance is pretty good if you use ROWS and have the correct index in place. Where I really...
--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)

April 4, 2015 at 11:12 am

#1788755
RE: Restore Fails on Standard Edition - statistics

Hold on a minute folks. Restore to where? A Dev environment or what? I ask because it can make all the difference in the world for licensing...
--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)

April 4, 2015 at 11:01 am

#1788754
RE: COMMIT fixes problem - or will it create one?

Seggerman-675349 (4/2/2015)
my client has a stored procedure triggered by shipping action - basically adding an indicator to a shipping file depending on quantities in a shipping table
if the shipping record...
--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)

April 4, 2015 at 8:13 am

#1788740
RE: Running Total Performance

Even with the correct answer, I'm still disappointed in the performance. MS really could have done a better job on this particular subject.
--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)

April 3, 2015 at 10:14 pm

#1788702
RE: Large Chunks of Data

brs0102 (4/3/2015)
One interesting thing, to me, about the biggest reports is that (as many here have noted) they're really exports for analysis.
But in the modern era, those "exports for analysis"...
--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)

April 3, 2015 at 10:01 pm

#1788700
RE: XP_cmdshell DIR

IT's much simpler than all that. Both require "SA" privs to be used. Both can only be turned on or of by someone with "SA" privs. Control...
--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)

April 3, 2015 at 9:58 pm

#1788699
RE: XP_cmdshell DIR

Eirikur Eiriksson (4/3/2015)
I know I'm somewhat late to the show, haven't read through the whole trail and therefore might be missing something, but my approach would be the xp_cmdshell...
--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)

April 3, 2015 at 11:11 am

#1788622

Viewing 15 posts - 21,091 through 21,105 (of 59,072 total)