Viewing 15 posts - 25,306 through 25,320 (of 49,552 total)
Wow, lots of stuff happening. Congrats to everyone who deserves 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
June 28, 2011 at 2:29 pm
Grant Fritchey (6/28/2011)
I'm working in Denali a lot lately and I haven't seen a build that works there. I'll have to bug the developers next week. I miss it already.
They're...
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
June 28, 2011 at 2:21 pm
Do these tables have an 'inserted date' column or identity column? If not, there's no way to get insert/modification dates. SQL does not keep track of such things for rows.
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
June 28, 2011 at 2:02 pm
Grant Fritchey (6/28/2011)
But I wouldn't sweat performance out of the gate. Backups, compliance, monitoring.
Yup. lack of backups (recoverable backups) can seriously harm the business and get you fired. Failure...
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
June 28, 2011 at 1:57 pm
manning20 (6/28/2011)
Thanks for responding. Our budget is tight, but we want high availability and redundancy. We want minimal downtime if our main production server crashes.
That's kinda vague.
There are several...
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
June 28, 2011 at 1:54 pm
Rich Yarger (6/28/2011)
Well - I hope you got a good laugh from it Gail, because his actions are about as laughable as they are believable.
I did, especially since there was...
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
June 28, 2011 at 1:51 pm
I did mean the only type of error, but there are two types of allocation errors in your checkDB output.
If you don't fix it, queries that hit the corruption will...
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
June 28, 2011 at 1:49 pm
oluwaseunadenaike (6/28/2011)
I guess SQL profiler and the DB tuning advisor are my best bets
Profiler yes, DTA absolutely not. I'm currently making nice money cleaning up the mess that DTA made...
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
June 28, 2011 at 5:01 am
I need specifics please.
SELECT @@version
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
June 28, 2011 at 4:53 am
What version of SQL?
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
June 28, 2011 at 4:18 am
That'll 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
June 28, 2011 at 4:14 am
Syed Jahanzaib Bin hassan (6/28/2011)
consider Backup also
Before rebuilding an index?
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
June 28, 2011 at 3:09 am
Syed Jahanzaib Bin hassan (6/28/2011)
sp_help_revlogin recovery store procedure is available by microsoftvisit this link and get the required userid password with the help of this script
sp_help_revlogin is used to copy...
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
June 28, 2011 at 3:06 am
What are your downtime and data-loss SLAs?
What's the budget for DR?
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
June 28, 2011 at 2:59 am
Illegal_Operation (6/27/2011)
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
June 28, 2011 at 2:54 am
Viewing 15 posts - 25,306 through 25,320 (of 49,552 total)