Viewing 15 posts - 5,476 through 5,490 (of 14,953 total)
Yes, Merge is better than Update From. I didn't notice this was 2k8 or I'd have mentioned that too.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 4, 2011 at 2:10 pm
One of the comparisons I found, http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server.html, by MySQL's Dir Product Mgmt, is pretty fair about the comparison. He admits there are features MySQL doesn't have and won't have...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 4, 2011 at 2:06 pm
I'd take a dev copy of the database, on separate hardware, and try a few different partitioning schemes on it. You'll get workability and performance answers that apply to...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 4, 2011 at 2:03 pm
Other than joining them together, the only thing I can think of is using Union to hook them together, then using Pivot/Unpivot to get them in the form you want....
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 4, 2011 at 2:00 pm
Jeff:
I did a speed test like this:
SET NOCOUNT ON;
go
IF OBJECT_ID(N'tempdb..#Strings') IS NOT NULL
DROP TABLE #Strings;
IF OBJECT_ID(N'tempdb..#T1') IS NOT NULL
DROP TABLE #T1;
IF OBJECT_ID(N'tempdb..#T2') IS NOT NULL
DROP TABLE #T2;
IF OBJECT_ID(N'tempdb..#T3') IS NOT...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 4, 2011 at 12:04 pm
All the data on backups in your server is stored in msdb, in the system tables named things like "backupset". There's a column in msdb.dbo.backupset called "software_vendor_id", which will...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 4, 2011 at 10:45 am
GilaMonster (1/4/2011)
Koen (da-zero) (1/4/2011)
GilaMonster (1/4/2011)
<sigh> Talking plagiarism. He really should know better...http://www.sqlservercentral.com/Forums/Topic1042151-2799-1.aspx
Waw, LutzM's reply is really brutal 😀
(but I'm thinking the same thing)
Missed it when Steve cleaned up. Someone enlighten...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 4, 2011 at 10:34 am
Do you have specific questions or problems you're running into?
I see some tables, and some procs that access those tables, but I can't tell what the business rules are for...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 4, 2011 at 10:32 am
Sometimes, with 3rd party software, you really don't have the option of making it be sane. Some of it, often from the biggest software companies, ones that really should...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 4, 2011 at 10:09 am
Just keep telling yourself "It's a common mistake. Any plonk ... anyone could have made it." You'll feel better. :hehe:
Honestly, it is a common mistake. It usually...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 4, 2011 at 10:05 am
If you set a max file size, and it runs out of space, it will crash and burn to one extent or another. It's usually recoverable, but it will...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 4, 2011 at 10:02 am
Ah. No, don't modify the function. Take your original query, and use the function instead of your Upper/Lower pieces.
Lowell posted an example a few posts back. Take...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 4, 2011 at 10:00 am
Brandie Tarvin (1/4/2011)
What types of articles do you like best? The kind that are most "talk" and little code, the kind that...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 4, 2011 at 9:58 am
Rebuilding indexes takes space in the file, unless you specify doing the work in tempdb (check the documentation on rebuilding for the option for that). Once it's done, it...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 4, 2011 at 9:50 am
Just put the column name in there instead of the variable.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 4, 2011 at 9:47 am
Viewing 15 posts - 5,476 through 5,490 (of 14,953 total)