Viewing 15 posts - 36,616 through 36,630 (of 49,562 total)
Jack Corbett (9/2/2009)
Hey, I stumped Gail! Wasn't intentional but when TEXT/NTEXT/IMAGE was mentioned I wondered about Filestream.
Looks like the answer is 'No'
-- Document is a varbinary(max) Filestream column
Create Index...
September 2, 2009 at 1:51 pm
Can you also post the table definitions and index definitions?
September 2, 2009 at 1:21 pm
Terry Grignon (9/2/2009)
I've seen mention of 'The number of data files within a single filegroup should equal to the number of CPU cores.'
That advice is for TempDB and only...
September 2, 2009 at 1:16 pm
There are quite a few site issues lately, timeouts, errors on posting. Some people will just retry and retry without checking to see if the post went through.
Yes, you can...
September 2, 2009 at 9:43 am
That said, shrinking the DB on a regular basis is not a good idea. Once you've got the size under control rather don't shrink the file regularly, just free up...
September 2, 2009 at 9:40 am
Roger Abram (9/2/2009)
Thank you. What would the best command to shrink the database?
DBCC SHRINKFILE
look up the full syntax in Books Online
September 2, 2009 at 9:29 am
fox1977 (9/2/2009)
Do i need anything around the database name? brackets or anything similar?
Only if the database name starts with a non-alpha character or has a space or other disallowed...
September 2, 2009 at 9:27 am
Roger Abram (9/2/2009)
If I truncate tables in that database, will that automatically decrease the size of the MDF file?
No
Or is there something I need to do afterwards?
Shrink...
September 2, 2009 at 9:06 am
Grant Fritchey (9/2/2009)
Excellent. Thanks. But now the follow-up. If you could only pick one or two disk counters to watch, what would they be?
The three I usually use are Avg...
September 2, 2009 at 8:56 am
Grant Fritchey (9/2/2009)
GilaMonster (9/2/2009)
Hell Grant. 425 attendees! That's going to be one of the best-attended sessions so far.Thanks. I was told the max number was 435. I only saw 410.
Mine...
September 2, 2009 at 8:51 am
Grant Fritchey (9/2/2009)
Ooh, I'll go! Any chance to learn something new.
Awesome. The more the merrier.
p.s. last year Steve and I were the ones who got pounded into the floor the...
September 2, 2009 at 8:47 am
Did you run just that? There's no '60' in that command that the incorrect syntax error refers to.
September 2, 2009 at 8:38 am
Grant Fritchey (9/2/2009)
What is wrong with using Avg. Disk Queue Length?
Two things.
Firstly, SQL can and does drive it very high if it does large read-ahead reads. If the storage engine...
September 2, 2009 at 8:38 am
RESTORE DATABASE < Dagtabase Name > WITH RECOVERY
Be aware, once you've done that the only way to restart log shipping is to start by restoring the full backup again.
September 2, 2009 at 6:48 am
Hell Grant. 425 attendees! That's going to be one of the best-attended sessions so far.
September 2, 2009 at 6:36 am
Viewing 15 posts - 36,616 through 36,630 (of 49,562 total)