Viewing 15 posts - 16 through 30 (of 2,007 total)
Following information from backupset system table would be helpful.
differential_base_lsn numeric(25,0)
Base LSN for differential backups. For a single-based differential backup; changes with LSNs greater than or equal to differential_base_lsn are included in...
July 16, 2012 at 12:18 pm
GilaMonster (7/16/2012)
So let's say you have this scenario:
Full backup 1
Full backup 2
Restore of Full Backup 1
Differential backup
Then to restore the...
July 16, 2012 at 12:08 pm
But in between snaphot1 and the restore, there is another full backup happened,it is our regular weekend full backup schedule. I will call it snapshot2.
Snapshot 2 backup has everything you...
July 16, 2012 at 1:21 am
My questions are:
1) Is anyone (besides me) really annoyed by Microsoft's decision to keep changing the names of these certifications. Wasn't it MCDBA not too long ago? And changed to...
July 16, 2012 at 1:04 am
I could truncate a table and insert the count into table but that is Kinda silly.
What about an UPDATE?
UPDATE Table_Name
SET Column_Name = Column_Name -- fake update
WHERE 1 = 1...
July 15, 2012 at 6:49 am
First two examples (in the suggested article below) exhibit non recursive common table expressions (CTE) but CTE is motsly used for recursion.
WITH common_table_expression (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms175972(v=sql.105).aspx
July 15, 2012 at 5:31 am
First of all, my heartily wishes on your achievement! Well Done!
‘how to further improve my chances in getting employment in this area’
This would be a difficult question to answer without...
July 15, 2012 at 5:04 am
Let’s discuss on the flow of the data first. It will highlight the area of threats & we might need to tighten up security there.
• Your source database is Oracle. (Assume...
July 15, 2012 at 4:55 am
Jonathan Kehayias (7/13/2012)
gerritjan.soede (7/13/2012)
On the General page, click on the Timeline button, and we can use the new Timeline slide to repeat the entire RESTORE operation, but this time...
July 14, 2012 at 8:54 am
Nice Article Jonathan! The article deserves 5 star rating. Keep writing… 🙂
July 14, 2012 at 8:21 am
SQLRNNR (7/10/2012)
Jeff Moden (7/10/2012)
Shifting gears a bit, I still think it strange that DBAs will allow such things to go on in...
July 14, 2012 at 6:55 am
Sorry for dragging the discussion. I setup a small test below.
CREATE TABLE DUMMY_TABLE
(
ID_COL INT,
DESC_COL CHAR(8000),
)
GO
INSERT INTO DUMMY_TABLE
VALUES
(1, REPLICATE('X',8000)),
(2, REPLICATE('X',8000)),
(3, REPLICATE('X',8000)),
(4, REPLICATE('X',8000)),
(5, REPLICATE('X',8000)),
(6, REPLICATE('X',8000)),
(7, REPLICATE('X',8000)),
(8, REPLICATE('X',8000)),
(9, REPLICATE('X',8000))
GO
CREATE CLUSTERED INDEX IX_DUMMY_TABLE...
July 9, 2012 at 11:28 am
Sure. We will do it together…
Scans vs. Seeks
http://blogs.msdn.com/b/craigfr/archive/2006/06/26/647852.aspx
July 9, 2012 at 10:44 am
SQLRNNR (7/9/2012)
Koen Verbeeck (7/9/2012)
Jeff Moden (7/7/2012)
Phil Parkin (7/7/2012)
SQLRNNR (7/7/2012)
I would use two file system tasks or perform the move via a script component.
I think you might mean a script task,...
July 9, 2012 at 10:25 am
ScottPletcher (7/9/2012)
Dev (7/9/2012)‘select only a very small % of the total rows’ is applicable to Clustered Index as well for seek operation else it will scan the cluster.
False, of course....
July 9, 2012 at 10:17 am
Viewing 15 posts - 16 through 30 (of 2,007 total)