No announcements
Found 3782319 threads
-
1 VotesSQL Server size increasing dramatically
If its not set it will use your data file to do the sort operation which can cause a dramatic increase in its size.Answered | 7 Replies | 1028 Views | Created by Jafferpg - Thursday, January 11, 2018 2:02 PM | Last reply by Hannah Yu - Monday, January 22, 2018 7:20 AM
-
2 Votes
MDF file size increasing
Check if any bulky process happen recently, Index maintenance is also one of the cause of .mdf file increase.Answered | 3 Replies | 4320 Views | Created by Nikhilsharma01 - Tuesday, June 4, 2013 4:37 AM | Last reply by Pradeep Madheshiya Microsoft(MSFT) - Tuesday, June 11, 2013 2:09 PM -
0 Votes
SQL LOG FILE SIZE INCREASING
But please do it when load is relatively less or preferably during downtime.Answered | 12 Replies | 2082 Views | Created by dbadays - Wednesday, October 29, 2014 12:44 PM | Last reply by dbadays - Wednesday, October 29, 2014 10:25 PM -
0 Votes
Is the same thing stored in sql server metadata also when data file size increases.
Adding to that, you can find the file growth information in the growth report you get when right click the database and goto report sections in management ...Answered | 4 Replies | 1987 Views | Created by Ajay.G - Friday, November 23, 2012 5:43 AM | Last reply by santhubt - Friday, November 23, 2012 6:16 AM -
1 Votes
Differential backup file increase in size
After I delete it and shrink the log transaction the backup file returned to be in normal size.Answered | 7 Replies | 2695 Views | Created by exai - Monday, February 11, 2013 12:57 PM | Last reply by exai - Thursday, February 14, 2013 7:08 AM -
2 Votes
Data lake File Metadata
From a collection stand point, Powershell is the way to go as it also provides functionality not currently supported in U-SQL such as Looping.Answered | 5 Replies | 2313 Views | Created by Esby - Wednesday, August 30, 2017 9:14 AM | Last reply by Sean Forgatch - Friday, September 15, 2017 1:08 AM -
0 Votes
Abnormal Database Size Increase when SSIS Runs
SQL Server is lousy at re-using space in heaps.Answered | 24 Replies | 1417 Views | Created by sync_master - Monday, November 11, 2019 3:11 PM | Last reply by Yitzhak Khabinsky - Wednesday, November 13, 2019 7:19 PM -
1 Votes
SQL Logs Size Increasing automatically
and so on named files are being created automatically in the Logs folder where SQL stores it's logs.I don't know why is this happening.Answered | 4 Replies | 1112 Views | Created by Zubair Masihullah - Wednesday, March 5, 2014 9:07 PM | Last reply by Katherine Xiong - Thursday, March 6, 2014 9:53 AM -
2 Votes
Buffer Size error when retrieving Metadata - How to increase size?
I just increased those two settings and it works great.Answered | 15 Replies | 61397 Views | Created by Webbert - Thursday, July 27, 2006 5:26 PM | Last reply by the_stick_boy - Saturday, November 13, 2010 12:13 AM -
0 Votes
Store data to multiple NDF data files using SQL Server 2008 Express
hi Peggy, the answer Lekss provided is correct... about multiple secondary data files and filegroups...Answered | 2 Replies | 6504 Views | Created by pchoskw - Sunday, March 21, 2010 9:49 PM | Last reply by Andrea Montanari - Tuesday, March 23, 2010 11:31 PM -
1 Votes
It is good to make a new data file or increase the space of all the data-files.
But its good to increase file size as 512 is a very small size for a datafile.Answered | 8 Replies | 1676 Views | Created by Ajay.G - Saturday, March 9, 2013 2:41 PM | Last reply by Saurabh Sinha DBA - Sunday, March 10, 2013 6:43 PM -
0 Votes
TempDB size increasing - SQL Server 2008 R2
I doubt your tempdb log file configuration too no matter how many files you have only one will be active at any time, having extra files won’t necessarily ...Answered | 4 Replies | 14261 Views | Created by Reddy Balaji C - Saturday, June 11, 2011 7:54 AM | Last reply by Uri Dimant - Sunday, June 12, 2011 6:58 AM -
0 Votes
Flat File size stored in SQL Server
Hi, i think yes, 5GB file can be sent to sql server.Answered | 1 Replies | 4854 Views | Created by Amydom - Tuesday, April 24, 2012 8:15 PM | Last reply by SQLBAG - Wednesday, April 25, 2012 4:48 AM -
0 Votes
SQL Server data type and size
In the system I work with, our firstname colunms are typically varchar(36), but that is because we use the same name for all name columns, and since our system also has ...Answered | 3 Replies | 785 Views | Created by Thomas_ITsavvy - Monday, May 11, 2015 6:48 PM | Last reply by Erland Sommarskog - Monday, May 11, 2015 10:01 PM -
1 Votes
Differential backup file size increased
Can you please advice, What makes this huge difference in file size?Answered | 3 Replies | 4585 Views | Created by kiranmsh - Monday, October 22, 2012 7:53 AM | Last reply by Olaf Helper - Monday, October 22, 2012 11:06 AM -
1 Votes
multilingual metadata store
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/ MS SQL optimization: MS SQL Development ...Answered | 1 Replies | 756 Views | Created by carlop - Friday, November 16, 2018 9:12 PM | Last reply by Uri Dimant - Sunday, November 18, 2018 8:24 AM -
0 Votes
Adding or Increase LDF file size
I would advise to use BATCHSIZE parameter wheather or not you Add a new file or increasing the size.Answered | 4 Replies | 4937 Views | Created by SunitaA - Friday, August 12, 2011 11:31 AM | Last reply by ajaymalloc - Friday, August 12, 2011 12:06 PM -
0 Votes
Will the database size increase using XML data type for a particular DB
Another thing to remember is that XML is a "large value type", and so you get to choose how they are stored.Answered | 4 Replies | 1314 Views | Created by Preetha7 - Friday, November 15, 2013 4:29 AM | Last reply by wBob - Monday, November 18, 2013 10:53 PM -
4 Votes
Metadata missing when uploading a Document with same name
Metadata missing when revising document Document Library Metadata Lost when Office File ...Answered | 5 Replies | 5423 Views | Created by BJ Mc - Wednesday, April 27, 2016 5:06 PM | Last reply by Sara Fan - Thursday, April 28, 2016 8:04 AM -
0 Votes
How to reduce the size of dbo.tbl_functionCoverage and also TFS sql server database size?
Cleaning Run-level attachment deletes the codecoverage files but they do not delete the data in tbl_functionCoverage (Which is created after parsing corresponding ...Answered | 11 Replies | 2323 Views | Created by Mitul Suthar - Monday, June 22, 2015 4:01 PM | Last reply by DB24 - Friday, May 26, 2017 2:28 PM - Items 1 to 20 of 3782319 Next ›
No announcements
