Viewing 15 posts - 646 through 660 (of 747 total)
I considered submitting a request asking for a way to suppress the dark mode request.
I actually have to use DATEDIFF_BIG. The fact they couldn't be bothered to implement the corresponding...
April 22, 2021 at 5:19 pm
Note that Microsoft is preparing to switch, yet again, to a different feedback system.
Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year....
April 22, 2021 at 1:28 pm
That link leads you to KB5001090 - Cumulative Update 10 for SQL Server 2019 which has two links:
Microsoft Download Center: Download the latest cumulative update package for SQL Server 2019...
April 14, 2021 at 3:36 pm
Something like:
CASE WHEN A.currency = B.currency THEN A.value ELSE A.value * C.conversion_rate/100 END
Or, to simplify logic, if you have a self reference in the conversion table for...
April 14, 2021 at 3:25 pm
What do you mean "I wasn't able to log in"? What error message did you get?
What instance name did you use? For a default instance, you should have been able...
April 13, 2021 at 10:29 pm
tracks all the CUs & GDRs with links.
April 13, 2021 at 10:18 pm
Correct.
You will need to either delete rows with conflicting data (if you can get away with that... you might want to copy the data to an error table to review...
April 13, 2021 at 4:28 pm
https://www.sqlservercentral.com/forums/forum/sql-server-2017/sql-server-2017-development is probably more relevant... but close enough.
You can probably use something like
sum(CASE WHEN rt.ZoneFk = 3 THEN mbs.Count ELSE 0 END)
for the filtered TotalRecordCount.
Beat to...
April 9, 2021 at 4:04 pm
What have you done to debug it? Have you determined which call to the stored procedure is breaking? (i.e., what parameters?). You may have to use extended events or a...
April 8, 2021 at 10:22 pm
msdb, model, & tempdb can be moved through relatively normal means (though you have to restart SQL Server afterwards).
master requires modifying startup parameters and the registry... and maybe a prayer...
April 8, 2021 at 3:01 pm
Your odds might be better in an Oracle forum like Oracle Communities or orafaq than in a Microsoft SQL Server forum.
April 8, 2021 at 1:22 pm
Microsoft says you can, but recommends excluding most folders and file types associated with SQL Server: https://support.microsoft.com/en-us/topic/how-to-choose-antivirus-software-to-run-on-computers-that-are-running-sql-server-feda079b-3e24-186b-945a-3051f6f3a95b#:~:text=You%20can%20run%20antivirus%20software,is%20a%20cluster%2Daware%20version.&text=C%3A%5CWindows%5CCluster
... as well as the following on cluster servers:
Q:\ (Quorum drive)
C:\Windows\Cluster
MSDTC directory in...
April 7, 2021 at 1:13 pm
Why the empty date shows '1900-01-01' and how to avoid?
Because that's what an empty string casts to (the equivalent of 0).
If you want NULL, use NULL instead of empty string.
What...
March 29, 2021 at 10:25 pm
What version/patch # is the server at?
What ODBC driver version is each client using? Do they have identical hardware (CPU, amount of RAM, speed of RAM, etc.)?
Are they pointing at...
March 24, 2021 at 7:44 pm
Ideally from the source/designer of the XML. Barring that, maybe Generate an Inline XSD Schema
Here's another link: Generate XSD from Sql query using FOR XML
March 24, 2021 at 2:40 pm
Viewing 15 posts - 646 through 660 (of 747 total)