Viewing 15 posts - 526 through 540 (of 2,356 total)
Just as a straw poll, what if we had threads older than 1 year - latest post date <= dateadd (year, -1, getdate) - closed when someone tries to...
February 9, 2022 at 8:51 pm
I think the only way you are going to get an actual representation of how long it takes would be to try it.
Can you make a copy of your database(s)...
February 9, 2022 at 8:41 pm
(100+ gb, over 1,000 tables)
100 GB is not large.
When doing data masking for an entire database, do you typically just focus on a small percentage of columns...
February 8, 2022 at 6:30 pm
To understand better, you have an ERP system that connects to SQL Server. Users access this by RDP'ing into a different server. You have purchased CAL's as your licensing for...
February 8, 2022 at 6:17 pm
Using SQL auth
Blue question mark is 'part' of the problem, but not the only (biggest) problem. Though WMI is something I will look at.
If you were using Windows authentication,...
February 8, 2022 at 5:37 pm
What do you think about schema changes history? How long does it keep the history?
How long does what keep the history?
If you are talking about the report built-in to...
February 7, 2022 at 9:17 pm
As an experiment, I'm assuming you are using Windows Auth to connect. Try SQL authentication and see if the issue goes away.
February 7, 2022 at 2:28 pm
In synchronous mode - data needs to be hardened on the secondary before it can be committed on the primary. That could have a significant impact on the performance...
February 7, 2022 at 2:00 pm
Use RUNAS
RUNAS /savecred /user:YourDomain\YourUsername "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe"
You can create a .bat file, put a shortcut on your desktop, and use that to connect.
February 7, 2022 at 1:49 pm
The users have PBI desktop and we deploy to PBI on premise. The spreadsheet sits in teams.
What have you tried?
Here, the typical manner is that spreadsheets are stored in...
February 4, 2022 at 7:08 pm
A few places here in Denver I'd never work for, and that have constant open positions.
Same here in Pittsburgh. The headhunters call weekly for open positions at the same...
February 4, 2022 at 6:25 pm
We had significant layoffs, and the remaining employees took 20% pay cuts and a loss of company match for the 401k's at the start of Covid. That was all given...
February 4, 2022 at 6:09 pm
How is the read-only secondary being used?
Is read only routing configured, and the applications that have their connection strings set to use the secondary actively running select queries against this...
February 4, 2022 at 2:23 pm
I can see only when the indexes got created. However, I am looking is there a way to find who created the indexes?
No. You could create and add a...
February 3, 2022 at 10:35 pm
Ahhhh. SQL Injection at it's finest!
Take a look here:
February 3, 2022 at 4:40 pm
Viewing 15 posts - 526 through 540 (of 2,356 total)