Viewing 15 posts - 1 through 15 (of 8,699 total)
Can you share some more details, don't like guesswork?
😎
April 18, 2024 at 4:31 pm
Quick question, is the application's query interface a predefined API or dynamically constructed SQL?
😎
Capturing the queries on the server comes with a considerable overhead, I suggest you do an impact...
April 18, 2024 at 3:53 pm
What is the problem you are trying to solve?
😎
February 19, 2024 at 4:49 pm
First of all, establish what the issues are and then target those issues! Without a proper RCA (Root Cause Analysis), I will not provide any guesswork on a possible solution.
😎
Another...
February 19, 2024 at 4:45 pm
Piling on Jeff's solid advice, the term "throttle" can have different meanings! My perception is that the requirements are not clear enough!
😎
Far too often, throttling is thought of as a...
February 19, 2024 at 4:14 pm
Quick Question, do you have clear RPO and RTO?
😎
Without those, designing a DR solution will be a futile exercise!
February 19, 2024 at 2:41 pm
If performance is your goal: just one huge warning: "Which Version of SQL Server Should You Use?"
Johan has a good point, just as Orwell stated, not all "versions"...
February 19, 2024 at 2:32 pm
First thought, check if security and permissions for the Agents Service account are identical on all instances.
😎
February 18, 2024 at 2:51 pm
A solid advice from Lovell as usual!
😎
I have used the backup method many times with only a few minutes of downtime, even on relatively slow connections. Suggest that you script...
February 18, 2024 at 2:39 pm
Quick question, what are the recovery mode and backup details?
😎
February 18, 2024 at 2:12 pm
Recursion is notoriously slow for iteration. Maybe use a "standard" tally table instead:
;WITH
cte_tally10 AS (
SELECT * FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS numbers(number)
),
cte_tally100 AS (
...
February 18, 2024 at 2:07 pm
Here is a very efficient way of doing this.
😎
Comments in the code.
USE TEEST;
-----------------------------------------------------------------------------------------
-- WHEN POSTING CODE ONLINE, I MAKE CERTAIN THAT IT POINTS TO A NON-EXISTING DATABASE...
February 18, 2024 at 12:54 pm
A quick question, is this the format of the data you must work with or can you correct the data structure? Adding columns for each month is not a sustainable...
February 16, 2024 at 5:34 pm
Nice one Steve!
😎
I like short questions, with short answers and even shorter query outcome 😉
February 14, 2024 at 2:10 pm
Just adding my 2cents;
February 14, 2024 at 2:05 pm
Viewing 15 posts - 1 through 15 (of 8,699 total)