Viewing 15 posts - 10,711 through 10,725 (of 49,552 total)
Turning the checksum option on does nothing at that point. Only when the page is next written out will the checksum be added. Rebuilding all indexes is the best way...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 6, 2013 at 2:39 pm
Thanks everyone
L' Eomot Inversé (12/6/2013)
I guess the next thing is for your number of posts to surpass the number of posts in the thread. 😎
I did have more posts than...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 6, 2013 at 1:28 pm
dan-572483 (12/6/2013)
Then why would my simple recovery model databases not come online with copies of the original log files in the new location?
The reason is in the error log
Operating system...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 6, 2013 at 1:27 pm
Nested replace will do that.
REPLACE(REPLACE(SourceString,'Brigade Army','BAY'),'Brigades Armies','BAY')
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 6, 2013 at 7:08 am
PravB4u (12/6/2013)
http://www.mssqltips.com/sqlservertutorial/27/sql-server-partial-backups/
That one is quite misleading and has no discussion of the considerations or requirements. I'd avoid it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 6, 2013 at 5:19 am
cw18 (12/6/2013)
select distinct top 100
i.invoice_id, i.buyer_code, i.submit_time, i.request_id
from
dbo.invoice i
inner join dbo.invoice_adj ia on i.invoice_id = ia.invoice_id and ia.amount !=0
left outer join dbo.invoice_detail iad on i.invoice_id =...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 6, 2013 at 4:59 am
kevaburg (12/6/2013)
Grant Fritchey (12/2/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 6, 2013 at 4:56 am
Please note: 3 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 6, 2013 at 2:21 am
spectra (12/6/2013)
Do I need to drop the database and copy database again ?
That's the easiest
there is some other simpler way out for data refresh using backuped data...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 6, 2013 at 2:21 am
If you're trying to get queries running faster, don't waste your time looking at partitioning, it's not a general performance tuning technique. Performance improvements are possible from partitioning, but it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 6, 2013 at 12:51 am
spectra (12/6/2013)
source db and destination db will remain in the same server......Is there any possibility of damage to source db if I do this ?
No
When do I rename...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 6, 2013 at 12:46 am
Easier way. Take a backup, copy the backup to the destination, restore the backup.
The Copy Database option can be a little finicky at times.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 6, 2013 at 12:32 am
What do you mean by 'collocation'? The definition I'm familiar with is 'the action of placing things side by side or in position', which doesn't make sense here.
As for the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 6, 2013 at 12:31 am
Ideas can't be copyrighted.
I have an idea for an article on when and how to create multiple file groups
I have an idea for an article on backups types and restores.
I...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 6, 2013 at 12:02 am
dan-572483 (12/5/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 5, 2013 at 11:48 pm
Viewing 15 posts - 10,711 through 10,725 (of 49,552 total)