Viewing 15 posts - 1 through 15 (of 25 total)
Thank you, @tellery_frmt for your comment.
If you use months to calculate the DOB, then your age will inflate at the start of your birth month, which is not...
February 27, 2020 at 3:23 pm
Thank you, @beervolk. Could you please also explain briefly why do you prefer to use sysdatetime over getdate?
February 27, 2020 at 3:11 pm
Thank you for your comment, @Ray-Giacalone, and @pietlinden.
If you have a MonthNumber field in your dataset, you should sort all your month-wise charts by that field....
February 19, 2020 at 5:40 am
Thank you for this @steve-jones-ssc-editor.
This is one of the important factors that need to be addressed when developers start building any new data application. In my organization, we...
January 13, 2020 at 5:19 pm
Ideally, if it is the default instance, I'd suggest you connect to it using the hostname only (from both SSMS and SQLCMD).
Hope this answers your question.
January 6, 2020 at 4:41 pm
Can you please run the following query and share a screenprint?
If it returns NULL, then it is the Default Instance otherwise it will return the instance name.
January 6, 2020 at 4:10 pm
January 6, 2020 at 3:28 pm
If I understand correctly what you're trying to say, you have SQL Server running on a notebook (PC #1) and you're trying to connect to it from...
January 6, 2020 at 2:48 pm
I think you have to use the following format to connect to the named SQL instance inside your VM.
HOSTNAME\INSTANCENAME. (Hostname = VM PC Name)
I hope this helps.
January 6, 2020 at 12:35 pm
Thank you for sharing the link, @Chris-Wooding.
November 5, 2019 at 2:34 pm
Thanks @bob-56901. I'll add that to my to-do list. Will keep you posted of my upcoming posts on this topic.
November 4, 2019 at 5:01 pm
That's interesting, @mvdba. Being a developer, I keep myself restricted from fire fighting with the production environment. It is a nightmare for me to update values in production...
October 30, 2019 at 7:00 pm
@bryant-mcclellan, NOLOCK seems to be a bit scary to me, especially when reporting financial data. There's a huge possibility that the reports might be generated with incorrect data,...
October 28, 2019 at 3:57 pm
Haha! Well said @patrickmcginnis59-10839. Reminded me of one of my old bosses.
October 28, 2019 at 3:22 pm
Thank you @pailwriter. It's my pleasure to be helpful to the community.
October 28, 2019 at 3:02 pm