Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,401 through 20,415 (of 59,098 total)

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
RE: How to use a year and month fields to get a range of records

waynes 78578 (6/11/2015)
Well my previous post didn't actually work for all options, hopefully this does.
I find it's a very common problem with accounting tables, which often only store the year...
--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 8:41 am

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

srgaddam2 (6/10/2015)
Jeff,
I am new to SQL server, so I would appreciate if you could help me understand the SQL hacking concept. What is the purpose of quotename? How can...
--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 8:24 am

#1804708
RE: prevent sysadmin for access

snuthalapati (6/10/2015)
Thank you for the reply...
How about any auditing kind???
I believe you'd need something 3rd party like Guardium (if I got the name right).
--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 10, 2015 at 9:13 pm

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

Ok... first of all, that query is susceptible to SQL Injection, which is still the leading cause of successful hack attacks. At the very least, wrap a QUOTENAME around...
--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 10, 2015 at 8:08 pm

#1804557

Viewing 15 posts - 20,401 through 20,415 (of 59,098 total)