Viewing 15 posts - 2,026 through 2,040 (of 59,065 total)
Can you consider Columnstore index , non clustered, if you need many columns & read is huge in the DB query.
Can we have full plan or highly used area...
January 30, 2023 at 4:51 am
Great article. PLE reminds me of the "tree falling" riddle...
"If a tree falls in the forest (PLE crashes and starts coming back up) and no one was there to hear...
January 30, 2023 at 4:38 am
SGAB, I had high hopes for the new GENERATE_SERIES() function in 2022, which I finally took the time to download the Developers Edition for and install. Things were looking promising...
January 30, 2023 at 4:26 am
p.s. If you want to see a presentation on all this, here's one that talks a lot about Random GUIDs just because they're the "poster child" for fragmentation. It shows...
January 30, 2023 at 3:29 am
Or instead of reorg, will it be faster if I just rebuild index instead?
The answer to that question is a resounding OMG YES!!!! Even if you're in the Full...
January 30, 2023 at 3:23 am
It sounds to me like the database was defined that large to begin with. And, no... SQL Server doesn't reduce the file size when data is deleted, either.
January 30, 2023 at 2:21 am
And do remember that the resulting number is actually huge coming in at E33 and isn't just 3.97. Because of that, I'm seriously doubting this whole formula... especially since it...
January 29, 2023 at 5:40 pm
Ran a test after enabling TF 692 and continued to see blocking by the select against sys.dm_db_index_physical_stats, unfortunately.
Ooooo lordy. My apologies for missing your reply to your now 3...
January 28, 2023 at 4:22 pm
Not being a math genius by any means, I'm still deeply interested in what the formula solves for?
January 28, 2023 at 12:39 am
NM... Jonathan pulled it off mathematically. (Nicely done, Jonathan!!!)
I'd still like to know what question the math resolves. Thanks.
p.s. I know all the gazintas that Jonathan used to solve this...
January 27, 2023 at 11:02 pm
I found the same error message in the SQL Error log on 3 dozen different SQL 2019 Standard instances. The message was:
BACKUP failed to complete the command BACKUP LOG...
January 27, 2023 at 7:22 pm
Hello!
When we failover one node from another, does the roles from the node failover to another node too?
Thanks
Test it. Even if someone says "yeah", you MUST test it!
I'd also...
January 27, 2023 at 7:14 pm
what does the backup log init do?
It compels me to point out that folks should read the documentation. 😀 Here's the link...
https://learn.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?#-noinit--init-
January 27, 2023 at 7:11 pm
Since the interviewer specifically stated "what if the developer does any typo error", I'm thinking he was looking for the "mapping table" that Phil spoke of in his post.
That would...
January 27, 2023 at 4:46 pm
Yeah... there's the other part of a 2 part SPAM thread.
January 24, 2023 at 8:14 pm
Viewing 15 posts - 2,026 through 2,040 (of 59,065 total)