Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,966 through 19,980 (of 59,072 total)

RE: Are the posted questions getting worse?

I think before we get into interview questions, it would be much better to define what a DBA/Developer needs to be, know, and do.
I remember a post that someone made...
--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 4:41 pm

#1817352
RE: SQL Alerts and WMI

Wouldn't a simple WMI windows alert be easier and more fruitful since that's what they were designed for?
http://www.opennms.org/wiki/Enable_monitoring_of_CPU_utilization_on_Windows_systems
--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 3:11 pm

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

Script tasks ARE fun but it shouldn't be necessary. SSIS should be able to handle the problem just fine if the text qualifier is enabled.
--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 2:57 pm

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

bghad1 (8/4/2015)
Jeff Moden (8/4/2015)
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...
--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 2:40 pm

#1817326
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

Viewing 15 posts - 19,966 through 19,980 (of 59,072 total)