Viewing 15 posts - 17,566 through 17,580 (of 49,552 total)
The binary information is the actual 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
July 18, 2012 at 2:34 am
For future reference you'll often get quicker help if you provide the table definitions and sample data in a usable format, not just a description.
I'm guessing as to data types,...
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
July 18, 2012 at 2:18 am
Then it got damaged in the copy.
If both servers are 2008 R2 then you can restore backups between them. x86 vs x64 never matters
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
July 18, 2012 at 1:44 am
What's the logic behind that? Why is 16:00 in the results but 18:00 isn't?
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
July 18, 2012 at 1:34 am
36 this year so far.
My library (planned is not complete, lots of other books planned not added, need to go through the piles on the table)
http://sqlinthewild.co.za/?now_reading_library=true
Most recent 'geeky' book. That...
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
July 18, 2012 at 1:31 am
Yes, restoring a 2008 R2 backup from an x64 server to 2008 R2 on x86 works fine. Done it several times.
Check that the x64 doesn't have some 3rd party backup...
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
July 18, 2012 at 1:26 am
Safer just to always take it.
There will always be something in the log, whether it's just the record of the previous log backup, a checkpoint or a user transaction. Figuring...
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
July 18, 2012 at 1:25 am
Storage type?
SQL stores data in binary form within the data pages.
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
July 18, 2012 at 1:14 am
Suresh B. (7/18/2012)
TLOG backup does not contain entries which are already backedup.
Not entirely true.
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
July 18, 2012 at 1:06 am
Why?
That complicates the log backup process, it complicates restores as you won't know what files to expect.
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
July 18, 2012 at 1:05 am
You haven't completely restored the filegroup. Without knowing what you did in the restore, hard to say what need doing, but that restore process isn't finished or it failed.
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
July 18, 2012 at 1:03 am
Yes.
Yes.
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
July 17, 2012 at 6:08 pm
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
And to toss fuel on the fire, several of the query patterns mentioned in this thread would cause all sorts of hell when the plans are reused with different parameter...
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
July 17, 2012 at 5:31 pm
capn.hector (7/17/2012)
Lynn Pettis (7/17/2012)
Really???does not seem to be the same welsh as when i first started posting.
or is it
I don't know. There have been some seriously strange questions from him....
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
July 17, 2012 at 3:49 pm
I was hoping you'd just post it so I wouldn't have to download, virus scan then open a file. No matter.
Clustered index is on the Date column and then 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
July 17, 2012 at 3:16 pm
Viewing 15 posts - 17,566 through 17,580 (of 49,552 total)