Viewing 15 posts - 1 through 15 (of 21,963 total)
I uploaded your picture to ChatGPT 4 and asked it to: "Write a SQL Server create table (table name: XXXRE60P) and insert script for this, make sure you include...
April 11, 2024 at 2:59 pm
we need a script that generates your data & structure.
...and how do I do that? I don't mind taking the time, I just don't even know what step 1...
April 11, 2024 at 2:39 pm
Please create sample data in a consumable format using the {;} Code
button to include a script to create a TEMP table and insert data into that temp...
April 11, 2024 at 2:24 pm
And who is looking forward to (or looking at) a Solar Eclipse come April 8th?
Drove three hours to see it in the totality zone. Forecast was for partly cloudy,...
April 9, 2024 at 6:08 pm
Thanks everyone for the responses. We see just here that different people like different things for different reasons at different times. It's all cool and I'm pleased you embrace it....
April 9, 2024 at 12:51 pm
I've poked the team to see what's up and linked back to here.
I don't have a hotel booked either if that helps at all (and I know it...
March 26, 2024 at 4:46 pm
So I'm hoping maybe someone (coughStevecough) might be able to provide some info for me...
I'm going to be attending the Redgate Summit in Chicago, I want to get my...
March 26, 2024 at 3:35 pm
We are spoiled for choices. I don't think there's a wrong one as such.
There are ones that are better fits to you as an individual. For example, I went down...
March 25, 2024 at 1:28 pm
I am fortunate to have worked my entire career in organizations where admitting to and owning your mistakes is respected, and failing to do so gets you fired. My...
March 15, 2024 at 5:46 pm
Sounds really good! I have never used SQL Prompt for this purpose but used it for other, mostly code formatting and best practices suggestions purposes.
QUESTION: is SQL PROMPT similar...
March 14, 2024 at 1:02 pm
Thanks, Grant!
Good to hear from you. I have learned quite a few good things from your books and other presentations over the years.
Thanks! Happy to help where I can.
March 14, 2024 at 1:01 pm
Without seeing the queries or the plans, I'm just guessing.
Possible differences between using a table and a temp table that could result in performance issues are, of course, the indexes,...
March 11, 2024 at 3:32 pm
Without seeing the queries or the plans, I'm just guessing.
Possible differences between using a table and a temp table that could result in performance issues are, of course, the indexes,...
March 11, 2024 at 3:32 pm
It's not so much that you "feed" it, as Prompt is already looking at your data structures, so, yeah, that's what it does. It takes your data structures and uses...
March 11, 2024 at 3:03 pm
Great points. I wasn't even thinking about that at all. Happily, I haven't received so much as a finger wag for dropping the ball. I mean, Steve is going to...
March 11, 2024 at 1:58 pm
Viewing 15 posts - 1 through 15 (of 21,963 total)