Viewing 15 posts - 6,931 through 6,945 (of 7,636 total)
Grant the Datareader and Datawriter DB roles to Guest.
May 10, 2008 at 8:13 pm
leonp (5/10/2008)
1. Isn't it a good idea to have indexes on large tables (like 8GB) placed on a seperate physical disk?
It CAN be, but your mileage may vary. Separate...
May 10, 2008 at 5:23 pm
Post the query plan XML for the query. Also, here is a link that explains how to get better results from these forums: http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 10, 2008 at 4:59 pm
Adam Haines (5/10/2008)
rbarryyoung that is a pretty sleek avatar 😀
Well, at least I got something right!
Seriously though, I was aware of those considerations Adam, that's why I said "Try *something...
May 10, 2008 at 10:23 am
I call this "Presidential Campaign, 2008":
SELECT
RIGHT IDENTITYPRECISION IS ALL[/font]May 10, 2008 at 12:33 am
Matt Miller (5/9/2008)
yikes - took me doing it to see what you're talking about....yup - that one is a stinkaroo.
Yeah, I had to see it for myself too.
May 9, 2008 at 6:23 pm
Matt Miller (5/9/2008)
kevin mann (5/9/2008)
Why the prohibition from using SCOPE_IDENTITY (which would be your solution in this case)?
I don't know... ask the authors of Access. I cannot control which...
May 9, 2008 at 4:05 pm
I do not know any way to change Access/ODBC behavior in this.
If would still suggest that you take the Identity attribute off the Audit Log table and replace it with...
May 9, 2008 at 9:31 am
JohnG (5/8/2008)
Fulltext indexing is a substantial administrative commitiment
Interesting comment. We're running a SaaS business using it to index plain text as well as binary documents (Word, PowerPoint, PDF, etc.)...
May 8, 2008 at 4:08 pm
Fulltext indexing is a substantial administrative commitiment and should not be turned on without evaluating its costs and impacts.
May 8, 2008 at 1:57 pm
SQL is trying to compile your entire batch before it can be run and cannot resolve the name cproperty. When you use EXEC(string), that has it's own batch that...
May 8, 2008 at 12:44 pm
ahutchens (5/8/2008)
May 8, 2008 at 11:32 am
vinu (5/7/2008)
Thanks for your info..this method of determinig works but my company will not allow to follow this in all customers.....so can u advice...
May 8, 2008 at 11:09 am
bcronce (5/8/2008)
rbarryyoung (5/7/2008)
Unless the strings are huge, the difference is usually minuscule. The presence or absence of appropiate indexes and their selectivity makes a much bigger difference.
It's nice to...
May 8, 2008 at 10:52 am
Viewing 15 posts - 6,931 through 6,945 (of 7,636 total)