Viewing 15 posts - 12,856 through 12,870 (of 22,214 total)
Backup processes run under the security setting that is granted to the SQL Server service. Check that for security settings.
April 1, 2011 at 4:31 am
Generally I give access through defining Roles. You then GRANT SELECT to the Role, not to users. Then you add users to the role.
If users have more access than...
April 1, 2011 at 4:30 am
You need to identify which parts of the process are specifically hitting tempdb. That's step #1. Then you need to figure out what in those processes is causing tempdb to...
April 1, 2011 at 4:27 am
Michael Valentine Jones (3/31/2011)
Grant Fritchey (3/31/2011)
You can use a table valued parameter as an output parameter. But what are you trying to do?
I believe that is only available in SQL...
March 31, 2011 at 4:19 pm
Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
Oh, him. Yeah, I...
March 31, 2011 at 3:23 pm
You can use a table valued parameter as an output parameter. But what are you trying to do?
March 31, 2011 at 1:05 pm
I'm sorry, can you define the terms? What do you mean by CR?
March 31, 2011 at 12:59 pm
Not sure I understand the question completely.
In the query optimizer there's a process called the Algebrizer that goes through the TSQL code and identifies all the pertinent objects. They actually...
March 31, 2011 at 10:25 am
GilaMonster (3/31/2011)
David Benoit (3/31/2011)
Grant Fritchey (3/31/2011)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
If it is the...
March 31, 2011 at 8:27 am
Krasavita (3/31/2011)
March 31, 2011 at 8:10 am
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
March 31, 2011 at 7:40 am
Krasavita (3/31/2011)
Hi, here is another stored procedure I found with a problem with nested Loop.Can you please help me to identifiy which update statment is wrong.Thank you so much
You're still...
March 31, 2011 at 7:38 am
Let's assume that the view is fairly straight forward. It's a query against a table or a small set of tables that is properly configured. In that case, the optimizer...
March 31, 2011 at 5:44 am
Sounds like a perfect solution for SQL Azure. You have data that you want everywhere you go, right? There it is.
March 31, 2011 at 5:37 am
Last company I worked for made the decision to stay on 2008 on most servers because the licensing cost was too severe. The exceptions were SSRS servers, servers supporting spatial...
March 30, 2011 at 7:34 pm
Viewing 15 posts - 12,856 through 12,870 (of 22,214 total)