Viewing 15 posts - 3,301 through 3,315 (of 9,720 total)
To add to what Gail said, the ONLY 2 reasons you should consider shrinking TempDB would be:
1) A runaway query that has caused TempDB to grow exponentially beyond the usual...
January 10, 2014 at 5:46 am
Differential base... And so I learn a new term (that I arguably should have know before this).
Thank you again, Gail. You are a star.
December 19, 2013 at 11:26 am
GilaMonster (12/19/2013)
Full backups do not break the log chain. Differential backups do not break the log chain
I know that. The chain that was broken was between the differential and the...
December 19, 2013 at 10:58 am
jk_in_San_Diego (12/5/2013)
To...
December 11, 2013 at 5:32 am
Samuel Vella (12/5/2013)
Brandie Tarvin (12/5/2013)
December 5, 2013 at 7:00 am
jsimancas (12/5/2013)
SELECT[PlagiarizedArticle] AS oversite
,rank() OVER (partition by [Ben-Gan].public.Apology)
FROM SQLServerCentral
Result:
||Hope all is forgiven...here's your free book by author.||
HA! I like this one.
December 5, 2013 at 6:22 am
j.zinn (12/5/2013)
December 5, 2013 at 6:20 am
One thing most people don't realize is that quoting an author's work, and attributing it properly, might not be plagiarism but it is still copyright infringement. Microsoft gives a certain...
December 5, 2013 at 5:09 am
Having used Litespeed before I know it wouldn't help with this backup because it's a native SQL backup.
November 1, 2013 at 6:57 am
MyPath is a SAN drive on another server. I'd love to copy the backup file over to the server that I'm going to be restoring to, but I don't have...
October 31, 2013 at 10:44 am
In that case, I'd make sure you have enough RAM for both instances to be up (when the other server fails) and still be able to run the OS, etc....
October 31, 2013 at 7:53 am
I don't advise using the same server for a warm standby of your primary database. If you lose the server, you lose both the primary and the stand by.
October 31, 2013 at 5:01 am
According to Brent Ozar's blog (in the comments) it's 64GB per instance. But you should read his reply to that comment.
http://www.brentozar.com/archive/2010/06/sql-server-r-standard-supports-less-memory/%5B/url%5D
EDIT: You should also consider what will happen to the...
October 31, 2013 at 4:50 am
Speaking of maps and geospatial data, which is a better type of data to use? Raster or Vector?
October 24, 2013 at 5:09 am
The entire structure depends on your data, what you're keeping, etc.
The way we have ours designed is by using versioning. We keep a "main" table that is narrow and contains...
October 16, 2013 at 9:34 am
Viewing 15 posts - 3,301 through 3,315 (of 9,720 total)