Viewing 15 posts - 1,141 through 1,155 (of 2,356 total)
Unless I am completely missing something, this is inside a loop that sets the values of a series of date variables that are never used in the query. For every...
May 23, 2019 at 7:43 pm
You also need to configure Read Only Routing if you want you read-only connections to be automatically routed to the secondary.
This article explains it very well.
https://www.rdx.com/blog/configuring-read-only-routing-always-availability-group
May 23, 2019 at 3:50 pm
"A person would do an explicit conversion because they are just plain lazy or really do not understand how these things work." Did you mean to say implicit conversion? ...
May 21, 2019 at 2:52 pm
SSMS has a debugger built in, although running it remotely requires some configuration steps.
Not sure on how to see the space in memory a variable is taking up, I would...
May 20, 2019 at 6:09 pm
There are a few possibilities.
May 20, 2019 at 2:45 pm
What is the structure of the table you are importing this data into?
It appears that the column length of this table is too small.
And, are you really using SQL 7...
May 17, 2019 at 8:00 pm
Working in an old-time neighborhood hardware store!
May 17, 2019 at 1:41 pm
Pittsburgh SQL Saturday is now official
May 13, 2019 at 7:48 pm
While we are on the subject of 4 part names and consistency across environments, it reminds me of a DBA who I had the pleasure(!) of following three separate times.
First...
May 13, 2019 at 3:36 pm
So I attended the PASS High Availability webinar last week on "Your AG might not be as "available" as you think" and it was pretty interesting. But one odd...
May 13, 2019 at 2:49 pm
Pittsburgh SQL Saturday should be appearing on the PASS website today? It's October 5th. Same place.
May 10, 2019 at 2:04 pm
How are they connecting to the secondary? By directly connecting to the secondary server, or by connecting to the listener and adding "ApplicationIntent=ReadOnly" to the connect strings?
Do you have read-only...
May 8, 2019 at 4:09 pm
I would start with this site, and the Stairway series.
https://www.sqlservercentral.com/stairways
As you go through these articles, they should create many questions that can be used as a learning opportunity.
April 30, 2019 at 3:07 pm
Viewing 15 posts - 1,141 through 1,155 (of 2,356 total)