Viewing 15 posts - 541 through 555 (of 2,387 total)
It looks like tableB doesn't have same indexes as tableA.
You can force the query to use a specific index by using index hint but It may not give you better peformance...
February 4, 2004 at 5:43 pm
Blocking or deadlock?
http://support.microsoft.com/default.aspx?scid=kb;en-us;271509&Product=sql2k
February 4, 2004 at 4:32 pm
Is Cross DB Ownership Chaining setting no both database be turned on? If not, enable it and try again.
February 4, 2004 at 4:29 pm
"Will it perform the same if it has 5 users connected to it that are doing nothing as if there are 350 users connected to it doing nothing?"
I don't see...
February 4, 2004 at 4:26 pm
"Now I am trying to run this script from a remote server using OSQL."
How did you run it fro remote server? Please post the code.
February 4, 2004 at 4:21 pm
"EXEC sp_addlinkedservers 'ITCHY', N'SQL Server'"
There is no "s" in sp_addlinkedserver command.
Or use openrowset, for example.
SELECT a.* into Test2
FROM OPENROWSET('SQLOLEDB','tstsql01'; 'yourloginid' ; 'yourpassword' ,
'SELECT * FROM northwind..orders') AS a
February 4, 2004 at 2:55 pm
What symptom do you see during the end of month? It could be that your server is unable to handle such workloads.
You may post your server's hardware information here. Meanwhile,...
February 4, 2004 at 2:34 pm
How SQL Server memory be configured? Any other applications also run in same server? Which SQL Server service pack do you install? Any more information in SQL Server errorlog?
February 4, 2004 at 9:21 am
select substring(convert(varchar(11), getdate(), 106), 4, 3) + substring(convert(varchar(11), getdate(), 106), 10, 2)
February 4, 2004 at 8:03 am
Run DBCC Showcontig with TABLERESULTS option. See example E. in BOL.
February 4, 2004 at 7:51 am
Do you peform database maintenance such as reindex and statistics update regularly? Do you see memory presure after few days you rebooted the server?
February 2, 2004 at 4:55 pm
Is there a DEFAULT definition for the column?February 2, 2004 at 1:49 pm
From BOL.
"
This error occurs when Microsoft® SQL Server™ is engaged in some activity other than normal post-processing cleanup and it finds that a particular page it is attempting to unlock...
February 2, 2004 at 1:34 pm
How to move DTS package, see http://www.sqldts.com/default.aspx?204
To restore MSDB, start SQL Server with -T3608 and restore it.
February 2, 2004 at 1:33 pm
Viewing 15 posts - 541 through 555 (of 2,387 total)