Viewing 15 posts - 36,751 through 36,765 (of 49,552 total)
mazzz (8/28/2009)
GilaMonster (8/28/2009)
He also insisted that anyone who dressed casual or semi-casual was ignoring reality and would never get a top job
at any time, or just at work?
I now have...
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
August 28, 2009 at 7:53 am
Silverfox (8/28/2009)
I take my hat (if i had one) off to people who constantly answer their questions, knowing that they have already asked the same question in multiple topics.
There'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
August 28, 2009 at 7:50 am
He also insisted that anyone who dressed casual or semi-casual was ignoring reality and would never get a top job
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
August 28, 2009 at 7:31 am
SQL from 2005 onwards handles the NUMA architecture just fine. However, with 4 cores (how many physical processors?) and 6 GB memory, I don't see how the memory can be...
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
August 28, 2009 at 7:26 am
Is there a question here? Are you concerned about the backup file size and, if so, why?
Full database backup or log backup?
How big's the data file? How much 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
August 28, 2009 at 7:04 am
No idea offhand. This might be something worth contacting customer support about. I could understand if the Hyperthreading was enabled, but not when it's disabled.
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
August 28, 2009 at 6:57 am
If cannot be used within a query. The CASE statement is what you want. There should be some good examples on how to use it in Books Online.
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
August 28, 2009 at 4:30 am
Not uncommon. CheckDB repair deallocates pages to fix the errors, not unusual to have errors in the nonclusters afterwards.
Run CheckDB again, this time with the repair_rebuild option. Afterwards, run checkDB...
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
August 28, 2009 at 4:26 am
Rob de Vos (8/28/2009)
I then did
BACKUP LOG Gemini 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
August 28, 2009 at 4:23 am
sp_updatestats only updates stats that SQL thinks are outdated. When upgrading you need to update all statistics. Use UPDATE STATISTICS.
If it's still slow after that, please post table definitions, 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
August 27, 2009 at 11:18 pm
Grant also wrote a full (paper) book on Query tuning - SQL Server 2008 Query performance tuning distilled (or something like that). Also check out the last of the Inside...
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
August 27, 2009 at 11:17 pm
JonJon (8/27/2009)
Standard, that is why I was curious abuot the/3GB option
When you asked about memory above 2GB, I assumed it was enterprise as there's no reason for asking about memory...
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
August 27, 2009 at 11:14 pm
Paresh Prajapati (8/27/2009)
As per Loop join have more and cpu cycle i think, Am i right?
No you're not. It depends on what they're joining.
If one join type always used more...
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
August 27, 2009 at 11:10 pm
GSquared (8/27/2009)
Lynn Pettis (8/27/2009)
Asking this:
i need the query(dbname,size,recoverymodel) for all databases in a server.
tells me you haven't even tried to find an answer yourself 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
August 27, 2009 at 3:38 pm
Maxer (8/27/2009)
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
August 27, 2009 at 3:17 pm
Viewing 15 posts - 36,751 through 36,765 (of 49,552 total)