Viewing 15 posts - 2,551 through 2,565 (of 3,232 total)
Colin,
You stated that :
"If you split tempdb off make sure it has the same number of physical spindles available as it did on the data array otherwise you introduce...
November 3, 2006 at 4:27 pm
How much of your total SQL load is contained within stored procedures?
November 3, 2006 at 4:20 pm
If you are not seeing resource contention on the database server and response times for your LAN users is fine, this is not a database issue. Just because the...
November 3, 2006 at 4:13 pm
Did you enable AWE? Did you set the /PAE and /3GB switches in the boot.ini file? Does the windows account that SQL Server is running under have the 'Lock pages...
November 3, 2006 at 4:07 pm
In addition to what Sergiy stated, SQL Server 2000 does not allow you to use a variable value for the number of rows returned by TOP. Look up 'SET ROWCOUNT'...
November 3, 2006 at 3:26 pm
Right, DBCC INDEXDEFRAG must lock portions of the table in order to defrag the index. If you use a tablock hint, you are locking the entire table, thereby preventing DBCC...
November 3, 2006 at 10:22 am
An index defrag is an online opperation so I'm curious as to where the timeout is comming from. How long does it run before you get a timeout? An index...
November 3, 2006 at 8:08 am
Well, the method for automating a DTS package usually consist of making it into a scheduled job and letting SQL Agent kick it off for you. I cannot see how...
November 2, 2006 at 2:36 pm
What query are you using to get the column name?
November 2, 2006 at 2:29 pm
John,
Cory is correct. If you have 7 GB of memory in your server, your Max Server Memory setting should be no higher than 6 GB. If your server is...
November 2, 2006 at 8:42 am
You can try to change the Transformations in the data pump to use an ActiveX script. You can then TRIM the first space off in the ActiveX script.
November 1, 2006 at 2:58 pm
As David suggests, this topic is a cross post from :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=319313#bm319459
November 1, 2006 at 1:15 pm
John,
David is correct in regards to adding the /PAE switch. This may be contributing to what you are seeing in terms of your paging file usage. I do disagree;...
November 1, 2006 at 1:14 pm
Am I missing something here, your post title says something about using wildcards? Anyway, look up REPLACE in BOL.
October 30, 2006 at 3:36 pm
I would recommend using an ORDER BY clause if you want your query to return the same TOP 1 each time it is run. The only...
October 30, 2006 at 12:10 pm
Viewing 15 posts - 2,551 through 2,565 (of 3,232 total)