Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,996 through 20,010 (of 59,098 total)

RE: Code to Archive Data

Ah... the other possible problem that you may be having for the download of the attachment is the possibility of blocked downloads by your company policy.
--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)

August 4, 2015 at 12:17 pm

#1817268
RE: Code to Archive Data

Welsh Corgi (8/4/2015)
Thanks Jeff.
When I click on the like it directs me to the main forum page.
I'm going to probably archive year.
Thanks again.
You click on the attachment link and 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)

August 4, 2015 at 12:16 pm

#1817267
RE: If you could use xp_CmdShell securely, would you?

SoHelpMeCodd (8/4/2015)
Just for some color.
Let's imagine a harangued writer in SQL Server's documentation ("user education") team, one who cannot write about the new features until *after* the feature 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)

August 4, 2015 at 12:09 pm

#1817264
RE: Proc that create views with table name and a table field parameter (scalar variable issue)

Sean Lange (8/4/2015)
blossom_suki (8/4/2015)
Actually, I need to create 20 views for each database, in the system we have more than 90 databases.
Thus, I was wondering if there is an automated...
--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)

August 4, 2015 at 9:40 am

#1817212
RE: How to find out the list of users who has direct grant to a service account ?

sshobha297 (8/4/2015)
Also , is it true that Grants to service accounts should go through roles as it is against audit & compliance standards ??
If yes, than how to find...
--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)

August 4, 2015 at 9:08 am

#1817173
RE: Ola Hallengren's Maintenance Solution - Calling DatabaseBackup from another stored proc

Have you actually tested backing up to 20 files for purposes of performance? I've seen backups to just 3 files absolutely kill performance because they didn't back up 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)

August 4, 2015 at 9:05 am

#1817172
RE: can a foreign nationals find a job in BI position ?

bghad1 (8/4/2015)
i heard that is the case in the states and Europe..
Looking at this and your other posts, you're nothing more than an idiot spammer for the link you have...
--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)

August 4, 2015 at 9:00 am

#1817169
RE: How to concatenate/convert date and time into a datetime?

SQL Guy 1 (8/3/2015)
djj (8/3/2015)
I have had luck with
DECLARE @Date DATE = '1/1/2015', @Time TIME = '15:20'
SELECT cast(@Date as datetime) + cast(@Time as datetime)
This looks like the most...
--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)

August 4, 2015 at 8:58 am

#1817167
RE: How to concatenate/convert date and time into a datetime?

drew.allen (8/3/2015)
djj (8/3/2015)
I have had luck with
DECLARE @Date DATE = '1/1/2015', @Time TIME = '15:20'
SELECT cast(@Date as datetime) + cast(@Time as datetime)
I expect that to stop working at some...
--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)

August 4, 2015 at 8:56 am

#1817164
RE: How to concatenate/convert date and time into a datetime?

Jacob Wilkins (8/3/2015)
djj (8/3/2015)
I have had luck with
DECLARE @Date DATE = '1/1/2015', @Time TIME = '15:20'
SELECT cast(@Date as datetime) + cast(@Time as datetime)
Indeed. On a couple million rows, 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)

August 4, 2015 at 8:49 am

#1817155
RE: Proc that create views with table name and a table field parameter (scalar variable issue)

To emphasize what Sean said, doing a SELECT * in a view is a form of "death by SQL". The SELECT * in views and functions is positional rather...
--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)

August 4, 2015 at 8:43 am

#1817149
RE: Sql Query

Might have to add the 3 different WHERE clauses to that... they are all different.
--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)

August 4, 2015 at 8:34 am

#1817138
RE: Code to Archive Data

Then you might want to consider the methods in the attached presentation. It's definitely worth going through the presentation in the "present" mode because it's somewhat animated to explain...
--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)

August 4, 2015 at 7:59 am

#1817116
RE: Problem with Importing flat files with embedded (CR)(LF) characters.

To add to what Phil stated, text qualifiers are usually conditional. That is, the system only considers them when they are present. They aren't treated as if they...
--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)

August 4, 2015 at 7:04 am

#1817091
RE: But we've always done it that way…

On the other side of the same coin...
I won't support change for the sake of change or for the sake of someone being a cool kid that just deployed the...
--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)

August 3, 2015 at 11:23 pm

#1816996

Viewing 15 posts - 19,996 through 20,010 (of 59,098 total)