Viewing 15 posts - 2,281 through 2,295 (of 3,232 total)
The orginal post suggests that there are 2000 specific rows that need deleted.
May 10, 2007 at 10:51 am
You say that you have the OriginalNo values for the 2000 rows you want to delete. Where do you have these values? Please reply and include your table DDL.
May 10, 2007 at 10:29 am
Are there clustered indexes on these small tables? Can you post the SHOWCONTIG results for one of the tables in question? According to Microsoft, you should not be concerned with...
May 10, 2007 at 9:11 am
This is a great example of how to use a numbers table in combination with a table valued split function. Do a search on SSC for split or number table...
May 7, 2007 at 3:34 pm
I think what he may be asking is which how to know which method to use. Is this correct?
If this is in a stored procedure, you always want to...
May 2, 2007 at 4:46 pm
Well, if no new indexes are allowed then you don't have to worry about performance because you'll be able to guarantee that it will become poor as the table...
May 2, 2007 at 4:31 pm
Keep in mind Tony that the amount of time a query takes is not solely dependant on that query alone; rather, on the cumulative load that all concurrent queries are...
May 2, 2007 at 4:15 pm
I'd have to agree that 4-6 hours a day is a bit much for your everyday monitoring. I don't have 4-6 hours per day to spend on any one...
May 2, 2007 at 4:05 pm
It looks like this is a duplicate post to your other thread here:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=361181
For the short term, I would suggest making changes to your maintenance plan so that you are...
April 30, 2007 at 4:04 pm
FYI....
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=362112&post=true
April 30, 2007 at 4:04 pm
What error message are you getting at the time of failure?
April 30, 2007 at 3:27 pm
MSDB..SysJobs can tell you the last modified date of the job, but not who modified it. I would suggest revoking permissions from the helpdesk staff, or anyone for that matter,...
April 30, 2007 at 3:22 pm
You must specify the column names as the error message suggests.
April 30, 2007 at 3:18 pm
I'm afraid we are going to need more information in order to help you. Can you describe what it is you're trying to do and post any code you have...
April 30, 2007 at 3:11 pm
The TempDB gets rebuilt each time you restart the SQL Server Service so this seems strange that a global temp tables remains. How exactly is this impacting your backups?
April 30, 2007 at 3:03 pm
Viewing 15 posts - 2,281 through 2,295 (of 3,232 total)