Viewing 15 posts - 646 through 660 (of 2,356 total)
Hi everyone
One of my queries is running too slow so I would like to output the results of the subquery into a table and then use that table in...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 16, 2021 at 6:13 pm
Data factory has a for each loop.
This may be a start. https://debbiesmspowerbiazureblog.home.blog/category/azure/azure-data-factory-azure/azure-data-factory-for-each-loop/
Why are you trying to read a spreadsheet? Can you execute a query against the source of the...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 16, 2021 at 6:11 pm
Your data types are wrong.
In your query, you are ordering by DateInsertion. Since this is stored as characters, and not a date, your sort is not going to return in...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 16, 2021 at 6:03 pm
Can you publish the code?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 16, 2021 at 3:25 pm
I am not seeing a Power BI forum on this group. Is there one and I'm just missing it?
One of our Devs has a question. He's trying to get...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 9, 2021 at 3:02 pm
What's the chance of you making the reporting login sysadmin for long enough to run and test the query?
It it runs fast, then the mystery deepens.
If if runs in the...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 8, 2021 at 4:01 pm
Considering that this a a site dedicated to Microsoft SQL Server, I do not think you are going to find a lot of resources related to MySql.
These are MySQL forums...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 6, 2021 at 2:25 pm
Hi
firstly im sorry if this is in the wrong place, i couldnt find a ssis forum.
I have been working with a mariadb, trying to get the data into sql...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 5, 2021 at 6:04 pm
Thanks a lot Phil, Michael and Bran for your incredible help and guidance. You guys have very well understood all my concerns and provided me exactly what I needed.
@Phil...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 5, 2021 at 3:13 pm
What is the difference in using 'EXISTS' instead of 'IN'?
The simple answer is that EXISTS is usually a better query plan. As I understand it, EXISTS stops when the...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 5, 2021 at 3:08 pm
Thanks guys. I also thought the Bank filter may be unnecessary. I tried removing it and got one more record than with it, I'll look into that. It ran...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 5, 2021 at 2:13 pm
I am running ACCESS 32 bit and SQL Server 64 bit
That's your issue. It will not work
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 4, 2021 at 10:36 pm
That's all it says, OBDC Call error. there is no error number, nothing. It has to be my connection string, obviously not correct.
Is the version of Access 32, or...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 4, 2021 at 9:37 pm
The actual error would be much better. WHAT ODBC error? What SPECIFICALLY did it say?
How about a screen shot???
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 4, 2021 at 8:02 pm
When I consider how much time I used to spend configuring and testing disk performance, vs. how little I do now, one would think I have a lot more free...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 4, 2021 at 5:30 pm
Viewing 15 posts - 646 through 660 (of 2,356 total)