Viewing 15 posts - 511 through 525 (of 22,189 total)
Just that, as with anything, I'm sure there's a tipping point. "3 extended properties, no big deal, 300, 3000000, something, big deal". I honestly don't know how many zeroes you...
March 1, 2023 at 6:35 pm
I don't understand why you would have indexes (apart from maybe a clustered one) on a table with only a few rows?
Total agreement, but this one that Sam will...
March 1, 2023 at 5:12 pm
I assume there's a point at which extended properties will cause an issue, but I'm not aware of anyone that has hit it using the things in a standard way....
March 1, 2023 at 1:20 pm
Everything Jeff said.
We've covered this in multiple posts. Capture query metrics, I'd go with batches & procedure calls, not individual statements at this point. Capture deadlocks (Extended Events, don't listen...
March 1, 2023 at 12:59 pm
It can, yes. Ghost cleanup can also block you.
The vendor can't leave this with you. You can't change the code, and the code needs to be changed. You also can't,...
February 28, 2023 at 4:20 pm
Yes. Its a small table. Question is , when there is 0 rows in the table, and when we say SELECT * FROM <Tname> , why SQL Server is...
February 28, 2023 at 3:43 pm
So, yeah, about what I expected. A clustered index scan and nothing else.
So, your #1 problem query is SELECT * from a table with two rows in it?
Dude, go home....
February 28, 2023 at 3:24 pm
For now, rebuilding all the indexes on the tables every 1 hour is giving some relief. query returns in few milli secs.
but... why? Two rows or sometimes empty? Honestly,...
February 28, 2023 at 3:17 pm
I'm afraid I don't understand. What's that? It's a picture of some data from a query running SELECT * returning 2 rows. I'm confused.
February 28, 2023 at 2:39 pm
What do the execution plans look like? What do the queries look like. There's not a 'run faster' switch that can be flipped here. Without some understanding of the behaviors...
February 28, 2023 at 1:13 pm
If a FK or a trigger is involved i hope , there should be some kindly of error thrown?.
Not if it's just processing all the validations, scanning tables looking...
February 28, 2023 at 12:58 pm
I read through the interview questions at the link, and yeah, I'd say those are somewhat tough questions. I've been doing this for 30+ years. I've written a few books....
February 24, 2023 at 12:05 pm
Are any thredizens going to be in Atlanta for SQL Saturday BI Edition???
Nope. But I am in Austin for SQL Saturday here.
February 24, 2023 at 2:59 am
Just wanted to say thanks on this again, Grant. Work has given me the green light for SQLBits; it's a bit (no pun intended) last minute though so all...
February 22, 2023 at 6:47 pm
Also, salaries are very regional. A DBA in Tulsa probably isn't paid what a DBA in NYC is paid (honestly, they should be, but they aren't). This isn't specific to...
February 22, 2023 at 1:46 pm
Viewing 15 posts - 511 through 525 (of 22,189 total)