Viewing 15 posts - 14,401 through 14,415 (of 22,211 total)
Ramji29 (8/31/2010)
Matt-1034261 (8/31/2010)
Ramji29 (8/31/2010)
GilaMonster (8/31/2010)
DB I used to work with had a 250GB log file. Make sure that you're maintaining it correctly and don't worry too much.
Thx Gail...
August 31, 2010 at 6:55 am
Matt-1034261 (8/31/2010)
Grant Fritchey (8/31/2010)
August 31, 2010 at 6:51 am
The think about backing up the drive is, SQL Server maintains locks on the files. They're not getting backed up. You'll need to create a backup process that creates a...
August 31, 2010 at 6:43 am
From the sounds of the system you describe, I think I would create a third table that is aggregated data of all the other information. You say that the reports...
August 31, 2010 at 6:30 am
Are you also loading data when these scripts are run? By & large, a set of data definition language (DDL) scripts should run very quickly. Assuming no data being loaded...
August 31, 2010 at 6:26 am
Frequently when the log is really big and no one is sure why, it's because the database is set to Full Recovery mode and there are no log backups running....
August 31, 2010 at 6:21 am
Based on three questions in just a few minutes, are you in an interview?
August 31, 2010 at 6:15 am
WayneS (8/30/2010)
For those that go to both this and the SQLPass summit (Steve, anyone else...) - which one has the better ROI? What are the differences?
My take on the two...
August 30, 2010 at 7:07 pm
jcrawf02 (8/30/2010)
Grant Fritchey (8/30/2010)
"It was interesting"
"I liked it"
"Interesting"
"You just made me sit through 45 minutes of a slow zoom...
August 30, 2010 at 12:29 pm
Steve Jones - Editor (8/30/2010)
Art sucks( I saw as I swig from a can of Pabst and watch XXX)
Now I'm really confused. I thought XXX was art?
August 30, 2010 at 12:25 pm
You guys are starting to sound like my film school criticism class...
"It was interesting"
"I liked it"
"Interesting"
"You just made me sit through 45 minutes of a slow zoom across the room...
August 30, 2010 at 12:12 pm
Scans don't automatically present performance issues, but I'm usually worried about them and more often than not, eliminating a scan improves performance. So, yes, I'd be concerned.
The next step is...
August 30, 2010 at 11:22 am
Management Studio doesn't usually mess with layout unless something else is running. Do you have Red Gate SQL Prompt or one of the other layout tools?
August 30, 2010 at 11:18 am
Ninja's_RGR'us (8/30/2010)
Grant Fritchey (8/30/2010)
Lots of columns, one table... eh.Try messing with an 86 table join. That's when life gets interesting.
especially if the columns are not qualified and that you don't...
August 30, 2010 at 8:47 am
Sounds like you're talking about the DAC Pack.
Steaming pile if you ask me, but here's some info on it[/url].
August 30, 2010 at 8:40 am
Viewing 15 posts - 14,401 through 14,415 (of 22,211 total)