Viewing 15 posts - 38,086 through 38,100 (of 49,571 total)
That reminds me, I have photos of my old office
June 29, 2009 at 8:28 am
SQL Noob (6/29/2009)
It happens because SQL will backup an entire page if there is a change on it, not just the change.
Actually SQL will backup an extent (8 pages) if...
June 29, 2009 at 8:22 am
jaclynmcatanzaro (6/26/2009)
Good SQL Server article
You mean 'good collection of stolen content' seeing as most of that was copyrighted material reposted without permission and frequently without attribution or links
June 29, 2009 at 8:11 am
GSquared (6/29/2009)
June 29, 2009 at 8:09 am
Grant Fritchey (6/29/2009)
The Rules: They may be stupid, arbitrary and irritating, but god help you if...
June 29, 2009 at 8:02 am
Chris Harshman (6/29/2009)
June 29, 2009 at 7:59 am
Could be anything, but Shrinkdatabase shrinks both data and log files. Data file shrink's the bigger problem, but log file shrink can cause issues too.
Bottom line, if you don't want...
June 29, 2009 at 6:31 am
venu_ksheerasagaram (6/29/2009)
I am having one case here-- I have given a DB in which there is no FULL Backup on the system.
There was a full backup done sometime in the...
June 29, 2009 at 6:30 am
websites2 (6/29/2009)
Am I right in thinking that 5 indexes with 4 columns covering popular queries is better than 10 indexes each on a single column?
In general, yes. The majority of...
June 29, 2009 at 6:23 am
Paul White (6/29/2009)
The usual construction I see has master.sys.columns cross joined to itself. Of course that will not work for anyone with only 9 rows...
I didn't cross join because...
June 29, 2009 at 6:15 am
Kingsleen Solomon Doss (6/29/2009)
sorry we are shrinking database
There's your answer then. A shrink database will shrink the log.
Why are you shrinking your database though? Databases tend to...
June 29, 2009 at 6:12 am
If you've never taken a full backup, you cannot take a diff backup. It will fail.
The size of a diff backup depends on the amount of data that's changed since...
June 29, 2009 at 6:05 am
Kingsleen Solomon Doss (6/29/2009)
Thank you Shaw, We kept autoshrink as false and we do not manually autoshrink anywhere else.
If your log file is decreasing in size, you have a shrink...
June 29, 2009 at 5:48 am
Not that I've seen, but the first article is always local, the second is sometimes and then the ones below are from other sites. I just check the source and...
June 29, 2009 at 5:42 am
Add the columns in the index key. Not possible if there's lots or if they're of a type that can't be included.
June 29, 2009 at 5:41 am
Viewing 15 posts - 38,086 through 38,100 (of 49,571 total)