Viewing 15 posts - 44,776 through 44,790 (of 49,571 total)
Do you have the master database or a backup of the master database?
September 1, 2008 at 12:09 am
60 million rows is not beyond SQL's capabilities. I've had more than that in a single table. The design needs to be done carefully, but it is possible.
Are you expecting...
August 31, 2008 at 11:53 pm
Please don't cross post. It just wastes people's time and fragments replies. Many of us read all of the forums
No replies to this thread please. Direct replies to
http://www.sqlservercentral.com/Forums/Topic561824-149-1.aspx
August 31, 2008 at 11:51 pm
Very nice.
Just one small thing. You say that for data storage, temp tables are in TempDB and table variables are in memory and tempDB. I may be misunderstanding what you...
August 31, 2008 at 11:50 pm
It means that the OS has forced a lot of SQL's memory into the swap file. As the message says, it's near guranteed to result in poor performance.
How much memory...
August 31, 2008 at 11:39 pm
Is it enabled? (check the status tab of the login properties)
I don't have that on my system, but the couple of ## logins I do have are disabled.
August 31, 2008 at 2:09 pm
Something like this should work. It's rough, but should give you the idea.
CREATE TABLE #AllDbSpaceInfo (
...
)
exec sp_MSForEachDB ('Use ?; Insert into #AllDbSpaceInfo EXEC ....)
SELECT * from #AllDbSpaceInfo
August 31, 2008 at 1:19 pm
Restore a backup? Depending on the type of corruption the built-in SQL tools may be able to repair them, or may not. If not, it's unlikely that a 3rd party...
August 31, 2008 at 1:13 pm
Steve Jones - Editor (8/31/2008)
You should probably read the security sections in Books Online to understand this.
This in the wrong place?
August 31, 2008 at 10:07 am
Steve Jones - Editor (8/31/2008)
You can always call Microsoft PSS and perhaps they can help you with getting some data
They won't help with that. I helped out with an unrecoverable...
August 31, 2008 at 9:35 am
Do you want help with the DB portion, the VB portion or everything? Can you show us what you have so far? (table structures at the least)
August 31, 2008 at 3:36 am
Did you get the error exactly like that, with the %ls in it?
I hope you have a backup. That kind of corruption isn't repairable and with a damaged file header...
August 31, 2008 at 3:14 am
Even the update ran on only one thread. Both the cursor and the update maxed one of my processors for the duration.
Probably a mixture of clock speed and that possibly...
August 30, 2008 at 1:12 pm
rbarryyoung (8/30/2008)
It was very CPU-bound. I think that Gail's desktop is a lot better than my laptop. 🙂
Probably. I've got a fairly new quad core with 4 GB...
August 30, 2008 at 12:36 pm
day (8/29/2008)
Hi everyone,I was wondering has anyone competed CURSOR against INNER JOIN for bulk UPDATEs:
Some reason you can't test it yourself?
I'll bite...
Tested on SQL 2008 RTM on a desktop.
CREATE TABLE...
August 30, 2008 at 11:04 am
Viewing 15 posts - 44,776 through 44,790 (of 49,571 total)