Viewing 14 posts - 1 through 15 (of 15 total)
I believe that the issue here is data vs. information, then actions taken upon the information.
Medical lab equipment: data.
AI/Doctor interpreting data: information.
Surgeon acting upon information.
I'm with you, both should be...
Coder since 1977.
Been there.
Done that.
A lot.
Still doing it. ??
June 15, 2026 at 3:29 pm
Perfect timing. I've been a SQL Server nut since 3.51, dabbled with PortgreSQL way back in the day, only recently kicked its tires again and was surprised to see how...
Coder since 1977.
Been there.
Done that.
A lot.
Still doing it. ??
June 1, 2026 at 3:04 pm
I've been a coder since the 70's and a software engineer since the 90's. BS in Com Sci, MS in Software Engineering. Of the 2 BS programs I experienced, neither...
Coder since 1977.
Been there.
Done that.
A lot.
Still doing it. ??
October 3, 2022 at 4:15 pm
Thank you guys for your advice, I appreciate it. While waiting to see if our DBA team can help more, I'm expanding my gathering of benchmark metrics and, unless the...
Coder since 1977.
Been there.
Done that.
A lot.
Still doing it. ??
February 13, 2019 at 8:23 am
Coder since 1977.
Been there.
Done that.
A lot.
Still doing it. ??
February 12, 2019 at 10:01 am
ManicStar - Tuesday, February 12, 2019 9:36 AM
(re: article) "They don’t work so well in T-SQL and they’re often not compatible...
Coder since 1977.
Been there.
Done that.
A lot.
Still doing it. ??
February 12, 2019 at 9:52 am
Coder since 1977.
Been there.
Done that.
A lot.
Still doing it. ??
February 12, 2019 at 8:35 am
Maybe, but it doesn't have the right smell. The sprocs we've noticed slowing down do so suddenly, going from, for example, 1s to 45s, given the same params. If the...
Coder since 1977.
Been there.
Done that.
A lot.
Still doing it. ??
February 11, 2019 at 3:31 pm
"Query store" Is that some form of auditing, like when a sproc might get re-inserted into the cache? (I'm just guessing that maybe sprocs get dropped from memory periodically, possibly...
Coder since 1977.
Been there.
Done that.
A lot.
Still doing it. ??
February 11, 2019 at 12:10 pm
2 methods I use a lot, depending on frequency:
1. SET MyColumn = COALESCE(@paramTimestamp, GETUTCDATE()) ...
and
2. Use a table constraint on a DATETIME (or DATETIME2) column. For...
Coder since 1977.
Been there.
Done that.
A lot.
Still doing it. ??
February 11, 2019 at 12:04 pm
More digging, tried using sp_configure to allow ad hoc queries, got a little closer...
Now I'm just getting a generic error:
Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.15.0" for linked...
Coder since 1977.
Been there.
Done that.
A lot.
Still doing it. ??
November 5, 2015 at 2:35 pm
What you say certainly make sense, but then how is the following DTS connection string working (taken from the SSIS pkg saved to file)?
<DTS:Property DTS:Name="ConnectionString">Data Source=C:\Databases\Access\myfile.mdb;OLE DB SERVICES=0;Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;</DTS:Property>
The...
Coder since 1977.
Been there.
Done that.
A lot.
Still doing it. ??
November 5, 2015 at 12:33 pm
Same error when using a linked server.
Odd that SSIS (using a DTS connection string) works but SSMS doesn't. Both are using "Provider=Microsoft.Jet.OLEDB.4.0", too.
Coder since 1977.
Been there.
Done that.
A lot.
Still doing it. ??
November 4, 2015 at 3:39 pm
I, also, work for a very large company which aggressively monitors employees' hours to ensure nobody burns out. Amazingly, this is the only such company from over a dozen for...
Coder since 1977.
Been there.
Done that.
A lot.
Still doing it. ??
April 27, 2015 at 10:19 am
Viewing 14 posts - 1 through 15 (of 15 total)