Click here to Skip to main content
14,542,211 members
   

Database

 
AnswerRe: Error converting data type nvarchar to datetime Pin
Mycroft Holmes21-Feb-18 12:11
professionalMycroft Holmes21-Feb-18 12:11 
AnswerRe: Error converting data type nvarchar to datetime Pin
Member 1226788921-Feb-18 19:21
MemberMember 1226788921-Feb-18 19:21 
QuestionNeed some suggestion Pin
indian14321-Feb-18 7:58
Memberindian14321-Feb-18 7:58 
QuestionDBAs- What is your biggest pet peeve with developers? Pin
Member 1320002419-Feb-18 13:32
MemberMember 1320002419-Feb-18 13:32 
JokeRe: DBAs- What is your biggest pet peeve with developers? Pin
Mycroft Holmes19-Feb-18 15:25
professionalMycroft Holmes19-Feb-18 15:25 
AnswerRe: DBAs- What is your biggest pet peeve with developers? Pin
Eddy Vluggen19-Feb-18 17:13
professionalEddy Vluggen19-Feb-18 17:13 
AnswerRe: DBAs- What is your biggest pet peeve with developers? Pin
ZurdoDev20-Feb-18 2:10
mveZurdoDev20-Feb-18 2:10 
AnswerRe: DBAs- What is your biggest pet peeve with developers? Pin
S Douglas8-Mar-18 5:13
professionalS Douglas8-Mar-18 5:13 
This is a little late, but here go some of my annoyances.

1) The sky is falling emails. Just because your application isn't working, doesn't mean the entire environment is down.

2) CCing everyone in management because you are having an issue...

3) Failure to plan, just because you failed to plan out a release doesn't constitute an emergency on my part.
Not communicating releases and complaining when something doesn't work right.
[The DW team, loves to chew up 100s of gigs of space in a single release without communicating then screaming about when the drives fill up]

4) Trying to use the Database server as a File server, send mail server, or other random stuff. No, the database server is there to serve up data, not be some Swiss utility knife.

5) Not keeping in mind my time, and the totality of the environment. Please start out with where your problem is at.
I have 1700 databases spread across Dev, Test, PreProd and Production. No I don't just know where you are having an issue at, if I was psychic I would come up with the winning lotto numbers so I no longer need to work.

6) Security rules are not just setup randomly, they are often established by controls put in place by auditors.
I am accountable to those rules, so everyone needs to follow them.
Things like demanding SA rights to a db instance, no, there is nothing at the Database Server level you need to change. Things have been setup that way for a reason.

7) Not taking advice on a designs that are just terrible.
Just because it worked with 10 rows of data doesn't mean it will scale with 10M rows. Complaining about the server isn't going to solve your issue.

Setting aside the petty grips, a lot of the issues boil down to communication and a willingness to collaborate. My time gets stretched in a lot of directions, I go from meetings with network, server, dev, auditors, management, vendors and yes even end users. It’s not always possible for me to just drop everything to help someone out.

Common sense is admitting there is cause and effect and that you can exert some control over what you understand.


QuestionCan a computer install multiple versions of SQL Server Management Studio ? Pin
Member 245846712-Feb-18 15:58
MemberMember 245846712-Feb-18 15:58 
AnswerRe: Can a computer install multiple versions of SQL Server Management Studio ? Pin
Chris Quinn12-Feb-18 21:53
MemberChris Quinn12-Feb-18 21:53 
AnswerRe: Can a computer install multiple versions of SQL Server Management Studio ? Pin
phil.o13-Feb-18 0:16
mvephil.o13-Feb-18 0:16 
GeneralRe: Can a computer install multiple versions of SQL Server Management Studio ? Pin
jschell13-Feb-18 15:26
Memberjschell13-Feb-18 15:26 
GeneralRe: Can a computer install multiple versions of SQL Server Management Studio ? Pin
phil.o13-Feb-18 15:39
mvephil.o13-Feb-18 15:39 
AnswerRe: Can a computer install multiple versions of SQL Server Management Studio ? Pin
MadMyche23-Feb-18 3:37
mveMadMyche23-Feb-18 3:37 
QuestionHow can I convert SQL Server data file version ? Pin
Member 24584678-Feb-18 14:39
MemberMember 24584678-Feb-18 14:39 
AnswerRe: How can I convert SQL Server data file version ? Pin
Mycroft Holmes8-Feb-18 14:57
professionalMycroft Holmes8-Feb-18 14:57 
AnswerRe: How can I convert SQL Server data file version ? Pin
Chris Quinn8-Feb-18 22:56
MemberChris Quinn8-Feb-18 22:56 
AnswerRe: How can I convert SQL Server data file version ? Pin
jschell10-Feb-18 6:44
Memberjschell10-Feb-18 6:44 
QuestionSql Server 2017 with Transact and synonyms Problems. Microsoft does not respond. Pin
zequion7-Feb-18 19:48
professionalzequion7-Feb-18 19:48 
Questionhow to delete specific data from multiple tables in sql database Pin
Ko Htet Kyaw7-Feb-18 5:53
MemberKo Htet Kyaw7-Feb-18 5:53 
AnswerRe: how to delete specific data from multiple tables in sql database Pin
ZurdoDev7-Feb-18 7:16
mveZurdoDev7-Feb-18 7:16 
QuestionQuick Join to get the weight Pin
jkirkerx5-Feb-18 11:16
professionaljkirkerx5-Feb-18 11:16 
AnswerRe: Quick Join to get the weight Pin
Richard Deeming6-Feb-18 2:33
mveRichard Deeming6-Feb-18 2:33 
GeneralRe: Quick Join to get the weight Pin
jkirkerx7-Feb-18 6:56
professionaljkirkerx7-Feb-18 6:56 
QuestionTo update multiple dynamic field in a single query Pin
Member 136574851-Feb-18 23:01
MemberMember 136574851-Feb-18 23:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.