Viewing 15 posts - 31 through 45 (of 73 total)
Hmm. Good one...
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
September 16, 2014 at 11:48 pm
basic question.
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
September 14, 2014 at 11:58 pm
+1
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
September 11, 2014 at 10:40 pm
Steve Jones - SSC Editor (9/11/2014)
Explanation corrected. I've removed the part that says the data cannot be recovered.
Thanks Steve
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
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)
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
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.
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
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...
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
September 11, 2014 at 3:00 am
Tricky....
good one...
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
September 10, 2014 at 1:40 am
Thanks for returning point.
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
September 9, 2014 at 9:44 pm
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...
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
September 8, 2014 at 11:28 pm
good question.
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
September 8, 2014 at 12:01 am
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
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
September 5, 2014 at 6:22 am
Thanks for the question dear.
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
September 3, 2014 at 10:41 pm
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 &...
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
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...
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
September 1, 2014 at 1:27 am
Viewing 15 posts - 31 through 45 (of 73 total)