Viewing 15 posts - 32,521 through 32,535 (of 49,552 total)
Good luck with your devs. 🙂
Re backups, I just wanted to check that you were using a compressed backup tool.
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 10, 2010 at 7:42 am
Denesh Naidoo (6/10/2010)
My question is...do I need to change the recovery model first before truncating then shrinking or should I truncate, shrink and then change the recovery model
Neither. Change 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 10, 2010 at 7:26 am
When you need the SQL server to access network resources off the local machine. File shares, backup locations, replication, log shipping, etc.
It is a recommended practice to have SQL using...
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 10, 2010 at 1:23 am
Identity column with either scope_identity or the output clause?
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 10, 2010 at 1:21 am
Try the REPLACE function.
http://msdn.microsoft.com/en-us/library/ms186862.aspx
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 9, 2010 at 11:40 pm
What's wrong with an identity column?
It'll save you a lot of grief in the long run. The manually updated key in a sequence table can be done, but there...
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 9, 2010 at 11:33 pm
http://sqlinthewild.co.za/index.php/2008/11/04/what-are-statistics-and-why-do-we-need-them/
Don't trust DTA. Test, test, test that those stats are actually useful, that they really do help query performance. I'll be honest, it's unlikely that you'll need all 12, if...
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 9, 2010 at 11:31 pm
lightrk (6/9/2010)
i got only 14 days trail version .if anyone have crack or serial,keygen plz share ...
Excuse me?
If it's worthwhile for you, bloody well put some money down for...
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 9, 2010 at 11:28 pm
I'm not really a major sports fan, I'll do some research when I have a little 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
June 9, 2010 at 11:24 pm
Greg Roberts-134214 (6/9/2010)
Also, the app devs haven't yet figured out how to alter their application to properly failover. (That is being developed as we speak.)
If they're using SNAC (SQL Native...
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 9, 2010 at 3:13 pm
What 3rd party backup tool are you using?
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 9, 2010 at 3:02 pm
Ray K (6/9/2010)
Maybe at 868, you could have "The Story of Oh" (as in Sadaharu Oh) :hehe:
Have some pity on the non-US people...
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 9, 2010 at 2:39 pm
Simple answer for your boss. You can't.
A snapshot only contains old values of pages changed in the source database since the snapshot was created. When you revert the source to...
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 9, 2010 at 2:37 pm
The Dixie Flatline (6/9/2010)
It's almost 10pm, and there are still people blowing those things nearby. OK, I do live just off a fairly major road, but still, enough already.
Here's some...
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 9, 2010 at 2:33 pm
Stefan Krzywicki (6/9/2010)
GilaMonster (6/9/2010)
Am I missing something here? http://www.sqlservercentral.com/Forums/Topic934829-146-1.aspx
Not that I can see. Base on the limited and incomplete information being provided, it does seem as if he or she...
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 9, 2010 at 1:52 pm
Viewing 15 posts - 32,521 through 32,535 (of 49,552 total)