Viewing 15 posts - 34,846 through 34,860 (of 49,552 total)
ifila (1/10/2010)
BTW all i am trying to do is limit the number of records i am counting....pretty simple really. I just dont know the correct syntax.
It probably is, but...
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 10, 2010 at 9:32 am
repent_kog_is_near (1/10/2010)
I want to know if there is a sure way to know if SQL Server has more memory than it needs especially in the 64 bit OS environment.
Unless 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
January 10, 2010 at 9:24 am
According to wikipedia (questionable accuracy, I know), JHB is bigger in population, though only just.
Population
Cairo: 17,856,000 (Cairo metropolitan area)
JHB: 10,267,700 (the greater JHB metro area. Same as with London, 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
January 10, 2010 at 4:41 am
lobbymuncher (1/10/2010)
You have to ask yourself if individuals with this attitude, when skilled up to write decent TSQL, would make decent workmates.
Not one I'd ever want to work with.
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 10, 2010 at 3:04 am
I ran across this late last night, linked from, of all places, a fitness site. Several points that I greatly agree with.
hackers have a reputation for meeting simple questions with...
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 10, 2010 at 3:02 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
You said you want the 'first row'. 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
January 10, 2010 at 2:39 am
Truncate Table is the fastest. It shouldn't take that long, sure it's not blocked by other transactions. Check sys.dm_exec_requests
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 10, 2010 at 2:39 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic845001-148-1.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
January 10, 2010 at 2:38 am
*deleted. I quoted instead of editing*
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 10, 2010 at 2:22 am
Lynn Pettis (1/9/2010)
Gail calls South Africa home. Can't recall off hand what town (or city).
The biggest city south of the Sahara. (not sure if Cairo's bigger or smaller, but...
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 10, 2010 at 2:19 am
Paul White (1/9/2010)
It seems there is a trace flag for everything :w00t:
Very likely. I just wish there was a list of the documented ones, rather than having to check every...
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 10, 2010 at 2:17 am
All that's saying is that some of the installation files are missing. I think you're going to have to find the original installation disks for the app and reinstall completely...
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 9, 2010 at 11:39 am
Lowell (1/9/2010)
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 9, 2010 at 11:32 am
Actually, I just remembered, there's a traceflag that, when enabled, writes information on the checkpoint phases into the error log. It's one of those that you're not really supposed 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
January 9, 2010 at 11:31 am
Step 1, restore a good backup. If you don't have a backup (why not) try CREATE DATABASE ... FOR ATTACH_REBUILD_LOG
If that doesn't work, check out the steps here: http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-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 9, 2010 at 11:16 am
Viewing 15 posts - 34,846 through 34,860 (of 49,552 total)