Viewing 15 posts - 12,676 through 12,690 (of 22,214 total)
If I were doing it, I'd probably do that first.
April 21, 2011 at 7:35 am
Matt-1034261 (4/21/2011)
Grant Fritchey (4/21/2011)
April 21, 2011 at 7:19 am
Yes, it will. Just don't make any plans around shrinking databases on a regular basis. It really causes problems.
April 21, 2011 at 5:46 am
Rajesh Desai-289863 (4/21/2011)
a) restoring the logs
b) changing the backup to simple and then back to full , taking a full backup
After a transaction lob backup ( which does...
April 21, 2011 at 5:44 am
I would check your backup job. Unless your server has gone completely around the bend in a way I've never heard of, this command
BACKUP LOG MyDatabase TO DISK = 'somepath'
Will...
April 21, 2011 at 5:27 am
Yeah, that does make a slight difference. OK, let's look at it a different way, have you looked at the wait stats on the server? Are you waiting behind statistics...
April 21, 2011 at 5:22 am
I'm more than a bit list too. What error are you getting when you add the column to the CTE. Yes, you should be able to add a column to...
April 21, 2011 at 5:19 am
Check the server roles. Sounds like they might be sys admin on the box.
April 21, 2011 at 5:16 am
You're going to be hard pressed to find a good, comprehensive training program that is also completely free. How about picking up a book? I was one of the authors...
April 21, 2011 at 5:15 am
If you're assigning variables from a SELECT statement you just do this:
DECLARE @FirstVariable int, @SecondVariable int, @ThirdVariable int
SELECT @FirstVariable = FirstColumn,
@SecondVariable = SecondColumn,
@ThirdVariable = ThirdColumn
FROM MyTable
But, that query can only...
April 21, 2011 at 5:09 am
Usually others say this, but it's my turn. It really sounds like you're completely over your head here. I'd suggest hiring, even part time, a pro, someone who does this...
April 21, 2011 at 5:03 am
If the goal was move things off a file group in order to shrink it, yeah, then you have to shrink it. SQL Server won't automatically reclaim space unless you...
April 21, 2011 at 4:59 am
If you have auto update of statistics turned off, then your statistics on your indexes and tables are only good when they get created (or when your rebuild an index)....
April 21, 2011 at 4:58 am
Brandie Tarvin (4/20/2011)
Steve Jones - SSC Editor (4/20/2011)
Grant Fritchey (4/20/2011)
April 20, 2011 at 11:09 am
Stefan Krzywicki (4/20/2011)
opc.three (4/20/2011)
Stefan Krzywicki (4/20/2011)
April 20, 2011 at 10:01 am
Viewing 15 posts - 12,676 through 12,690 (of 22,214 total)