Viewing 15 posts - 28,441 through 28,455 (of 49,552 total)
bitbucket-25253 (1/16/2011)
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
January 16, 2011 at 9:56 am
balasach82 (1/16/2011)
Assuming I dont have an extended support and have SP3, does it mean, that if I have any precarious situation, then I cant approach MS. right?
Pretty much, yes. Without...
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
January 16, 2011 at 5:55 am
It ended a long time ago. Only way you can get SQL 2000 support is if you're a premier customer and have purchased extended support.
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
January 16, 2011 at 3:59 am
That database design looks terrible. Whoever 'designed' it apparently didn't know much about normalisation.
Anyway, the key to fast data retrieval is good indexes and well written queries. What indexes do...
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
January 16, 2011 at 3:38 am
Varchar of what length?
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
January 16, 2011 at 3:35 am
gvrsony (1/16/2011)
I have requirement to create a SSIS package in JAVA, so i need your help.
Why?
Short of hand-crafting the XML (which would be ludicrous) I don't think it's possible. An...
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
January 16, 2011 at 3:35 am
Tom.Thomson (1/15/2011)
Nice easy question, nice clean answer.But why on earth is it worth 2 points?
Want to take a guess how many get page and extent wrong?
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
January 16, 2011 at 3:24 am
Truncate != Shrink
Shrink removes unused space so that next time the log needs that space it has to grow.
Truncate means discard inactive log records. It breaks the log chain, log...
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
January 16, 2011 at 3:23 am
The problem has nothing to do with the windows version. The problem is that the source of that backup is SQL 2008 R2, not SQL 2008. It's a higher 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
January 14, 2011 at 3:05 pm
Why are you truncating the transaction logs? Do you know what that's going to do to your log chain and your ability to restore to point-in-time?
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
January 14, 2011 at 3:02 pm
Maybe. Probably.
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
January 14, 2011 at 2:09 pm
Jpotucek (1/14/2011)
I will uninstall my sharepoint instance and start again.
There is absolutely no need for that.
Make sure SQL has full control over the folder for TEmpDB
Connect to SQL (while it's...
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
January 14, 2011 at 2:05 pm
Indianrock (1/14/2011)
It looks like following the installation of Sql 2005 64bit the new system database area was renamed to "old" and the 32bit folder was kept.
Be grateful nothing broke....
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
January 14, 2011 at 1:42 pm
You're still missing the file names, same as you were when you first ran it and broke SQL.
Run the correct alter database, with the full filenames specified, then restart...
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
January 14, 2011 at 1:17 pm
The definitions of the dmvs aren't in master, they're in the system resource DB. That would have been upgraded during the patch, providing nothing went wrong during the installation.
As far...
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
January 14, 2011 at 1:08 pm
Viewing 15 posts - 28,441 through 28,455 (of 49,552 total)