Viewing 15 posts - 406 through 420 (of 1,271 total)
Looks like I missed the fun. I was able to check two answers and got it correct.
August 15, 2011 at 8:53 am
Can you post the code from the View. Looks like there is a concatenation operation that is triggering the spool. Is the view indexed? If so, what Editions is test...
August 12, 2011 at 5:52 pm
Did you have a look at this: T-SQL Tuesday #18 – Using CTEs to Pivot Data Into Date Ranges: http://www.sqlsoldier.com/wp/sqlserver/usingctestopivotdataintodateranges
August 8, 2011 at 10:55 am
I just confirmed that currently, the upgrade is only the knowledge exam and does not include the lab exam.
July 29, 2011 at 3:13 pm
I'm verifying the accuracy of the upgrade information on the website.
July 29, 2011 at 2:40 pm
Just to answer a couple of questions that remain:
I don't believe that the system enforces that you take the knowledge exam first. However, it is the cheaper of the two...
July 29, 2011 at 8:06 am
GilaMonster (7/8/2011)
You have to force it, but in synchronous mirroring (because transactions are committed on both sides before they are complete) there won't1 be data loss
(1) Unless something really wacky...
July 8, 2011 at 2:18 pm
Saying that "writing a query for an admin task is not the same as development work" would be like saying that "fire is not the same as hot stuff". If...
July 3, 2011 at 9:50 pm
If you have to do a full restore, how are you going to bring the index filegroup online if you don't have a backup?
June 28, 2011 at 9:33 pm
bopeavy (6/8/2011)
But as I have come to find out it is an art that must be changed or tweaked according to enviroment that your server is on.
Agree 100%
June 28, 2011 at 7:40 am
I always recommend against using integrated security for SSRS. this means you have to give users permissions to access the database directly. Use a service account to access the SQL...
June 28, 2011 at 7:34 am
One recommendation for script #4 would be to explain how to use sp_help_agent_profile to determine the correct @profile_id for sp_add_agent_parameter. It appears that you are supplying the agent_type value rather...
June 28, 2011 at 7:18 am
Why do you need to configure kerberos? I was going to make the same recommendation about using just NTLM. Using Windows Negotiate is a known cause of the problem you...
June 28, 2011 at 6:51 am
Viewing 15 posts - 406 through 420 (of 1,271 total)