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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2010 at 11:07 pm
Lynn Pettis (5/27/2010)
Here is some really good advice.
Ow.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2010 at 2:29 am
Viewing 15 posts - 32,701 through 32,715 (of 49,552 total)