Viewing 15 posts - 1,906 through 1,920 (of 6,036 total)
Nevyn (4/28/2015)
Sergiy (4/27/2015)
By all means - NO!
Compare E8:AB:... and e8-ab-...
These are completely different strings, but they present the same MAC address.
Just another example of...
April 28, 2015 at 2:32 pm
CELKO (4/23/2015)
April 28, 2015 at 1:20 am
MAC address - is it a string?
By all means - NO!
Compare E8:AB:... and e8-ab-...
These are completely different strings, but they present the same MAC address.
Just another example of an identifier...
April 27, 2015 at 11:20 pm
CELKO (4/22/2015)
April 27, 2015 at 8:23 pm
Would not it be easier to change connection string on the client side?
With this approach any connection opened to the main DB would be completed against the main DB, no...
April 27, 2015 at 10:15 am
SELECT TOP 5
lt1.col1, lt1.col2, lt1.id, SUM(lt2.col3) AS Result
FROM dbo.MyTable1 lt1
LEFT JOIN dbo.MyTable2 lt2 ON lt2.col1 = lt1.col1 AND lt2.col2 = lt1.col2 AND lt2.id = lt1.id
GROUP...
March 31, 2015 at 3:37 pm
I'd check if it possible to make ABS a computed column (persistent, if necessary).
Anyway, threre is no point in loading incorrect data jusy to discard it immediately.
If computed column is...
March 30, 2015 at 10:05 pm
What do you mean "quickly"?
is it "within shortest possible time" or "with shortage possible data access outage"?
March 30, 2015 at 9:49 pm
Check for uniqueness of PracticeID in dbo.Practice
March 9, 2015 at 6:34 pm
Jeff Moden (3/8/2015)
Not sure why it didn't work out that way on my box. Heh... and no... it wasn't due to limited column width. ๐
Probably it has...
March 8, 2015 at 10:22 pm
jdbrown239 (3/5/2015)
I have the task of running multiple updates to a table with a row count of 107 million.
That's sounds plain wrong.
There should not be such task.
If not a...
March 7, 2015 at 2:46 am
Jeff Moden (7/5/2011)
If you notice, the final entry didn't really get as close to zero as bankers and little ol' ladies with umbrellas would like. ๐
Man, expand the boundary...
March 7, 2015 at 1:40 am
Perhaps this reading would be useful here:
http://databases.about.com/od/specificproducts/a/normalization.htm
2nd normal form is what you need to solve the problem.
All the name variations must be removed to a separate table.
March 3, 2015 at 5:52 am
Do BACKUP LOG - it will free the space in the log file.
And while you have 2 drives - keep mdf and ldf apart from each other.
Move mdf back...
March 3, 2015 at 3:30 am
Actually, the issue is absolutely valid and comes from the sequence of the query execution.
HAVING is executed after GROUP BY and is applied to the values calculated by the GROUP...
March 2, 2015 at 7:47 pm
Viewing 15 posts - 1,906 through 1,920 (of 6,036 total)