Viewing 15 posts - 19,816 through 19,830 (of 26,490 total)
Lynn Pettis (7/10/2009)
July 10, 2009 at 1:55 pm
That's because we don't have the data to see what is going on behind the scenes. I'll wait and see what Luke comes back with on this one.
July 10, 2009 at 1:41 pm
It would help to see the DDL for the base tables (including indexes) and the view. Anything we might do without those would just be shots in the dark.
July 10, 2009 at 1:32 pm
Please read this article[/url] and follow the guidelines within to post the necessary info so we may better help you with your performance issue.
July 10, 2009 at 1:30 pm
GSquared (7/10/2009)
Not going to say it can't happen, just that I've never...
July 10, 2009 at 1:25 pm
You can also license SL Server per user, and then it doesn't matter how many processors the server has, just the number of users/devices that are accessing the data. ...
July 10, 2009 at 12:17 pm
I can't answer your last question, but with regard to licensing of SQL Server, it is based on physical processors (or sockets if you will).
If you have a dual-processor server...
July 10, 2009 at 12:14 pm
IE 7. I use IE 7 at home with no problems.
Personally, I think it has something to do with the our network or some piece of hardware used on...
July 10, 2009 at 11:51 am
Peso (7/10/2009)
Another 4 page rant over here
Perhaps we should take their approach, and ask Steve to close this thread as well. I do have to admit I liked reading...
July 10, 2009 at 11:46 am
I think it really depends on where you want to go career wise. Your choices offer different career paths, one being more system/network related the other Database-centric.
July 10, 2009 at 11:24 am
Why are you allowing users to write SQL directly against the database any way? Such access should be through an application or API (such as stored procedures).
July 10, 2009 at 11:16 am
josetur12 (7/10/2009)
Thank you, the function below worked..select stuff('PQ19188PFHAA',10,1,'')
Thanks again.
Thanks for the feedback.
July 10, 2009 at 11:13 am
LeeM (7/10/2009)
1. It does use more system resources than one instance: you have two sets of system databases including tempdb...
July 10, 2009 at 11:09 am
How about posting the code you are working with and the table structure of your logging table. A little hard to provide good advice when we are basically shooting...
July 10, 2009 at 11:03 am
Viewing 15 posts - 19,816 through 19,830 (of 26,490 total)