Viewing 15 posts - 1,891 through 1,905 (of 59,066 total)
Thank you for the DDL. I'll take a look at that and your code tonight after work tonight.
Just to double check after a quick scan... I see no Clustered...
February 14, 2023 at 3:05 pm
Dealing with a super huge table that is partially partitioned can be a challenging task for many database administrators and developers. However, with the right approach and tools,...
February 14, 2023 at 3:02 pm
Want to know whether it is randam insert guid is causing the problem
If it is and you're concerned about the page splits (I usually am because they can cause...
February 14, 2023 at 2:56 pm
Heh... not exactly SkyNet yet but, first drones and now this... and, guess what? It doesn't have to eat or pee. 😀
February 14, 2023 at 2:30 am
Here is my attempt:
...{snip}...
That worked and is reasonably efficient.
One of my other issues with these 'bots is that they don't provide many choices. When I ask a question in...
February 14, 2023 at 12:28 am
oh, right. That's the part I was going to try to avoid: SSIS.
Totally understood and agreed but, YOU asked! 😀 😀 😀
First, and to set the record straight, the...
February 13, 2023 at 11:59 pm
February 13, 2023 at 11:20 pm
(Kinda wish MSFT would do something like the PowerBI import/link kind of UI for SQL Server... but that's wishful thinking on my part, I'm sure!)
Most people would tell you...
February 13, 2023 at 10:03 pm
It is not smart enough yet, but compared with Cortana, Siri, and Alexa, this is by far the smartest robot.
While I agree with that, the comparison that just came...
February 13, 2023 at 4:50 pm
But I wonder what happens what it get access to the internet ...
Probably the same thing as what has happened to humans (which I already have some good proof...
February 13, 2023 at 4:12 pm
February 13, 2023 at 12:54 am
Fun fact: Your article reveals an error in how SQL Server casts numeric to float.
STR(.922337203685477580,19,19) should end in 776, but it ends with 777.
Further investigation shows that cast(.922337203685477580 to...
February 12, 2023 at 11:58 pm
BTW... if you want a super early warning for something that has gone wrong with pages being used in a database, consider setting up a job that checks the suspect_pages...
February 12, 2023 at 9:06 pm
Ok.. I've checked the code you provided for both the DBCC CHECKDB and the Backups. There are some serious opportunities for improvement in both...
With regards to the code provided for...
February 12, 2023 at 8:21 pm
And thank you for the kind feedback!
February 12, 2023 at 1:38 am
Viewing 15 posts - 1,891 through 1,905 (of 59,066 total)