Viewing 15 posts - 19,801 through 19,815 (of 49,552 total)
SQLKnowItAll (3/12/2012)
GilaMonster (3/12/2012)
SQLKnowItAll (3/12/2012)
I think now that the OP knows that % must be in brackets when being used as a literal, the issue is fixed.
It doesn't have 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
March 12, 2012 at 2:09 pm
If you're considering full recovery, please read through this - Managing Transaction Logs[/url]
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
March 12, 2012 at 1:48 pm
SQLKnowItAll (3/12/2012)
I think now that the OP knows that % must be in brackets when being used as a literal, the issue is fixed.
It doesn't have to be in brackets,...
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
March 12, 2012 at 1:41 pm
Without clearer explanations, we're not likely to have a clue either. Have you asked the teacher/lecturer?
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
March 12, 2012 at 1:40 pm
Can you be more specific?
What is the requirements for the EventID? What's it going to be used for? (if nothing, why do 'they' care about how it's generated)?
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
March 12, 2012 at 1:25 pm
Grant the users select on that view and no other permissions. With that all they'll be able to do is see and query the view.
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
March 12, 2012 at 1:15 pm
Jayanth_Kurup (3/12/2012)
Would 4 GB on OS RAM be sufficent for a database being used with sharepoint ?
Depends on what else is installed on the server and how much memory...
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
March 12, 2012 at 1:13 pm
No such thing as SQL 2003.
There are many ways to generate artificial primary keys (keys that have no meaning within the data), there's also the option not to use an...
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
March 12, 2012 at 1:11 pm
jean 93062 (3/12/2012)
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
March 12, 2012 at 9:17 am
ALTER TRIGGER [dbo].[tr_TaxID]
ON [dbo].[Item] after INSERT, UPDATE AS
UPDATE item SET taxid = 1 WHERE item.id IN (SELECT id FROM inserted);
Done.
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
March 12, 2012 at 8:54 am
First step: Fix your statistics, it's well known that SQL 2005 does not use the SQL 2000 statistics format well.
Once that's done, if you still have problems look at...
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
March 12, 2012 at 8:09 am
Eugene Elutin (3/12/2012)
Actually, if you use CTE in a VIEW, you don't use the statement terminator before WITH.
A view is a single statement, hence there can't be a previous...
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
March 12, 2012 at 8:04 am
Also take the ; before the WITH out. ; is a statement terminator, you don't start statements with a symbol that marks the end of a statement (just like you...
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
March 12, 2012 at 7:34 am
Check that the backup server is visible from the places where the backup is failing. Check that the SQL Server service account has permission on the backup location.
I also wouldn't...
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
March 12, 2012 at 7:30 am
That might shrink TempDB, it might do nothing (internal objects can't be moved by a shrink), it might cause corruptions that will force a restart.
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
March 12, 2012 at 7:28 am
Viewing 15 posts - 19,801 through 19,815 (of 49,552 total)