Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,121 through 21,135 (of 59,098 total)

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
RE: Split function that allows multiple character delimitter

No problem. You're happy with the performance of the While loop 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)

April 2, 2015 at 6:35 pm

#1788453
RE: XP_cmdshell DIR

Stephen Swan (4/2/2015)
I modified Jeff's procedure to allow for subfolders. I put a maxDepth parameter into it for some control as needed. Thanks Jeff for the code.
ALTER PROCEDURE dbo.GetDirDetails
/**************************************************************************************************
...
--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 2, 2015 at 6:26 pm

#1788452
RE: SP with xp_cmdshell gives an error in the MessageQueue, but executes successfully in SSMS!!

Is the owner of the database a member of the sysadmin role?
--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 2, 2015 at 6:02 pm

#1788450
RE: Identity on Uniqueidentifier

tomy200501 (4/1/2015)
Hello All,
I am trying to set "Is Identity property" To Yes on a column that has uniqueidentifier as a type and has a primary key constraint on it. 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 1, 2015 at 9:24 pm

#1788179

Viewing 15 posts - 21,121 through 21,135 (of 59,098 total)