Viewing 15 posts - 24,991 through 25,005 (of 49,552 total)
Welsh Corgi (7/10/2011)
george sibbald (6/22/2011)
why don't you want to use a DDL trigger?
I was wondering how you can prevent a member of the db_owner from from disabling or altering the...
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
July 10, 2011 at 5:18 pm
While it's running check sys.dm_exec_requests and see what it's blocked by (wait type and wait resource). Also check that there isn't another concurrent log backup running.
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
July 10, 2011 at 5:17 pm
As far as I know, it depends on the type of the function. Inline table valued functions don't have cached plans, they're treated just like parameterised views. I think 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
July 10, 2011 at 1:28 pm
Not on the delete but...
You have multiple begin tran statements and no commits. You need a commit transaction for each begin transaction. I would suggest rather a single begin tran...
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
July 10, 2011 at 7:21 am
SVR (7/9/2011)
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
July 10, 2011 at 6:46 am
Well that's pretty clear.
Use an account that is in a trusted domain or speak to the domain admin about adding a trust relationship.
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
July 10, 2011 at 6:45 am
Grubb (7/7/2011)
Thanks for the links, Steve!As an aside, Gail is teaching an entire class on Execution Plans at this year's PASS conference: http://www.sqlpass.org/summit/2011/Speakers/CallForSpeakers/SessionDetail.aspx?sid=1245
Minor correction. Grant and I are teaching 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
July 10, 2011 at 6:43 am
Check the error log for the detail of the error.
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
July 10, 2011 at 5:45 am
Does the administrative account you're using have access to SQL? It's no longer a default that all administrative accounts are sysadmin.
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
July 10, 2011 at 4:59 am
pdanes2 (7/9/2011)
GilaMonster (7/9/2011)
pdanes2 (7/9/2011)
How do YOU deal with possible overflows of text input? Same logic in the front-end as in the database? Wait for the DB to throw an error?
Validation...
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
July 10, 2011 at 4:56 am
LutzM (7/9/2011)
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
July 9, 2011 at 4:35 pm
pdanes2 (7/9/2011)
How do YOU deal with possible overflows of text input? Same logic in the front-end as in the database? Wait for the DB to throw an error?
Validation in the...
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
July 9, 2011 at 4:09 pm
ALZDBA (7/9/2011)
General rule of thumb for driving Belgian style: "There's only I and the rest is...
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
July 9, 2011 at 2:34 pm
pdanes2 (7/9/2011)
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
July 9, 2011 at 2:27 pm
The information_schema is ISO-standard. Hence, if MySQL correctly implements the ISO standard the schemas will be identical.
However if you do what to check, this shows the definitions of all the...
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
July 9, 2011 at 12:40 pm
Viewing 15 posts - 24,991 through 25,005 (of 49,552 total)