Viewing 15 posts - 691 through 705 (of 14,953 total)
I'd have to see both execution plans, at the very least, to help more on this. Can you post those?
- 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
October 9, 2012 at 11:26 am
Nadrek (10/8/2012)
GSquared (10/8/2012)
Nadrek, please add to your list, "Download using a disposable machine".
Hmm... I'll rate that one just below the two LiveCD ones, both of which should be considerably easier...
- 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
October 8, 2012 at 1:47 pm
I don't think it really matters which one you use in this case. I'd probably go with a trigger, because I dislike complex constraints, but that's just a personal...
- 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
October 8, 2012 at 11:05 am
Nadrek, please add to your list, "Download using a disposable machine".
I have an older desktop PC that still works. I flash (image) the drive after a clean installation of...
- 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
October 8, 2012 at 11:00 am
Every DBA interview I've ever had, what they actually wanted was "master of all trades", but what they'll settle for is "jack of all trades, master of the ones 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
October 8, 2012 at 10:51 am
Artoo22 (10/8/2012)
If you cast your VARCHAR(MAX) to XML then SSMS can display the entire contents in an XML editor window.
DECLARE @Cmd NVARCHAR(MAX);
SET @Cmd = CAST('/*' AS NVARCHAR(MAX)) + REPLICATE(CAST('x' AS...
- 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
October 8, 2012 at 8:37 am
I've actually had managers tell me to pad my estimates on how long something will take, "just in case".
I occassionally have something go over my original estimate, but not often....
- 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
October 8, 2012 at 8:33 am
You'll get an error message from the SQL Server engine if that happens.
If you want to do more with it, check out @@Error, and Bing/Google "sql 2000 error-handling" for numerous...
- 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
October 8, 2012 at 6:58 am
The problem will be the UI, not varchar(max) nor replace().
SSMS, for example, will cut off at 8k characters, when it's displaying the data.
Try this:
USE ProofOfConcept;
GO
DECLARE @Cmd NVARCHAR(MAX);
SET @Cmd = CAST('/*'...
- 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
October 8, 2012 at 6:54 am
Sent my copy over to him. Assuming USPS doesn't lose it or anything like that, should be there soon enough.
- 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
October 8, 2012 at 6:23 am
EdA ROC (10/5/2012)
sp_who2 should have had a bit in the BlockBy column showing your open transaction blocking your other update. Won't see it now, but you could reproduce it by...
- 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
October 8, 2012 at 6:22 am
2008. Since it touches on that, and you won't be able to use 2008-only features in any lessons/examples, if you use SQL 2005 with it. I don't think...
- 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
October 5, 2012 at 12:25 pm
Are the two uses of the query identical? "Select * from MyView" vs just running the exact query in the view without modification?
If so, have you checked for blocking...
- 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
October 5, 2012 at 12:23 pm
EdA ROC (10/5/2012)
It's known as UPDATE FROM, and it's typically used to update a table with data from another and / or update a table filtered by a join with...
- 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
October 5, 2012 at 7:53 am
You don't need to change the structure, so far as I can tell. Just modify my queries to use your tables. Instead of Calendar_Users, it's your DateSkip table,...
- 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
October 5, 2012 at 7:49 am
Viewing 15 posts - 691 through 705 (of 14,953 total)