Viewing 15 posts - 31 through 45 (of 72 total)
Steve Jones - SSC Editor (9/11/2014)
Explanation corrected. I've removed the part that says the data cannot be recovered.
Thanks Steve
September 11, 2014 at 10:13 am
Iulian -207023 (9/11/2014)
TomThomson (9/11/2014)
Koen Verbeeck (9/11/2014)
Vimal Lohani (9/11/2014)
September 11, 2014 at 4:53 am
Sorry for that, but i can't correct this sentence as i have no admin right for question of the day.
September 11, 2014 at 4:20 am
TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log.
this means if page is...
September 11, 2014 at 3:00 am
MERGE dbo.Sales
USING dbo.Salesdjustments
ON New_Id = Id
WHEN MATCHED THEN -- Update
UPDATE SET SalesAmount = NewSalesAmount
WHEN NOT MATCHED THEN -- Insert
INSERT (Id,SalesAmount) VALUES (New_Id,NewSalesAmount);[/B]
Hehehe i think there is...
September 8, 2014 at 11:28 pm
Ed Wagner (9/5/2014)
BWFC (9/5/2014)
TomThomson (9/5/2014)
Ed Wagner (9/5/2014)
BWFC (9/5/2014)
TomThomson (9/4/2014)
Ed Wagner (9/4/2014)
djj (9/4/2014)
Ed Wagner (9/4/2014)
Revenant (9/4/2014)
SQLRNNR (9/4/2014)
silverspoon
Feed
Qats
Granola
Museli
Sawdust 🙂
Project
Projectile
Pork chop
Launch
Filch
September 5, 2014 at 6:22 am
Vimal Lohani (9/1/2014)
Is there any way to restore a database of higher version to lower version.
for eg. I have created a database in sql server 2012, created some tables &...
September 1, 2014 at 2:11 am
ramana3327 (8/26/2014)
We are planning to upgrade. We are using Sql 2008R2 now. Which is the better option migrating to SQL 2012 or migrating to 2014?
I am thinking 2014 has...
September 1, 2014 at 1:27 am
Viewing 15 posts - 31 through 45 (of 72 total)