Viewing 15 posts - 1,741 through 1,755 (of 2,355 total)
Chitown (7/5/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/
July 5, 2016 at 3:22 pm
Can anyone in the U.K. (or is it K minus U these days?) make a recommendation for technical training? We have a colleague in London who's looking at New...
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/
July 5, 2016 at 9:30 am
dclemens (7/5/2016)
I'd like...
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/
July 5, 2016 at 9:23 am
It looks like the existing SQL service account, or the account that is doing the installation, does not have enough rights to the files and folders.
Also, run the administrator as...
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 30, 2016 at 1:57 pm
The Import \ Export wizard only looks at the first 50 rows for the transformations or previews.
If you think about it, attempting to analyze an entire data set to cover...
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 30, 2016 at 1:53 pm
Ed Wagner (6/29/2016)
djj (6/29/2016)
jasona.work (6/29/2016)
Everyone who could, took time off, those that are left (me!) work on things...
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 29, 2016 at 2:04 pm
Do you have a third part backup running in addition to the native SQL backups?
There's where the weird filenames are coming from.
Try running this query and see if it shows...
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 23, 2016 at 1:19 pm
Create a job that runs at startup of SQL Server.
Put the following, after changing the values specific to you, in the job.
DECLARE @ServerName AS NVARCHAR(200) = 'Possible Failover of '...
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 22, 2016 at 12:00 pm
SharePoint is not the most efficient application. The results from sp_blitz are normal.
Freeing the cache is not going to do much.
Have you captured the file growths 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 22, 2016 at 5:08 am
Not unusual for Sharepoint.
https://technet.microsoft.com/en-us/library/ff945791.aspx
There are a lot more, google it!
Did you set maxdop = 1?
Have you turned on trace flag T1117 and T1118?
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 21, 2016 at 9:34 am
1. Create the table
2. Use BCP and specify the field terminator as the "|||"
A possible command, fill in the blanks to fit your environment
BCP Database.Schema.Table IN C:\bcp\ImportThis.txt /m 100 /b...
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 21, 2016 at 9:25 am
Not sure that I ever had a database server get a case of the hiccups!
My opinion would be to find the root cause, and fix that. Putting in a...
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 3:29 pm
ram302 (6/16/2016)
I was wondering how to monitor a database to ensure it's up. I have scripts that perform stored procedure executions and they already check to make sure 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 3:00 pm
Lynn Pettis (6/16/2016)
Michael L John (6/16/2016)
Integer division was taught within the first three weeks of my first programming class in my first semester of...
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:58 pm
I'm sorry, this post infuriates me.
Integer division was taught within the first three weeks of my first programming class in my first semester of school.
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:26 pm
Viewing 15 posts - 1,741 through 1,755 (of 2,355 total)