Viewing 15 posts - 5,056 through 5,070 (of 6,486 total)
First - don't cross-post. Having the SAME question posted 4 times is wasteful, doesn't help you cause at all (especially when you post them in non-relevant subject areas)....
January 25, 2008 at 8:16 am
I second that - the wheelman is the usually one to get blamed, even if his boss told him to drive blindfolded over the cliff......
One last thought that usually makes...
January 25, 2008 at 7:43 am
Well - depending on what the purpose is - no - it's not overkill. Actually - if it's really critical, then BOTH sides need to check (the UI side...
January 25, 2008 at 7:38 am
Have you actually gone in to the Surface area configuration tool and enabled remote connections? from the server console on the box you can't talk to?
By default the install...
January 24, 2008 at 9:40 pm
DateTime fields in SQL Server have a precision of 3ms, so in SQL Server's world
2008/01/24 17:22:15.000=2008/01/24 17:22:15.001 =2008/01/24 17:22:15.002
2008/01/24 17:22:15.003=2008/01/24 17:22:15.004 =2008/01/24 17:22:15.005
January 24, 2008 at 3:24 pm
Personally - I'd prevent this on the UI side (wherever they're picking the colors from). If that's a scenario you want to prevent - I wouldn't let it be...
January 24, 2008 at 3:03 pm
The point is they serve different purposes, and as a result aren't necessarily the SAME (set of) column(s).
Primary keys are used in setting up relationships. Clustered indexes (and yes...
January 24, 2008 at 1:55 pm
..with the caveat that aggregate functions don't work against various datatypes like text, NTEXT, IMAGE or XML...
January 24, 2008 at 12:24 pm
By the way - I just noticed you posted this to the 2005 board. If you ARE in 2005, there's a really simple way to disable it... disable...
January 24, 2008 at 12:07 pm
Does this table have a clustered index? Because heaps (tables without a clustered index) essentially can't be defragmented: the only way to approximate it is to create another table...
January 24, 2008 at 11:39 am
Try switching this over to an EXISTS instead:
WHERE
....
AND
NOT EXISTS ( select *
...
January 24, 2008 at 11:12 am
how about
...
Case when value=0 then 'OFF' else 'ON' end
...
January 24, 2008 at 10:56 am
Steve Jones - Editor (1/24/2008)
You also don't save money on licensing, in fact, it's worse than instances on Enterprise. You need to license each instance.
Per SQL Server's "How to license".
For...
January 24, 2008 at 10:16 am
You might care to dump the two derived tables into indexed temp tables and run your join against that. With that many records, you've got to be making the...
January 24, 2008 at 10:07 am
Viewing 15 posts - 5,056 through 5,070 (of 6,486 total)