Viewing 15 posts - 37,576 through 37,590 (of 49,566 total)
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...
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/
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...
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...
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...
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,...
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...
July 18, 2009 at 3:19 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...
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...
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...
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/
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...
July 18, 2009 at 10:42 am
Did you change the names to obfuscate things, or are the columns really called that?
July 18, 2009 at 9:24 am
Jeff Moden (7/18/2009)
Now, if you throw in an inequality, all bets are off because you've just built a triangular join.
Inequality or a TOP 1 ... ORDER BY. Both of...
July 18, 2009 at 9:02 am
Viewing 15 posts - 37,576 through 37,590 (of 49,566 total)