Viewing 15 posts - 3,136 through 3,150 (of 22,214 total)
Oh yes. Tons to talk about here.
First up, get your database code into source control just the same as your application code. This gives you the ability to...
June 27, 2018 at 4:37 am
June 26, 2018 at 8:49 am
You can do a lot of development locally and then deploy to the cloud.
However, cross database queries are horrifyingly slow and difficult to maintain within Azure SQL Database....
June 26, 2018 at 5:16 am
It says right at the top that the process with an id equal to this value process694076108 was chosen as a victim. You can then find the input buffers for...
June 26, 2018 at 5:11 am
100% agreement with Anthony. Why write your own script for this? Ola Hallengren's scripts or the Minion Backup scripts will do the work for you. Why reinvent the wheel when...
June 26, 2018 at 5:04 am
June 25, 2018 at 1:03 pm
June 25, 2018 at 12:26 pm
Kurt Wimberger - Wednesday, June 20, 2018 7:18 AMThanks Grant. Very much appreciate the time you all devote to helping others.Kurt
Thanks... although...
June 20, 2018 at 7:52 am
June 20, 2018 at 7:50 am
Besides me and Hugo, who will be at SQLGrillen on Friday?
Oh, and tune into SQL in the City at around 2:20PM. I'm going to finish the execution plans...
June 20, 2018 at 6:20 am
June 20, 2018 at 1:31 am
If you're getting deadlocks from the process, I'd double check the query tuning first of all, the indexing next, and the calls made by the queries. If it's the same...
June 19, 2018 at 6:40 am
They're both defined locally. The Recovery Time Objective is how long it takes to recover your database. You have to test it. Recover just a database. Recover a database plus...
June 19, 2018 at 4:45 am
I am absolutely not seeing similar behavior. Uninstall and reinstall maybe?
June 19, 2018 at 4:41 am
I'm with Jeff, first thought, it depends.
However, I'll go a little farther. With low levels of data modification, even if the computed columns are doing a lot of work,...
June 19, 2018 at 2:33 am
Viewing 15 posts - 3,136 through 3,150 (of 22,214 total)