Viewing 15 posts - 1,021 through 1,035 (of 22,189 total)
I would argue that every table should have a clustered index unless serious testing suggests otherwise. SQL Server is optimized around storing and retreiving data from clustered indexes. Heaps just...
December 16, 2021 at 1:32 pm
Not your router. Azure, by default, locks down your databases. You cannot connect to them without specifically allowing identified IP addresses. So, it's youre IP address that you need to...
December 15, 2021 at 3:37 pm
Hey Rod. First guess, have you poked a hole in the firewall so your account can get to the Azure database? That's the most common issue. You should be able...
December 15, 2021 at 1:10 pm
I'm with Ken. Temporal tables is probably the better solution. However, you also can look at setting up an UPDATE trigger as shown at the link. Be cautious and...
December 15, 2021 at 1:06 pm
Hi everyone
Thanks for the replies. If I include the execution plan then does the query come with it automatically or do I have to add the query separately?
Thank you
The...
December 14, 2021 at 5:26 pm
Also, a Common Table Expression, CTE, is not a TABLE, but an EXPRESSION. That label causes so many problems for so many people. You're not defining a temporary storage space....
December 14, 2021 at 1:56 pm
I'm with everyone else. To help you, we need to see code & structures. However, a couple of points.
If you're seeing 3000% usage, I know two things. First, you're using...
December 14, 2021 at 1:52 pm
When a backup starts, a marker is placed in the transaction log. Any transactions that are completed when the backup is done, are then backed up. Any transactions that are...
December 13, 2021 at 2:50 pm
Grant,
Didn't you say that you were coming out with the 4th Edition sometime in the first half of next year (2022)?
No plans to update the execution plans book at...
December 13, 2021 at 1:39 pm
Excellent reviews, I will gladly read all editions
Nah, just the 3rd edition. It's updated & cleaned up. The others are out of date, wrong, or unclear.
December 13, 2021 at 1:37 pm
wrote:Thanks for sharing, I am very impressed with your post.
Smell that? {sniff}... smells like a prelude to SPAM.
'
Yeah. Fixed it.
December 13, 2021 at 1:31 pm
You could also define the SELECT statement of the view so that it masks the data actively as the query runs. Just and idea.
December 3, 2021 at 3:57 pm
That's not a temporary table (I mean, it's temporary and it's a table, but it's not what SQL Server defines as a temporary table). That is a table variable. Table...
December 3, 2021 at 3:56 pm
Sounds like you're looking at how GROUP BY works. Combine that with MAX() and COUNT() and you should be good to go. I'm guessing the column you...
December 3, 2021 at 3:51 pm
These counters, by themselves, won't necessarily show a bottleneck. You need to capture the metrics over time so you have comparison points (x% yesterday, y% today, look, it's getting worse)....
December 3, 2021 at 3:46 pm
Viewing 15 posts - 1,021 through 1,035 (of 22,189 total)