Viewing 15 posts - 166 through 180 (of 476 total)
We put everything in default filegroup. Our clients' databases don't exceed 50GB, mostly they are 5-10GB. At least 50% of that is our logging data rather than their...
October 14, 2015 at 1:23 am
vmit02 (10/13/2015)
Adding the JOIN produced 0 results. That means only 1 backup is in each file? which is what it should be.
That's good to hear! (I was worried...
October 14, 2015 at 1:09 am
SSMS (Tasks : Generate scripts) will generate INSERT statements for data. It doesn't do the HEX thing, but it doubles up embedded single quotes. Would that do instead of...
October 14, 2015 at 1:01 am
ScottPletcher (10/13/2015)
For absolute max speed, you should also cluster the temp table on ID
Thanks Scott. I do in fact do that, declaring the ID as a PRIMARY KEY.
CREATE CLUSTERED INDEX...
October 13, 2015 at 12:02 pm
ben.brugman (10/13/2015)
We have to establish what we want. Although we have similar wishes we have not jet inventarised what we want/need.
🙂
I don't have much time, so without promising more...
October 13, 2015 at 11:57 am
dave 67553 (10/13/2015)
As for backups, are you compressing your backups? If not, do so. It saves time and storage space and very few SQL Servers are so CPU constrained that...
October 13, 2015 at 8:35 am
Interesting. If the column(s) are Nvarchar and do not contains, will never contain, extended characters wouldn't a one-time change of database structure to Varchar be better than long-term use of...
October 13, 2015 at 3:34 am
When I do this (in batches) I wonder if the selection criteria (i.e. "like 'SIC%'" in your case) takes time on each iteration of the loop.
I get all the clustered...
October 13, 2015 at 3:24 am
Dave Convery (10/13/2015)
October 13, 2015 at 3:06 am
If you have several columns in the same table (as ALTER COLUMN doesn't support multiple columns in a single statement) and given that some NVARCHAR columns might be PKey etc??...
October 13, 2015 at 3:03 am
P.S. Does anything happen if anyone FLAGs a post as SPAM? Looking at e.g. page 5 of "Data Corruption" forum there are lots showing (from a week or more...
October 13, 2015 at 2:25 am
Dave Convery (10/13/2015)
October 13, 2015 at 2:22 am
Is it relevant that the RESTORE HEADER you did was:
restore headeronly
from disk = 'D:\ManualBackups\TWS_RE7_Live_20151011[highlight="#ffff11"]120000[/highlight].trn'
restore headeronly
from disk = 'D:\ManualBackups\TWS_RE7_Live_20151011[highlight="#ffff11"]114500[/highlight].trn'
restore headeronly
from disk = 'D:\ManualBackups\TWS_RE7_Live_20151011[highlight="#ffff11"]113000[/highlight].trn'
but the query shows:
backup_set_id backup_start_date ...
October 13, 2015 at 2:11 am
I don't know how much overhead full text has, but we implemented our own keyword table to facilitate predictive search on products.
I found a public domain Dictionary list of English...
October 12, 2015 at 6:27 pm
Is the database readonly for query users? If so could you keep the database in NORECOVERY and restore LOG files to it? (i.e. some sort of Log Shipping)
Can...
October 12, 2015 at 6:00 am
Viewing 15 posts - 166 through 180 (of 476 total)