Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,951 through 19,965 (of 59,072 total)

RE: parsing a line post import

Edward-445599 (8/4/2015)
I have a table which has been import from a TXT file. Most lines can be ignored, but when I get a line like 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)

August 5, 2015 at 8:30 am

#1817560
RE: Looking for someone to team up with

Brandon Carl Goodman (8/5/2015)
I should of paid better attention to the date.
You could post a similar question via your own post if you're still interested in buddying up with someone...
--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 8:18 am

#1817552
RE: Prep for large increase in usage

Or... get 3 envelopes. 😀
--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 8:14 am

#1817551
RE: User-defined function

fnndala2 (8/5/2015)
I have the following SQL-Query:
CREATE FUNCTION fn_SelectTopEmployees ()
RETURNS TABLE
AS
RETURN
(
SELECT TOP(10) EmployeeID
FROM Employees
);
When I run the query, how many times between 1 and 10...
--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 8:10 am

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

Viewing 15 posts - 19,951 through 19,965 (of 59,072 total)