Viewing 15 posts - 1,936 through 1,950 (of 22,202 total)
Hi,
ah I see something like this, but everywhere they presented that is new feature also for system dbs, so it looks like wasnt released .
thanks for info
I can't imagine...
February 19, 2020 at 1:19 pm
Shockingly, the man who hasn't even played with R for a year got this one wrong.
February 19, 2020 at 12:43 pm
You can. I'd suggest you read through the documentation for some of the how to. Don't bother with model (unless you're a unicorn and you're putting customization in model...
February 18, 2020 at 3:39 pm
Minimize the amount of index reorgs you do. Most of them, most of the time, are actually unnecessary. Instead, focus on getting the right page free space and let the...
February 18, 2020 at 1:36 pm
You can restore 2012 to 2016. It'll work fine. However, once it's moved to 2016, you can't backup and restore back to 2012. So, this is likely a permanent upgrade...
February 18, 2020 at 1:34 pm
First up, look to your wait statistics. If you're not seeing IO_LATCH* waits as your number one wait (and number two, three, four...), chances are extremely high that going to...
February 18, 2020 at 1:30 pm
Personally, I wouldn't do this from within SQL Server. Instead, I'd set up a PowerShell script to make all the connections. It can still save it all back to a...
February 18, 2020 at 1:28 pm
Like any other problem in the system, most of the time it's queries. I'd use either Query Store (set up per database) or Extended Events to capture query metrics. Identify...
February 18, 2020 at 1:27 pm
Mmmmm... Not digging that answer, but I'm not stupid enough to start an argument with Kendra.
February 18, 2020 at 12:44 pm
Thank you for your input. I heard that the multi-statement functions are not very efficient.
That doesn't even remotely cover just how horrific performance gets with these things. I would...
February 18, 2020 at 12:35 pm
If you lock it, no one can access it. That will stop the deadlocks. But then, the phone calls start "WHY CAN'T I GET MY DATA".
I'm with Mike. What is...
February 14, 2020 at 2:10 pm
Nope, nope, nope. That book is either wildly wrong, or you may have misread a section of it. A database only has to have two files, data & log. You...
February 14, 2020 at 2:04 pm
Well, your drive has 93.6gb free. Assuming you have auto-growth enabled on your files, you have room inside the database too. Take a look at sys.dm_db_file_space_usage to determine the...
February 14, 2020 at 2:01 pm
February 13, 2020 at 1:00 pm
Not going to lie, I was hoping more people got this wrong.
February 13, 2020 at 12:46 pm
Viewing 15 posts - 1,936 through 1,950 (of 22,202 total)