Viewing 15 posts - 37,561 through 37,575 (of 49,552 total)
Lynn Pettis (7/19/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 4:48 am
Dave Ballantyne (7/20/2009)
Is it just me who internally screams , UNDERSTAND WHAT YOU ARE DOING.
Nope, not at all.
Some people want to be spoon-fed and not have to (horror) actually think...
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:43 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/
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:41 am
awp (7/19/2009)
I think Gail’s design suits much better for this purpose, but to implement this, I need to rebuild the whole thing again.
Yeah, that is the downside, but at...
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 3:50 am
Vinoo (7/19/2009)
GilaMonster (7/18/2009)
Did you change the names to obfuscate things, or are the columns really called that?
How does that matter to solve the problem? you can have any name 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
July 20, 2009 at 3:17 am
rambilla4 (7/19/2009)
Can we restore ONLY prod_2.ndf file from the backup file PROD.bak??
Providing that you have log backups from the time of that full backup up until present, you should 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
July 19, 2009 at 2:31 am
If that's the case, this design may work better. I'd still like more info to be sure.
CREATE TABLE StudentAssessments (
StudentID int, -- foreign key to student table
TeacherID int,...
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 19, 2009 at 2:24 am
Mangled up = bad data, misleading data, loss of integrity, etc.
Can you maybe explain a bit more what this table is used for and how it's used. It; almost sounding...
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 18, 2009 at 3:19 pm
No one said anything about data corruption.
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 18, 2009 at 2:33 pm
sudhakara (7/18/2009)
1) Do you think creating data files equalent to Cpu Processor will create problem ? or will not readuce the contention ?
It'll help, but more than 8 files...
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 18, 2009 at 2:33 pm
awp (7/18/2009)
Sorry I didn't mean to confuse things by changing the names; I thought the names are irrelevant in this context, data types need to be correct.
If those had...
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 18, 2009 at 11:53 am
You can't put a custom error in a check constraint.
Two options.
1) (recommended)
Use a check constraint, have the front end app handle the error and produce whatever custom error that 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
July 18, 2009 at 11:46 am
Kenneth Gladden (7/17/2009)
What am I doing wrong?
The only comparisons with null that can return true are IS NULL and IS NOT NULL
http://sqlinthewild.co.za/index.php/2008/01/16/comparisons-with-null/
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 18, 2009 at 10:46 am
maxyogesh2002 (7/18/2009)
Is this true that Update SQL Query is slower because of Clustered index??????
Unlikely. Nonclustered indexes may slow a data modification down, because the change has to be made in...
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 18, 2009 at 10:42 am
Did you change the names to obfuscate things, or are the columns really called that?
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 18, 2009 at 9:24 am
Viewing 15 posts - 37,561 through 37,575 (of 49,552 total)