Viewing 15 posts - 1,756 through 1,770 (of 2,355 total)
The data is bad.
There are probably records with an empty string. Without knowing what the code is trying to do, that is a guess.
Can you post the...
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/
June 16, 2016 at 2:19 pm
What is the structure of the view?
That may be where the issue is coming from.
It's probably doing something like this:
DECLARE @s-2 varchar(100) = '12345'
SELECT LEFT(@s, CHARINDEX('x', @s-2)...
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/
June 16, 2016 at 12:37 pm
Tknapik (6/16/2016)
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/
June 16, 2016 at 11:43 am
Are you stuck with the maintenance plans?
"IndexOptimize" is a procedure from Ola Hallengren. https://ola.hallengren.com/
It appears that you, or someone, has implemented this or part of it.
The main problems...
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/
June 10, 2016 at 8:54 am
This type of situation can be difficult to correct. There is no good answer. You are likely going to meet some serious resistance regardless of what plan you...
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/
June 10, 2016 at 7:35 am
After the job sets the recovery model, does it call sp_start_job?
If so, that's your problem.
If a job step starts another job using sp_start_job, it will immediately move on...
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/
June 9, 2016 at 1:36 pm
Why?
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/
June 9, 2016 at 12:31 pm
SilverBack (6/9/2016)
So @StartD needs to be a column A in a Table and @EndD needs to be Column B in the...
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/
June 9, 2016 at 12:02 pm
This is a slippery slope. What is the reasoning behind each department wanting their own server?
If they feel that performance would be better, then cost must not...
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/
June 9, 2016 at 11:49 am
Again, to reiterate what Lynn is saying, please explain what you are trying to do without providing code.
The syntax you provided makes no sense. We cannot understand...
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/
June 9, 2016 at 11:32 am
I am. My environment consists of everything from SQL 2005 to SQL 2014.
It works just fine.
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/
June 7, 2016 at 12:21 pm
Also, this script is not from Brent Ozar, it's from Ola Hallengren.
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/
June 7, 2016 at 10:59 am
Sounds like quite a few folks on this thread need to submit sessions for the Wanna be a DBA track at the Pittsburgh SQL Saturday.
I already volunteered Ed.
And, Ray,...
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/
June 7, 2016 at 9:01 am
Ray K (6/6/2016)
Michael L John (6/6/2016)
We geared this toward students(we host it...
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/
June 6, 2016 at 12:25 pm
For the Pittsburgh SQL Saturday, one of the most popular tracks is the "So you wanna be a DBA"?
We geared this toward students(we host it at a tech school) and...
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/
June 6, 2016 at 11:39 am
Viewing 15 posts - 1,756 through 1,770 (of 2,355 total)