Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,371 through 20,385 (of 59,072 total)

RE: Finding / getting in touch with recruiters?

jasona.work (6/11/2015)
Jeff Moden (6/9/2015)
On that note, give me some idea of where you'd actually like to work, area wise.
Jeff, realistically, I'd probably (for the right price) go as far as...
--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 11, 2015 at 10:22 pm

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

Barkingdog (6/11/2015)
Jeff,
You are absolutely right. My query will be used to create a report for the Operators group to check the daily sql runs jobs. I too have some jobs...
--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 11, 2015 at 10:18 pm

#1804876
RE: Just want to make sure I have my facts straight about autogrowth.

Steve Jones - SSC Editor (6/11/2015)
Agree with the above. You might also keep a few placeholders around: https://voiceofthedba.wordpress.com/2014/11/24/placeholders-for-emergencies/
You just have to remember to be a bit careful with what get's...
--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 11, 2015 at 10:10 pm

#1804874
RE: Parsing large varbinary fields

Ah. wait a minute. I've apparently gotten two different threads mixed up. The individual internal "rows" in your large binary are delimited by CHAR(10), correct?
--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 11, 2015 at 7:04 pm

#1804869
RE: Parsing large varbinary fields

Crud. I found it but it won't work because it only accepts a single character delimiter. I'll try something else.
--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 11, 2015 at 6:58 pm

#1804866
RE: Parsing large varbinary fields

Tom_Sacramento (6/10/2015)
Thanks Jeff and Lowell,
Just to clarify the data, it looks like this in the table:
0x0A0D302064657070696B5365426F5464656B72614D73766F4D6D754E646E
From this I need to break it into manageable (VARCHAR) pieces, like...
--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 11, 2015 at 6:39 pm

#1804863
RE: script to Find current date modify table list

Lynn Pettis (6/11/2015)
charipg (6/10/2015)
i need to find out the table names which are modified in last 24hrs.
Jeff's answer is good if you are talking about schema changes not data...
--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 11, 2015 at 4:57 pm

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

What about jobs that run more than once a day? For example, I have a dozen jobs on some servers that run once per minute. I don't want...
--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 11, 2015 at 3:07 pm

#1804847
RE: Setting Up Some Basic Maintenance Tasks

Here's one more that uses a slightly different approach for stats.
http://raresql.com/tag/sys-sysindexes/
--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 11, 2015 at 2:54 pm

#1804840
RE: Setting Up Some Basic Maintenance Tasks

There are actually two places that provide good "hints" as to whether or not stats need to be updated. Please see the following article for both.
http://www.jasonstrate.com/2012/10/what-happened-to-rowmodctr-from-sysindexes/
Of course, MS had...
--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 11, 2015 at 2:49 pm

#1804839
RE: SQL Server Data Lost on User DB's

Jeff Moden (6/11/2015)
ericpap (6/11/2015)
Ok guys. So this is the end of the road for this history.
I manage to crack the password from ZIP files I found on user profile...
--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 11, 2015 at 9:46 am

#1804751
RE: Need help for paaing table name and date as variable in dynamic sql

Ed Wagner (6/11/2015)
Lynn Pettis (6/11/2015)
Jeff hit this part on the head, and it is what I kept pushing but it appears everyone else on this thread (Scott included) kept ignoring.
You...
--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 11, 2015 at 9:43 am

#1804747
RE: How to use a year and month fields to get a range of records

waynes 78578 (6/11/2015)
Yes, it would be nice to have dates to work with, but not all accounting years start in January.
A lot of companies have April as period 1, or...
--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 11, 2015 at 9:40 am

#1804746
RE: Need help for paaing table name and date as variable in dynamic sql

ScottPletcher (6/11/2015)
But, injection or no, be prepared to explain to auditors why on earth you're allowing external users to view any invoices, let alone a big batch of them.
Amen 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 11, 2015 at 9:25 am

#1804734
RE: SQL Server Data Lost on User DB's

ericpap (6/11/2015)
Ok guys. So this is the end of the road for this history.
I manage to crack the password from ZIP files I found on user profile recycled bin....
--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 11, 2015 at 9:24 am

#1804733

Viewing 15 posts - 20,371 through 20,385 (of 59,072 total)