Viewing 15 posts - 1,141 through 1,155 (of 2,356 total)
Wow. Just Wow.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 23, 2019 at 7:45 pm
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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? ...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 20, 2019 at 6:09 pm
There are a few possibilities.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 17, 2019 at 8:00 pm
Working in an old-time neighborhood hardware store!
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 17, 2019 at 1:41 pm
Pittsburgh SQL Saturday is now official
https://www.sqlsaturday.com/907/EventHome.aspx
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 13, 2019 at 2:49 pm
Pittsburgh SQL Saturday should be appearing on the PASS website today? It's October 5th. Same place.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 8, 2019 at 4:09 pm
I've done something rather rare but well deserved for me... I'm finally going to use some (a lot, actually) very well deserved "stay-cation" time...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 7, 2019 at 4:08 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.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 30, 2019 at 3:07 pm
Viewing 15 posts - 1,141 through 1,155 (of 2,356 total)