Viewing 15 posts - 32,701 through 32,715 (of 49,552 total)
WayneS (5/28/2010)
GilaMonster (5/28/2010)
Apparently my going rate it too high. He did ask at least.Seems extremely reasonable to me!
It was. I did the exchange rate calc in my head and messed...
May 28, 2010 at 2:16 pm
From the sound of the error, there's corruption in the transaction log. Drop the affected databases and reconfigure log shipping for those DBs from scratch.
Also, do some checks of the...
May 28, 2010 at 9:54 am
Lynn Pettis (5/27/2010)
GilaMonster (5/27/2010)
Anyone keen and free?
I don't mind deadlock questions (though they're often a fair bit of work), but this looks like a general 'look at...
May 28, 2010 at 9:52 am
There's no bulk-encrypt option, objects have to be encrypted with an ALTER statement. Maybe a tool like Redgate's SQL Refactor could do it for you, or you could write something...
May 28, 2010 at 9:44 am
I usually charge around $1250-$1500 per month for something like this (one analysis and report a month, minimum duration 6 months). If you're interested, PM me and I'll send you...
May 27, 2010 at 11:07 pm
Lynn Pettis (5/27/2010)
Here is some really good advice.
Ow.
May 27, 2010 at 1:57 pm
laveen.bondugula (5/27/2010)
Drop the database and recreate it.Regards,
Laveen Bondugula
Database Analyst
And please do tell how you plan to drop TempDB?
May 27, 2010 at 1:40 pm
You're perfectly correct. The only service pack that I'm aware of that's not cumulative is Vista SP 2. Requires SP1 first.
May 27, 2010 at 1:35 pm
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 27, 2010 at 11:09 am
More free consulting? http://www.sqlservercentral.com/Forums/Topic928775-149-1.aspx
Anyone keen and free?
I don't mind deadlock questions (though they're often a fair bit of work), but this looks like a general 'look at the trace and...
May 27, 2010 at 11:07 am
The Dixie Flatline (5/27/2010)
GilaMonster (5/26/2010)
Is it me, or is this week particularly bad in the 'bad questions' dept?Gail, are you saying the posted questions are getting worse?
Worser.
May 27, 2010 at 10:55 am
Both options should work fine. Without seeing the code you ran and the error that you got, I can't tell you why it didn't work.
May 27, 2010 at 4:07 am
r5d4 (5/27/2010)
If i have multiple FILES assigned to a FILEGROUP, how can i determine the allocation of objects within a FILE?
Objects are stored in individual filegroups. If there are multiple...
May 27, 2010 at 4:06 am
If it's a datetime, store it as a datetime. If it's just a date, consider the DATE datatype since you're using 2008.
That way you get data validation (20100231 being...
May 27, 2010 at 2:56 am
You can drop or disable the index. Disabling it deletes the entire index tree structure, just leaves the metadata behind. You'll have to rebuild the index to re-enable it.
May 27, 2010 at 2:29 am
Viewing 15 posts - 32,701 through 32,715 (of 49,552 total)