Forum Replies Created
Viewing 15 posts - 1,891 through 1,905 (of 59,066 total)
-
Reply To: Need to do a mass update - taking days
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...
-
Reply To: help on extended event session
vsamantha35 wrote: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...
-
Reply To: What is ChatGPT – Is it the rise of the Skynet era?
Heh... not exactly SkyNet yet but, first drones and now this... and, guess what? It doesn't have to eat or pee. 😀
-
Reply To: What is ChatGPT – Is it the rise of the Skynet era?
Jonathan AC Roberts wrote: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...
-
Reply To: options for querying external data sources from SQL Server
pietlinden wrote: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...
-
Reply To: Need to do a mass update - taking days
- Please provide the complete CREATE TABLE statement for the dbo.Member table. This must include all constraints, keys, indexes, and FKs that may be pointed at the table for the...
-
Reply To: options for querying external data sources from SQL Server
pietlinden wrote:(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...
-
Reply To: What is ChatGPT – Is it the rise of the Skynet era?
Daniel Calbimonte wrote: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...
-
Reply To: What is ChatGPT – Is it the rise of the Skynet era?
mpaliev wrote: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...
-
Reply To: Hidden Formatting Troubles with STR() (SQL Spackle)
David Dubois wrote: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...
-
Reply To: DBCC CHECKDB and Backup Database
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...
-
Reply To: DBCC CHECKDB and Backup Database
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...
-
Reply To: Trying to get results back from 12 month ago thru 18 months ago from todays date
And thank you for the kind feedback!
Viewing 15 posts - 1,891 through 1,905 (of 59,066 total)