Viewing 15 posts - 856 through 870 (of 59,060 total)
onsider an employees table:
employee_id (int) employee_name (varchar) department (varchar) joining_date (date) salary (decimal) Highest Earner by Department: Find the employee with the highest salary in each department.
Average Salary by...
December 12, 2023 at 4:31 pm
I just need to work out how to do this all dynamically, as the column Names and amount of columns can vary in the JSON.
Then you...
December 12, 2023 at 4:20 pm
Ladies and gentlemen, the OP has left the building! 😀
December 11, 2023 at 6:23 pm
Jeff
Do you know if others would also use the term "Skip Join" so if I googled on SKIP JOIN I'd get info about this or does this not have...
December 8, 2023 at 8:15 pm
That kind of code is frequently generated by the "query designer" in SSMS under {Query}{Design Query in Editor} menu selection in SSMS. And, as you found out, it DOES work.
I've...
December 7, 2023 at 7:06 am
Users told me that they can not connect and after some time database work fine for next few minutes. Best solution is restart PC ... but next month the...
December 7, 2023 at 6:41 am
Just to add to the previous comments. I upgraded a system from SQL 2012 to SQL 2019 RDS on AWS. One of the most impactful actions after identifying slow-running...
December 6, 2023 at 3:48 am
very very disappointed at this unholy situation. How is it possible that Jeff is wrong!!!!
Every once in a...
December 5, 2023 at 11:35 pm
Does the 6% performance reduction pose a real operational problem at the system level?
At the micro scale, small performance reductions may not matter to the individual process incurring it,...
December 5, 2023 at 11:31 pm
This appears to be a classic "Next_ID" table and I find it difficult to understand why anyone would be using such a thing in this day and age, especially with...
December 5, 2023 at 12:38 am
i used this code:
EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT * FROM dbo.CustomerInformation " queryout C:\Data\Objects.txt -t"|" -c -T ' and it is not working
What is your definition of "Not Working" here?
December 5, 2023 at 12:11 am
very very disappointed at this unholy situation. How is it possible that Jeff is wrong!!!!
Heh... and freely admitted it....
December 4, 2023 at 11:41 pm
I have learned something, so I hope that I will do better in the future.
Awesome. Thanks for the feedback.
December 4, 2023 at 11:39 pm
yes, I made a mistake when I copied the value. It's exactly what I need, thank you!
The next question is, do you now understand how to do such a...
December 4, 2023 at 6:23 pm
It has nothing to do with xp_CmdShell. There's something wrong with the RESTORE command or the file wasn't found by the xp_CmdShell command.
If it were me, I'd modify the job...
December 4, 2023 at 3:03 pm
Viewing 15 posts - 856 through 870 (of 59,060 total)