Viewing 15 posts - 316 through 330 (of 334 total)
The growth is due to a miscalculation on the part of "Business" to the amount of transactions they were going to see and the space is being created by the...
October 18, 2010 at 3:53 pm
The data file (there's only one) is 490 gigs and has 250 gigs free inside the file.
Don
October 18, 2010 at 2:44 pm
What if I shrink the individual data files? Is that better or worse than shrinking the database and will that give me back my free space?
Don
October 18, 2010 at 11:31 am
I was afraid that would be the answer. 🙁
Don
October 18, 2010 at 10:57 am
Thanks, Celko, I'll take a look at that structure as well.
Don
October 14, 2010 at 1:29 pm
How can I take out the coalesce when it's possible to have a null value there?
I'll look at the covering index though, that would be a good place to start.
October 14, 2010 at 11:40 am
The table is 2.5 million rows.
Following is the entire query. If you can suggest a better method I would appreciate it.
SELECT TOP 1000
OM.OutID,
OM.MNumber,
OM.SCode,
OM.LDateTime,
OM.Mess,
OM.CID,
OM.Cype,
COALESCE(OM.Op,dbo.LookupCarrierFunc(OM.MNumber)) Operator,
SCG.Gateway
FROM OutMess OM
INNER JOIN View_SCodeCarGate SCG ON...
October 14, 2010 at 11:16 am
Sigh, sometimes I feel very far out of my depth.
I'll look into querying the plan cache, thank you.
Don
October 12, 2010 at 2:17 pm
Thanks all. What I gather from the responses is that there really isn't a faster way to move/copy the table.
For example, in MySQL I could just go into the operating...
October 12, 2010 at 2:02 pm
Derrick,
Unfortunately, we've grown out of control on the production database (happened before I came on board) and we can't replicate it due to storage issues.
Alvin,
How do you export in batches?...
October 12, 2010 at 1:21 pm
Thank you so much for your help!
I'm going to go with the detach, copy, and reattach. That'll leave a viable database on the first server while I'm working on the...
October 11, 2010 at 2:33 pm
Ok, so the copy wizard is a bad idea due to the length of time it will take. Got it.
What about the difference between backup/restore and detach/(move files to new...
October 11, 2010 at 2:17 pm
In SQL Server 2008, could I not just use the Copy Database Wizard after setting the database to single user mode to recreate it on the new server? It's also...
October 11, 2010 at 1:51 pm
Aha.. now I'm on the same page.
BOL is the contextual help (F1) from MSSQL.. I just didn't make the connection between how it's commonly known and how I use it....
October 11, 2010 at 1:28 pm
Thank you, I didn't know about the WITH MOVE option in restoring a database.
Dumb question. Does BOL stand for Books Online? And is this the Books section of SQLServerCentral.com?
Don
October 11, 2010 at 1:05 pm
Viewing 15 posts - 316 through 330 (of 334 total)