Viewing 15 posts - 37,546 through 37,560 (of 49,552 total)
Who's teaching the class?
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
July 20, 2009 at 9:13 am
Gift Peddie (7/20/2009)
How many blacks are in your South African developers group? and please I need to know how many are black women.
Blacks aren't a minority group in South...
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
July 20, 2009 at 9:09 am
I can't see anything that's forcing the scan. Makes no sense...
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
July 20, 2009 at 8:08 am
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
July 20, 2009 at 8:05 am
Gianluca Sartori (7/20/2009)
I don't think this means something like "Are the posted questions getting BETTER?"
Should I start...
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
July 20, 2009 at 7:53 am
Edit: Nevermind....
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
July 20, 2009 at 7:25 am
Can you post the table and index definitions for the two tables please? I'm guessing it has something to do with the checks for matching foreign key records.
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
July 20, 2009 at 6:57 am
Mark Horninger (7/20/2009)
I found that studying and working toward an exam - researching - forced me to learn stuff I wouldn't have learned otherwise.
Agreed. That's why...
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
July 20, 2009 at 6:43 am
Bob Matthews (7/20/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
July 20, 2009 at 6:39 am
Gift Peddie (7/19/2009)
I am saying even open book most minorities and women may not pass these exams.
Are you implying that woman and minorities are stupid in that they can't...
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
July 20, 2009 at 6:36 am
Did the data file grow or did the log file grow? Shrink is a logged operation and it's not unexpected if the log file grows while the data file shrinks.
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
July 20, 2009 at 6:25 am
Can you post the full definition of the tables and the entire deadlock graph please?
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
July 20, 2009 at 6:21 am
rvje (7/20/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
July 20, 2009 at 5:02 am
MADHAN_PERS (7/20/2009)
SYS.CONFIGURATIONS Derive information from mssqlsystemresourcedatabase which is a hidden system databaase.
The definition of the sys.configurations view is in the resource DB, but the info that it retrieves is not....
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
July 20, 2009 at 5:00 am
ps (7/20/2009)
2. backup database using a shared path pointing to your client(of course, you need a shared folder on client's machine)
backup database mydb to disk='\\myMachine\myBackupFolder\myDB.bak'
That will only work if 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
July 20, 2009 at 4:54 am
Viewing 15 posts - 37,546 through 37,560 (of 49,552 total)