Viewing 15 posts - 181 through 195 (of 244 total)
You also need to review the setting for cost threshold for parallelism. This is the cost that a query must reach before it can go parallel. The default...
February 25, 2015 at 4:49 am
Ted's approach will help you figure out what part of the code has the problem and I was taught this same approach to troubleshooting query errors. It has been...
February 25, 2015 at 4:38 am
Lowell/Grant,
I am trying the code form the dba.stackexchange site and getting the following error.
Msg 25623, Level 16, State 3, Line 1
The event action name, "package0.event_sequence", is invalid, or the object...
February 19, 2015 at 5:30 pm
Srl832 (2/10/2015)
I have a couple of questions as a matter of fact.
We are running very small databases at this moment. All of our dbs in a server count...
February 10, 2015 at 10:14 pm
Jared, I definitely agree with Kevin's point #2. I think it would be helpful to see a full set of Wait stats results. I don't know what code...
February 8, 2015 at 10:51 pm
So what type of error are you getting? What is the indication that there is a problem?
February 8, 2015 at 10:30 pm
I can't speak to how normal or common it is to have multiple execution plans for the same piece of code. I can recommend that you review the indexes...
February 8, 2015 at 10:12 pm
I would do an internet search for "Log Shipping." There are a lot of resources that discuss how Log Shipping works and how to get it going when it...
February 8, 2015 at 10:00 pm
Tejesh (2/5/2015)
About the edition of Sql Server will you please let me know that will 2008 R2 work for the scenario where 9...
February 5, 2015 at 10:56 pm
Thanks Grant. This is somewhat the answer I was expecting but having no real experience with these tools I wanted feedback. I think I will work toward convincing...
February 5, 2015 at 10:09 pm
You might try running Process Explorer or Process monitor during the install process. These are sysinternals tools built by a Microsoft employee. The tools will trace what is...
February 4, 2015 at 9:16 pm
kumar.satheesh.k (2/4/2015)
Is any body know how can we deny an Object select Permission which have Sysadmin role.Please Advise me on this.
As the previous person said, SysAdmin has total control. ...
February 4, 2015 at 9:10 pm
Why don't you try giving them the db_owner role in MSDB and restricting the user's permissions elsewhere? This would limit what they can do outside of MSDB. At...
February 4, 2015 at 9:06 pm
SmilingLily,
I would have to do some more research. I would encourage you to take your error message to the internet and do the same. While I have some...
February 4, 2015 at 8:09 pm
SQL Server Books Online will walk you through the topics and steps related to installing SQL Server.
February 4, 2015 at 7:55 pm
Viewing 15 posts - 181 through 195 (of 244 total)