Viewing 14 posts - 16 through 29 (of 29 total)
Another thing that can be affected if there internal fragmentation (large number of VLF's) is replication, I'm not sure whether your db is replicated but just another consideration.
January 24, 2012 at 7:38 am
Glad to help! Maybe worth a small blurb on my blog... Hmm...
I would say go for it, I looked around for a long time and didn't find much info out...
January 11, 2012 at 8:19 am
I would surmise 3MB was its default size.
Sure was 🙂
January 11, 2012 at 7:46 am
The test log shrank to 3mb.
My aim is to shrink the log files as small as possible so I can manually allocate the initial size. We are seeing high numbers...
January 11, 2012 at 6:49 am
USE test
DBCC SHRINKFILE(2,20)
Since we already know that the fileid is 2, go ahead and try this.
Hooray!! That worked!
Did some additional testing there must be something weird going on with...
January 11, 2012 at 6:32 am
To be safe, you really should run against test.sys.database_files
The file name and info matches in sys.database_files, sys.master_files, sys.sysaltfiles and dbo.sysfiles...
what is the recovery model of your database?
We are in simple...
January 10, 2012 at 9:32 pm
Yes I can physically see the file there
January 10, 2012 at 2:48 pm
Running SELECT * FROM test.dbo.sysfiles I got the following
[/code
fileidgroupidsizemaxsizegrowthstatusperfnamefilename
116705152-1020test_dataJ:\SQLdata\test_data.mdf
201280415-164000660test_logH:\SQLLog\test_log.ldf
32823280-16400020test_indexG:\SQLIndex\test_index.mdf
411363672-16400020test_data1P:\SQLData\test_data1.ndf
January 10, 2012 at 2:35 pm
Name in the first column in 'test_log'
January 10, 2012 at 1:57 pm
You could use substring to chop the char(101) into 4 char(30) fields in a view.
Code below to create a view named 'SplitInto30Char', splits 'test_field' which is in a table into...
August 12, 2011 at 2:27 pm
Check the role for the SQL Server Service account, is it set to sysadmin?
Here's a good article on some work around code for this problem.
Other thing to check would be...
August 9, 2011 at 8:32 am
Here are some suggestions from around the web, not sure whether they apply as you don't have a whole lot of information to go on.
Setting up the maintenance plan with...
August 9, 2011 at 7:54 am
I gave my input on this thread!
July 25, 2011 at 2:20 pm
Peter Maloof (7/5/2011)
I have to disagree that a phone book is an unclustered index.
Unless I'm mistaken, the white pages contain data physically sorted by
last name, first name and address. Once...
July 13, 2011 at 6:41 am
Viewing 14 posts - 16 through 29 (of 29 total)