Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,981 through 19,995 (of 59,098 total)

RE: Interview Questions Help

Kutang Pan (8/5/2015)
Greetings Colleagues,
I’ll be leaving my company very soon and my manager asked me to write some interview questions for whoever will be taking over. The thing is there...
--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 5, 2015 at 7:56 am

#1817536
RE: SQL Server 2012/14 - crisis - cannot connect - please help

DuncEduardo (8/5/2015)
Tell you what they don't make it easy.
You said a mouthful there!
--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 5, 2015 at 7:44 am

#1817526
RE: SQL Server 2012/14 - crisis - cannot connect - please help

This is actually pretty simple if you don't mind the databases being permanently converted to 2014, which they already are...
Buy a copy of the SQL Server Developer's Edition for...
--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 5, 2015 at 6:59 am

#1817487
RE: Looking for someone to team up with

Igor Micev (8/5/2015)
Clever approach from Superdoc.
It is clever, indeed. Learning as a team is a great way to go and that's why I asked the question after 3 years...
--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 5, 2015 at 6:53 am

#1817483
RE: Looking for someone to team up with

Brandon Carl Goodman (8/4/2015)
I am interested.
It might be too late, Brandon. The original post is 3 years old.
--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 5, 2015 at 6:52 am

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

jghali (8/5/2015)
Jeff,
I want to thank you for the great powerpoint presentation that you passed along. It is exactly what I was looking for to prove to my superiors 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 5, 2015 at 6:49 am

#1817480
RE: Are the posted questions getting worse?

SQLRNNR (8/4/2015)
Jeff Moden (8/4/2015)
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...
--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 11:25 pm

#1817381
RE: Outputting Sproc result set to a new physical table

Ok... here's a very simple demonstration of how it can be done with OPENROWSET. The following will execute sp_DirTree for C:\Temp and creates a temporary table from it using...
--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:34 pm

#1817373
RE: Outputting Sproc result set to a new physical table

Eirikur Eiriksson (8/4/2015)
sgmunson (8/4/2015)
Eirikur Eiriksson (8/4/2015)
sgmunson (8/4/2015)
Eirikur Eiriksson (8/3/2015)
Quick suggestion, use sys.dm_exec_describe_first_result_set or sys.dm_exec_describe_first_result_set_for_object, to get the structure of the output of the stored procedure.
😎
According to MS doc, 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 5:49 pm

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

sshobha297 (8/4/2015)
Its a Windows Authenticated Login
I am not sure what does this means ( If the latter, is it Windows Group or a single AD account? )
But its a AD...
--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 5:48 pm

#1817359
RE: Looking for someone to team up with

Superdoc (5/1/2012)
Hi Guys,
i'm getting my hands on DBA, i'm looking for someone who's interested to learn together so it motivates, i live in Bangalore, please let me know if anyone...
--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:54 pm

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

Viewing 15 posts - 19,981 through 19,995 (of 59,098 total)