Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,821 through 26,835 (of 59,099 total)

RE: automate estore database into database with a different name

AndrewSQLDBA (5/16/2013)
This is the code that I use. I have a DatabaseMaintenance Database that all my maintenance code is stored and runs form
------------ Backup Database ----------
BACKUP DATABASE [<DatabaseName>]
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)

May 17, 2013 at 5:46 pm

#1616358
RE: Pulling Filename from Windows directory into table

erouse (5/17/2013)
Great procedure, thank you.
If I run it on the local drive it works great.
----------
USE [master]
GO
DECLARE@return_value int
EXEC@return_value = [dbo].[GetDirDetails]
@piFullPath = N'C:\'
SELECT'Return Value' = @return_value
GO
----------
However if try 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)

May 17, 2013 at 4:20 pm

#1616354
RE: Urgent help - foreach loop container

It sounds to me like you're using the wrong tool.
Are you using an "Parent/Child" table to drive all of this?
--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 16, 2013 at 9:44 pm

#1616035
RE: high processor usage

PearlJammer1 (5/16/2013)
solution discovered ! - Our instances where being moved to another VM and they didnt tell me !!!
It sounds like it's time to take those boys out for 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 16, 2013 at 12:43 pm

#1615962
RE: Difference in SQL

subhajeetsur (5/16/2013)
SQL: a language for talking to the database. It lets you select data, mutable and create database objects (like tables, views, etc.), change database settings.
T-SQL: (procedural) extensions for SQL...
--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 16, 2013 at 12:36 pm

#1615958
RE: same function from sql 2000 doesn't work on sql 2008 r2

Linda_web (5/16/2013)
We have very strange situation I hope someone can help, we copied a database from sql 2000 sp4 to sql 2008 R2 SP2 , runs with compatibility level 2000,...
--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 16, 2013 at 8:39 am

#1615830
RE: automate estore database into database with a different name

AndrewSQLDBA (5/15/2013)
Sure, write your code in a sproc and execute the sproc from a SQL Job. Very simple.
Andrew SQLDBA
If it's so simple, would you post some code to do it?
--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 15, 2013 at 11:23 pm

#1615612
RE: The Empty Set vs No Result

Knowledge Draftsman (5/15/2013)
So, I did a little playing around myself, and discovered that as far as performance goes there is zero difference. At least with the size data set that...
--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 15, 2013 at 8:55 pm

#1615597
RE: Generate a random password

I'll warn again that such pasword generators have a pretty good potential for creating some pretty nasty swear words. At least take out the vowels to make it 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 15, 2013 at 9:51 am

#1615509
RE: TempDB full

HanShi (5/14/2013)
** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
I absolutely love that quote.
--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 14, 2013 at 10:59 pm

#1615272
RE: convert varchar to date

sqlfriends (5/14/2013)
I would like to convert a varchar column to datetime.
The varchar column are supposed are be like a date : 2013-05-12
But there may be a wrong date due 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)

May 14, 2013 at 10:50 pm

#1615271
RE: Restart Server to shrink TempDB?

Draelith (5/14/2013)
So I had a bad query blow out the tempdb (dev, not log) database to 36GB. It's normally a lot smaller. I'm looking at the best way to resolve...
--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 14, 2013 at 10:44 pm

#1615270
RE: Are the posted questions getting worse?

jcrawf02 (5/14/2013)
Jeff, wanted to thank you (and everyone who helped) again for the delimitedsplit8k function, I just had an experience at work where you made me look really good.
file...
--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 14, 2013 at 5:04 pm

#1615245
RE: Parsing a summary / detail flat file

Oh my! How ironic. The author of that article used a script to do pretty much what I thought an SQLCLR could be written to do.
--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 13, 2013 at 8:03 pm

#1614829
RE: Parsing a summary / detail flat file

Evil Kraig F (5/13/2013)
Jeff Moden (5/13/2013)
Brandie Tarvin (5/13/2013)
Duh. Forgot there is a record 4 line which is the last line of the file. Anyway, sample data attached and CREATE TABLE...
--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 13, 2013 at 7:57 pm

#1614828

Viewing 15 posts - 26,821 through 26,835 (of 59,099 total)