Viewing 15 posts - 7,906 through 7,920 (of 49,552 total)
Yes, but it requires dynamic SQL which means you're at risk of SQL Injection attacks.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2014 at 8:00 am
SQL doesn't keep that kind of historical data. To find that out (especially the who accesses it), you'll need to run traces for long periods of time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2014 at 7:07 am
charipg (9/8/2014)
actually it inserting simple single record.
Then it's probably not the query. If it's inserting 1 row and the insert is 100% of the cost, there isn't going to be...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2014 at 6:53 am
Welsh Corgi (9/8/2014)
Koen Verbeeck (9/8/2014)
The error is quite clear.Access is denied
But why am I getting the error?
Because something, somewhere in the package requires permissions which the SQL Agent Service account...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2014 at 6:08 am
Hang on, I'm confused.
You said you don't want him to see the definitions of the objects.
Then you said that you tried denying view definition and it worked, the login was...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2014 at 2:28 am
thava (9/7/2014)
I told him that it is to uniquely identify a row in a table
Not at all, a clustered index doesn't have to be unique
(seriously...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2014 at 1:37 am
He's got to query the DB but isn't allowed to know the table names? How does that work? How does someone write queries without knowing table and column names?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2014 at 1:25 am
charipg (9/7/2014)
yes this is the specific insert query a problem .
What leads you to believe that?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2014 at 1:23 am
Eirikur Eiriksson (9/7/2014)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 7, 2014 at 7:05 am
Nothing you've said has suggested that lock escalation is the cause, and there's no deadlock graph or query details provided, so no way anyone can say anything useful
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 6, 2014 at 3:33 am
As far as I'm aware, there are no changes to the lock escalation mechanisms in SQL 2014.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2014 at 3:00 pm
Open up Books Online (the SQL help file) and search for DENY
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2014 at 7:12 am
If the problem reoccurs, call Microsoft customer support and open a case. A rollback shouldn't fail and take the DB offline, for any reason.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2014 at 6:51 am
Personally.... My father's an engineer (mechanical). I know what goes into studying to be an accredited engineer. I will never use the title Engineer for myself (I'm not one)
When, several...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2014 at 6:49 am
Just bear in mind that the counter in question is not the number of mid-index page splits (which are the expensive ones that cause fragmentation)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2014 at 4:01 am
Viewing 15 posts - 7,906 through 7,920 (of 49,552 total)