Viewing 15 posts - 6,916 through 6,930 (of 7,631 total)
davidthegray (5/9/2008)
Running aGRANT EXECUTE ON [dbo].[MergeStringSepBR] TO [TheRoleIWant]gives an error.
OK, what was the Error?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 15, 2008 at 8:54 pm
You cannot remove a Directory in use, no matter what your privileges are. I wold suggest trying to find the directory that it is trying to remove and see...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 15, 2008 at 10:18 am
Thanks, Steve!
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 12, 2008 at 4:30 pm
achaudhr (5/12/2008)
Thanks for helping. I tried to create that index but as the titles are lengthy & max is 1109 & it says max length allowed is 900 bytes.......I...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 12, 2008 at 2:25 pm
This seems like a compile error, which should mean that the [font="courier"]Print 'Begin'[/font] never executes either. Are you doing this in Dynamic SQL?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 12, 2008 at 12:54 pm
Add an index to tb_Titles on TiQueryValue that includes(covers) BibNumber and TiOrderByValue. That should make it run in about 5-6 seconds.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 12, 2008 at 12:26 pm
Sorry Topher, I cannot figure what you are actually asking for here.
IS your script broken and you want help with it? If so, please tell us what...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 12, 2008 at 11:59 am
Sure:
1) use SAN mirrors; (split the mirror, copy to dev, rejoin mirror)
2) use DB mirrors (similar)
3) use Prod's daily backups to restore to Dev
3) Log shipping
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 12, 2008 at 11:08 am
This is an extremely complex and detailed area and I doubt that any forum can supply the kind of extensive customized support that you need and should be receiving if...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 11, 2008 at 5:21 pm
It depends on how they get loaded after they are TRUNCATEd. If they are loaded in one statement, you probably wouldn't need to rebuild them, but if they are...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 10, 2008 at 8:53 pm
Grant the Datareader and Datawriter DB roles to Guest.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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/
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 10, 2008 at 10:23 am
I call this "Presidential Campaign, 2008":
SELECT
RIGHT IDENTITYPRECISION IS ALL[/font][font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 10, 2008 at 12:33 am
Viewing 15 posts - 6,916 through 6,930 (of 7,631 total)