Forum Replies Created
Viewing 15 posts - 226 through 240 (of 2,356 total)
-
Reply To: Schedule a PowerBI dataset refresh on the "quarter" hour ???
sgmunson wrote:Hi all,
I know very little about Power BI, but I am hopeful that someone here has enough knowledge to know whether or not it is even possible to schedule...
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/ -
Reply To: Login Failed. The login is from an untrusted domain and error 18452
Why are these replies getting flagged as spam?
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/ -
Reply To: Arithmetic overflow error converting expression to data type smallint. The state
rajemessage 14195 wrote:This is the code which is creating the problem (bridgid is bigint ,remaks is varchar(250) status smallint) in both the tables mentioned below. INSERT INTO KKR (BridgID,Remarks,Status) SELECT DISTINCT...
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/ -
Reply To: Arithmetic overflow error converting expression to data type smallint. The state
This is one of the easiest errors to diagnose.
Your code, which we cannot see, is trying to assign a value to a variable or a column that is defined as...
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/ -
Reply To: Login Failed. The login is from an untrusted domain and error 18452
You have DomainA, and DomainB, and there is a trust between them.
Your server is DomainB\MyServer.
Your login is DomainA\MyLogin
On server DomainB\MyServer, add the login DomainA\MyLogin to the server.
If it works, you...
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/ -
Reply To: Are the posted questions getting worse?
Anyone ever hear this one?
One of our groups screwed up the perms on the server drives, and here is what they said.
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/ -
Reply To: misleading blocking
vsamantha35 wrote:I am already using it but not helpful in my case it is giving only the current sql stmt.
Ok, one of the parameters is to capture the output to...
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/ -
Reply To: sql2012 equivalant
Calculate a larger time portion, like seconds, minutes, or hours, and then multiply to get milliseconds????
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/ -
Reply To: PIVOT, is there a better way to do this?
You may want to read these articles
https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-converting-rows-to-columns-1
https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-2-dynamic-cross-tabs
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/ -
Reply To: misleading blocking
I would download and install sp_whoisactive
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/ -
Reply To: Need to do a mass update - taking days
Create a view that anonymizes the names in a select of the Member table.
BCP out the view.
Empty the Member table.
BCP into the Member table.
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/ -
Reply To: Best way to combine records across databases
JuniperJun wrote:Data which is distributed over multiple databases needs to be gathered and then queried/filtered.
Are these databases on the same instance, or different instances or servers?
JuniperJun wrote:Currenttly a temporary table...
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/ -
Reply To: Best way to combine records across databases
JuniperJun wrote:Data which is distributed over multiple databases needs to be gathered and then queried/filtered.
Are these databases on the same instance, or different instances or servers?
JuniperJun wrote:Currenttly a temporary table...
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/ -
Reply To: Are the posted questions getting worse?
Grant Fritchey wrote:As emphatically strong a suggestion as I can make...
If you get the opportunity to take the all-day class on SQL Server 2022 put on by Bob Ward of Microsoft,...
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/ -
Reply To: Are the posted questions getting worse?
Jeff Moden wrote:Brandie Tarvin wrote:Talking about ChatGPT, has anyone seen this one yet? https://www.cnn.com/2023/02/08/tech/google-ai-bard-demo-error/index.html
<headdesk>
Yes... and they're making an big deal about it. ChatGPT is constantly providing incorrect answers about code and people...
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/
Viewing 15 posts - 226 through 240 (of 2,356 total)