Viewing 15 posts - 46 through 60 (of 431 total)
I'm having the same issue which I described in the thread "Log shipping restore job doesn't restore"
Interestingly, this is also not standard SQL Log Shipping. The log files originate...
March 11, 2015 at 12:44 pm
Two messages up GilaMonster describes a scheduled shrink job she has on a dev server.
The closest I've come to a "routine" shrink is when I had a...
March 11, 2015 at 12:36 pm
TheSQLGuru (3/10/2015)
Your DBA isn't doing his/her job if they are allowing AUTOGROWTHS to maintain the database sizes!! Autogrowth should be an EXCEPTIONAL event. I tell my clients to...
March 11, 2015 at 11:57 am
Assuming you have a master DB backup, it can be restored, but the process is cumbersome, not well documented, and differs slightly depending on which version of SQL you're using....
March 11, 2015 at 11:42 am
But in my experience, whenever I've run a RESTORE LOG command with anything other than the correct TRN file, I get a "too early" or "too recent" error. Yet...
March 6, 2015 at 10:31 am
This database was developed in-house several years ago by developers who no longer work here. Yes, I suspect the table was designed in the GUI and they just typed the...
February 24, 2015 at 9:56 am
Jeff Moden (11/14/2014)
dan-572483 (7/14/2014)
I seem to recall in previous exams having at least 100 minutes to answer 45 questions - well over two minutes per question.
]]
2 minutes and 13 seconds...
December 31, 2014 at 6:49 am
These are ALTER INDEX statements, so I'm not sure that will work.
November 19, 2014 at 2:38 pm
Someday you may interview for a job in an all SQL 2014 environment, and a SQL 2012 Certification is going to look a lot more relevent than a 2008 Cert.
September 23, 2014 at 11:03 am
This issue may be limited just to SQL 2012. I know SQLExpress 2012 was installed first and I had this issue when subsequently installing SSIS from either SQL 2012 Developer...
August 18, 2014 at 12:25 pm
SpeedSkater is describing what I consider to be a bug in MSSQL. If you have installed SQL Express, you cannot install SSIS on the same machine, even to design packages...
August 18, 2014 at 11:56 am
I've also posted my resume on portals and have been contacted by many recruiters for jobs I am not qualified for, over-qualified for, or are out of my area. ...
August 15, 2014 at 11:02 am
Do you know the answer to my question? If auditing of all access is implemented can a sysadmin block tracking of their own activity?
August 13, 2014 at 5:28 pm
I found the answer.
If you have SQL 2012 Management Tools installed, the command is
Import-Module "sqlps" -DisableNameChecking
The command switch disables a warning message.
August 13, 2014 at 3:50 pm
Viewing 15 posts - 46 through 60 (of 431 total)