Viewing 15 posts - 2,851 through 2,865 (of 7,429 total)
Ok to try and explain what happens.
First the query engine makes two passes across a query. The first time it crosses to validate syntax, the second is data.
Second QA use...
June 6, 2003 at 7:43 am
Actually look closer.
Go to Server Network Utilities and select TCP/IP and Properties. Type the ports, separated by commas and apply the settings. Stop and start SQL Server.
Go to Server...
June 6, 2003 at 7:24 am
Do
UPDATE tblName SET Col2 = Col1
June 6, 2003 at 7:20 am
Add the line
WITH RECOMPILE right before the AS in the existing SP and run a few times.
Then go back and remove it.
I have seen instances where the execution plan...
June 6, 2003 at 4:26 am
Look at the locks. During the data reorgs there will b exclusive locks on the table.
June 6, 2003 at 4:22 am
Profiler can make good determination but I only use as suggestions not always appropriate for final production. Even thou it can apply indexes and makes good suggestions based on the...
June 6, 2003 at 4:21 am
FOr the most part it is only the count you will run into that gives this problem in EM and needs to be updated. But
1) Developers make many more mistakes...
June 6, 2003 at 4:16 am
Yes, you can mix muliple types of servers on the same machine. But one will be the default instance and the other will be another instance. (See BOL instances)
June 6, 2003 at 4:11 am
It is probably the user login language setting. Look under EM and view anty particular user. Settings for server serve as a default when creating user accounts but when changed...
June 6, 2003 at 4:10 am
I would consider maybe looking at converting the logic in the VB app to a stored procedure so that it runs inside SQL Server and can be a job. If...
June 5, 2003 at 4:52 am
Because most everything done the EM actualy duplicates the table and moves the data into it, then drops the old and renames the new, all the while making sure triggers,...
June 5, 2003 at 4:46 am
Odd, when I tried it on a server with a single read-only DB I got a message database blah is read-only and it quit. Then I had to make read-write...
June 4, 2003 at 10:53 am
I use Notes at work and it does this automatically.
June 4, 2003 at 6:23 am
Please do not cross post. See/leave responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=12821&FORUM_ID=5&CAT_ID=1&Topic_Title=Help+needed+with+Sizing+TempDb+and+Server&Forum_Title=Administration
Moderator please handle this thread.
June 4, 2003 at 4:36 am
Generally it depedns on what is being done in the views as to whether or not is faster. Yes the undelying indexes are used (use Execution Plan view to see...
June 4, 2003 at 4:34 am
Viewing 15 posts - 2,851 through 2,865 (of 7,429 total)