Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,356 through 20,370 (of 59,072 total)

RE: TVF is slower when running as paramerized

phosplait (6/12/2015)
@jeff, there is no begin in the function. It is an inline function that does a cross apply with another inline function onto a range of dates
Just had 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)

June 12, 2015 at 4:49 pm

#1805275
RE: Which certificate will help me earn a job in IT?

hanialbarni (2/9/2015)
I don't think they can help me in getting a job. all the jobs I apply for they all need at least 1 year experience or more which I...
--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)

June 12, 2015 at 2:56 pm

#1805260
RE: db_datareader

charipg (6/12/2015)
user have db_datareader role in in a database.
But user is not able to see the storedprocedures.
any suggestion pls.
I have a different suggestion than the others... why is it necessary...
--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)

June 12, 2015 at 2:41 pm

#1805249
RE: TVF is slower when running as paramerized

phosplait (6/12/2015)
I am trying to run an inline TVF as a parameterized SQL query.
Just to be sure, does the function code contain the word BEGIN anywhere in 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)

June 12, 2015 at 2:37 pm

#1805247
RE: The Scientific Method: a call to action

With that in mind and for those people that exclaim, "OK. You sold me. Where the hell do you get a million rows of test data?", the answer...
--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)

June 12, 2015 at 2:33 pm

#1805245
RE: OPENROWSET problem

sgmunson (6/12/2015)
Why don't they just use SSIS ? Even the import/export wizard in SSMS might be a better choice. I suspect a registry permissions issue, but...
--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)

June 12, 2015 at 2:27 pm

#1805242
RE: OPENROWSET problem

n.heyen (6/12/2015)
I have a test server (TEST1) running SQL 2012 and Windows 2012R2. One of the developers wants to use OPENROWSET to read in data from an Excel 2010 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)

June 12, 2015 at 2:26 pm

#1805238
RE: Sql Server Core vs Full blown version of SQL Server

I can't speak for anyone else and I'm sure that it will rub some folks' sensibilities the wrong way but I do install the full monty on my servers and...
--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)

June 12, 2015 at 10:44 am

#1805147
RE: Index rebuild slow on 2014

Outstanding feedback, Michael. Thanks for taking the time to post 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)

June 12, 2015 at 9:43 am

#1805101
RE: How to find the date created and date modified values of all files in a location.

Do the files actually have a date and time in the file name? That would make life pretty easy. If so, please post the "general" format of 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)

June 12, 2015 at 9:39 am

#1805099
RE: The Scientific Method: a call to action

Please folks... there's a time and a place for everything. I realize that it's an important subject but let's not turn this wonderful thread into a "global warming thread".
--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)

June 12, 2015 at 8:41 am

#1805075
RE: How to find the date created and date modified values of all files in a location.

SQL-DBA-01 (6/12/2015)
Thanks.
Anyway you can help me getting the script in xp_cmdshell?
Were the two methods of mine that you found on a couple of the other posts too slow (and I...
--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)

June 12, 2015 at 8:23 am

#1805065
RE: Finding / getting in touch with recruiters?

jasona.work (6/11/2015)
For the most part though, staying in the Metro Detroit / suburbs area would be preferred.
That's where all the all the recruiters I know are at... between downtown and...
--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)

June 12, 2015 at 8:19 am

#1805061
RE: Finding / getting in touch with recruiters?

Eric M Russell (6/12/2015)
Also build up a cash emergency fund enough to cover three months of basic living expenses. You may end up needing that to pay bills or at...
--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)

June 12, 2015 at 8:17 am

#1805059
RE: Need better query to capture job runs on sql servers

Barkingdog (6/12/2015)
Jeff,
Thank you for the perspective. I like it and will remove the WHERE clause as you suggested.
BD
We'll need to do a bit more than just removing the WHERE clause....
--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)

June 12, 2015 at 1:09 am

#1804889

Viewing 15 posts - 20,356 through 20,370 (of 59,072 total)