Luis Cazares

Forum Replies Created

Viewing 15 posts - 2,686 through 2,700 (of 8,731 total)

RE: Interview Questions

And here I was thinking of using a NOLOCK hint. Anyhow, both seem like bad ideas if the issues are not completely understood.
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 14, 2016 at 2:24 pm

#1885037
RE: Function to convert a datetime value into a harvest season year

joe-584802 (6/14/2016)
Thanks for the improvement Lynne, I'm guessing table valued functions are more efficient than in-line scalar valued functions?
Inline table valued functions are more efficient. Multi-statement table valued functions are...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 14, 2016 at 1:44 pm

#1885025
RE: Function to convert a datetime value into a harvest season year

Avoid that. User defined scalar functions in SQL Server are known for giving performance problems. They're slow and they prevent parallelism.
EDIT: Took too long to reply, I just want to...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 14, 2016 at 1:26 pm

#1885016
RE: Function to convert a datetime value into a harvest season year

I expect that Lynn's option can be simplified without errors.
DECLARE @Sample TABLE(
SomeDate datetime,
HarvestYr int
);
INSERT INTO @Sample
VALUES
...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 14, 2016 at 11:26 am

#1884973
RE: OR in the where clause or two select statements and a union

Change your UNION to a UNION ALL, unless you want to eliminate duplicates.
UNION will need to add a sort which is expensive.
If your queries have adequate indexes, I'd go with...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 14, 2016 at 8:58 am

#1884923
RE: Should DBA grant developer access to system tables?

HookSqlDba7 (6/14/2016)
Luis Cazares (6/14/2016)
The developer should be able to read, at least in non-production environments to create stored procedures which would be deployed to production to apply a more...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 14, 2016 at 8:35 am

#1884911
RE: Should DBA grant developer access to system tables?

I don't see what's the problem. The developer should be able to read, at least in non-production environments to create stored procedures which would be deployed to production to apply...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 14, 2016 at 8:06 am

#1884902
RE: Are the posted questions getting worse?

Sean Lange (6/14/2016)
Luis Cazares (6/14/2016)
Sometimes I just want to post RTFA(rticle).
People are given answers with an article that explains the solution, but won't bother reading and keep posting saying...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 14, 2016 at 7:41 am

#1884895
RE: Today's Random Word!

Ed Wagner (6/14/2016)
Grumpy DBA (6/14/2016)
TomThomson (6/14/2016)
Hallow
Sanctify
Redeem
Guilt
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 14, 2016 at 7:09 am

#1884885
RE: Are the posted questions getting worse?

Sometimes I just want to post RTFA(rticle).
People are given answers with an article that explains the solution, but won't bother reading and keep posting saying they don't have the...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 14, 2016 at 7:08 am

#1884884
RE: Help Script Group by Order

angelreynosog (6/13/2016)
Hello dears,
Recently it made a change where I work on the database. There are currently 2 database and I have to make an inquiry . Follows , I have...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 13, 2016 at 1:53 pm

#1884768
RE: Function to get Number from word

I wonder what would happen if you find "23 hundred Someplace Rd". That's a real possibility if you have free text fields.
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 13, 2016 at 12:32 pm

#1884753
RE: Need help using a Table variable in a dynamic sql query

Douglas is right. Even if the definitions are the same, you need to use the defined table-type.
On a different topic, you might want to change your splitter function to prevent...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 13, 2016 at 12:23 pm

#1884751
RE: Function to get Number from word

How are you validating your input? What happens if someone sends "Seocnd"? Would you expect "thirty-five" or "thirty five"?
Be careful as this might be a problem.
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 13, 2016 at 11:18 am

#1884731
RE: Function to get Number from word

A mapping table would be the best option in SQL Server. A function would be an option in a procedural language such as C#.
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 13, 2016 at 10:37 am

#1884716

Viewing 15 posts - 2,686 through 2,700 (of 8,731 total)