Forum Replies Created
Viewing 15 posts - 331 through 345 (of 22,224 total)
-
Reply To: GitHub Copilot - Our Best Ally for T-SQL
Ed B wrote:G Peterson wrote:I cannot find the article referenced: "Writing SQL Server code with AI using GitHub Copilot" that is supposed to discuss how to install CoPilot. After installing per GitHub...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Upgrade to SQL2019 from 2012 and everything is slow - what to look for?
Just so you know, the only people who will see this, and maybe provide some answers, are ones who already subscribe to this thread, or find it by accident. If...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: The Fake Speakers
This situation was quite the train wreck. First blush, I kind of felt bad for the organizers. I understand the struggle to get a diverse rost put together. Then, the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: AI Tools
Well, the first one is, I'm guessing, being worked on by someone, somewhere. I don't know of any though.
The second one, yeah, I can help. Redgate Software, my employer, is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: data security for a data warehouse
I'm a very firm believer in the least privilege principal. You should be barely have enough access to get the job done. However, you should have enough access to get...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Logging SQLExceptions
Oh, and I missed the formatting thing. Yeah, it does it. Just double click on the batch_text or whatever field and it will open a window like this one:
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Logging SQLExceptions
Jeff Moden wrote:Grant Fritchey wrote:Bedeencion40 wrote:Yeah, you can set up SQL Trace or Extended Events to catch those errors. It's like a net for those SQLExceptions. But in the long run, asking...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Review of DB Activity
So, probably, most of your scripts for looking at queries and query behavior use DMVs. Which were released in 2005. That means, those scripts won't work. If you want to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Logging SQLExceptions
Bedeencion40 wrote:Yeah, you can set up SQL Trace or Extended Events to catch those errors. It's like a net for those SQLExceptions. But in the long run, asking devs to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Large number of Memory Ring buffers
Presumably, that means a lot of Extended Events sessions outputing to the ring_buffers. Probably not the best way to go. Output to file is generally better. But, it does depend...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Suggestion on HA DR solution for transactional replication published database
Just piling on. I think @Ant-Green has nailed it. Availability Groups are where Microsoft has been investing all it's time and money. So if you're going to be building an...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Suggestion on HA DR solution for transactional replication published database
Just piling on. I think @Ant-Green has nailed it. Availability Groups are where Microsoft has been investing all it's time and money. So if you're going to be building an...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: SQL Server Windows NT - 64 bit" in Task Manager: CPU high
I'm confused. What is this in relation to?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: You Never Know
And very much still is.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Log shipping time_since_last_backup
Excellent! Thanks again. Glad you got it all figured out.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 331 through 345 (of 22,224 total)