Viewing 15 posts - 3,226 through 3,240 (of 59,067 total)
Looks like they fixed the posting problem this morning (fonts, icon menu bar) but they still have problems with email notifications. I only get notifications for people that I follow.
We've...
June 29, 2022 at 4:59 pm
I've got an SQL database I'm wanting to put in Azure.
WHY? What problem are you trying to solve and why do you think Azure is going to help?
June 29, 2022 at 4:09 pm
I have a scenario where: a company can have many workers(01,02) & worker can have multiple jobs (jb01, jb02) within the company, and in each job the worker can...
June 29, 2022 at 4:07 pm
When you open SSMS, you may have to right click on the icon and select "Run as Administrator".
June 29, 2022 at 3:04 pm
I looked back through this thread and found the following.
Looks like I could do this:
switchoffset (CONVERT(datetimeoffset, jobstarted), '+04:00')
But how can I get just date\time and automate the offset based...
June 29, 2022 at 4:05 am
No guarantees but I'll try to take a look tonight. I'll use your original post as an example. I still maintain that if you ship them with UTC's,...
June 28, 2022 at 8:52 pm
I would recommend working with the receivers of the data to allow sending UTC directly instead of trying to perform the conversion for them. If you send UTC they...
June 28, 2022 at 7:33 pm
Could a function be created where I pass in my date and it outputs my desired date
For 2012, yes, but that doesn't change step 1. You need a...
June 28, 2022 at 6:00 pm
BTw... the easier thing to do would be to convert your local dates and times to UTC and let the users fix their stuff. 😉
June 28, 2022 at 1:05 am
If I was SQL 2016 then...
JobStarted AT TIME ZONE 'Eastern Standard Time' AT TIME ZONE 'Central European Standard Time' AS JobStarted_TimeZoneCET
That server will be moving to 2016 but need...
June 28, 2022 at 1:03 am
"does it REALLY need to be at the single row level of detail?" not necessarily
"they can tell you what aggregates they need to analyze and do that pre-aggregation for...
June 27, 2022 at 12:59 pm
If you ran out of log file space on that NCI build, you're simply going to need more disk space for the log file. I also suspect you may have...
June 27, 2022 at 7:08 am
... and if you have any elegant solution it will be great
I posted a link in my previous response as to what I think "the" elegant solution would be. ...
June 26, 2022 at 11:28 pm
Stuff like this worries me. Just obfuscating the day part of a birthday still allows someone to determine that rough age of a person and, if they have a couple...
June 26, 2022 at 9:48 pm
June 26, 2022 at 9:40 pm
Viewing 15 posts - 3,226 through 3,240 (of 59,067 total)