Viewing 15 posts - 3,556 through 3,570 (of 39,726 total)
Rebooted old node and tried again after failover? I assume this is shared storage clustering, so the same master.mdf was scanned with dbcc?
If so, I'd fail back and try again....
August 4, 2019 at 5:12 pm
Interesting discussion. I'm a fan of unit testing for a few reasons, but not "over testing". Test what you are working on, which might be alter the test.
Here's what I...
August 4, 2019 at 5:10 pm
That's an interesting idea. Might be worth scanning those, though I'd expect you get some alerts when you apply patches. I haven't heard issues with SQL Server binaries, but I'd...
August 4, 2019 at 4:41 pm
If someone is loading 27k rows into a dropdown, it can work for search/typing, but the render time might be high.
August 2, 2019 at 8:54 pm
Any activity for the database should change the timestamp. DBCC does create a snapshot, which I'm guessing marks some sort of item in the file.
August 2, 2019 at 8:49 pm
For others, use OUTPUT clause - https://docs.microsoft.com/en-us/sql/t-sql/queries/output-clause-transact-sql?view=sql-server-2017
August 2, 2019 at 8:49 pm
Use a CTE to get the cartesian of unique employees, when left join.
August 2, 2019 at 8:47 pm
I can't comment on this, but it seems like a file level filter driver, similar to what AV does. Those are not compatible with SQL Server and cause issues, especially...
August 2, 2019 at 8:46 pm
There are some tools like DQS, but I think they are fairly similar. There is also MDS (Master DAta Services), which could help. What are you looking for help with?
What...
August 2, 2019 at 8:43 pm
Links should be fixed here.
August 2, 2019 at 8:38 pm
Closing. Read answers here: https://www.sqlservercentral.com/forums/topic/convert-rows-into-columns-10
August 2, 2019 at 8:36 pm
Nice set of uses and thanks for responding. I was hoping that more people would comment, but I suspect many people don't use them or know about them. Likely an...
August 2, 2019 at 8:25 pm
I'm sure you'll do great. Looking forward to hearing how it goes.
August 2, 2019 at 8:19 pm
We use the tinymce plugin for editing. This allows rich editing. Apparently, something on your system is blocking this.
August 2, 2019 at 3:23 am
Viewing 15 posts - 3,556 through 3,570 (of 39,726 total)