Viewing 15 posts - 211 through 225 (of 1,496 total)
post to get over display bug
September 7, 2023 at 8:30 pm
The following comment from https://techcommunity.microsoft.com/t5/sql-server-blog/update-hotfixes-released-for-odbc-and-ole-db-drivers-for-sql/ba-p/3848484 might help.
DavidEngelMS
Microsoft
Aug 10 2023 04:58 PM
@james Auman
This answer has some subtleties, so bear with me.
...
There is an additional scenario I'd like to describe for SQL Server...
September 7, 2023 at 8:28 pm
I use the following to determine if log backups are worth it on instances with sporadically used DBs. Full and differential backups always get done on the schedule. This works...
September 6, 2023 at 5:59 pm
This might also be worth looking at:
https://blog.sqlauthority.com/2019/09/16/sql-server-enable-lock-pages-in-memory-lpim/
August 31, 2023 at 7:30 pm
Ideas?
Stop using maintenance plans - they have too many 'features'.
Try:
or:
https://www.minionware.net/products/backup/
August 28, 2023 at 7:20 pm
SQL Server CXPACKET Wait (sqlskills.com)
What is causing waittype CXSYNC_PORT and what to do about it? - Microsoft Q&A
August 20, 2023 at 10:27 am
You still have a typo in your test data in #t1! I am going to assume outtime on 2023-06-06 is 2023-06-06 23:38:44 and not 2023-06-05 23:38:44.
The following works with your...
August 12, 2023 at 12:35 pm
Bing gave me this:
Capture Linked server queries using SQL Extended Events - Stack Overflow
August 8, 2023 at 6:38 pm
As your latest data seems to have no missing times, try something like:
WITH DateList
AS
(
SELECT T.EmployeeId, X.PunchTime
...
August 8, 2023 at 2:25 pm
Are you sure this is a table and not a view? A table like this is poor design.
With the given data, just double the number of rows, with CROSS APPLY,...
August 8, 2023 at 1:19 pm
>>/* *** Test Data - which, if you want answers, you will provide in future */
August 8, 2023 at 11:35 am
I would speak to your network people. It smells like DNS and/or Kerberos.
ps Also, double check you have no SQL Server alias on you application servers.
August 8, 2023 at 10:20 am
With:
/* *** Test Data - which, if you want answers, you will provide in future */
SET ANSI_NULLS, QUOTED_IDENTIFIER, ANSI_PADDING ON;
GO
CREATE TABLE #t
(
EmployeeId...
August 8, 2023 at 9:54 am
I think Azure SQL DB allows External Tables but am unsure if that will get you as far as AWS.
It might be better to do the queries directly from the...
August 8, 2023 at 7:01 am
Viewing 15 posts - 211 through 225 (of 1,496 total)